Category: Beginner

The #TSQL2sday #70 roundup

Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully. Here we go. Rob Farley : Superhero powers for managing the enterprise. Rob talks about  what his consulting company looks for when talking to a customer. Specifically, things that are out of the ordinary. And of […]

Beginning T-SQL slide deck and recording – #SQLSatBR

I had a great time in my Beginning T-SQL presentation here at SQL Saturday Baton rouge! Here is the BeginningTSQL slide deck (PDF). Here is an older recording of the class, as I haven’t yet had time to process today’s recording. Thanks to those who attended! Remember: SQL Server Books Online is at http://Technet.Microsoft.com I’m on […]

“Thing IS NOT NULL” isn’t the same as “Thing != NULL”

I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)  And yet, it’s worthwhile to bring these things up from time to time. “[Thing] != NULL” is nonsense. It won’t work the way you want it to work, because NULL literally means “unknown”. Nothing in the […]