There’s no substitute for mentoring
There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely...
2017-07-18
344 reads
Jen McCown
Employees, encourage work from home
The discussion around the last article I wrote on work from home (WFH) has been wonderful, but there is one...
2017-05-22
397 reads
Employers, let your people work from home
Work from home is, astoundingly, still not the norm in United States IT offices. This is ludicrous, because employees want...
2017-05-17
436 reads
I’m going to make you love backups
On April 12, I'm going to show you about two dozen ways to make your backups better, easier, faster, and...
2017-04-04
344 reads
The Public Speaking Roadmap
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like....
2017-03-25
327 reads
Compare column names for case sensitivity
I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in...
2017-01-25
730 reads
Webinar: Introducing Minion CheckDB!
Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two...
2017-01-19
828 reads
Database snapshots for everyone!
If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots...
2017-01-05
612 reads
Why won’t my SP work THIS time?
Why won't my SP work? I did this exact thing. You're never too old to do something like this.
The post...
2016-12-09
553 reads
December: A two-line play.
“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life...
2016-12-05
591 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
50 Years of Microsoft
Comments posted to this topic are about the item 50 Years of Microsoft
Multiple Collations
Comments posted to this topic are about the item Multiple Collations
Retrieving Data Using the REST API in Data API Builder
Comments posted to this topic are about the item Retrieving Data Using the REST...
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers