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 […]
Category: Dev
Video: Designing Stored Procedure Solutions
My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code! This month, I gave this session at the Oklahoma City SQL Server User Group‘s 5 year anniversary, and at the Alaska SQL User Group, to thousands and thousands* of attendees and wild** applause. I’m looking […]
Tip: COLLATE for “Cannot resolve collation conflict” error
Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second group tends works in shops that leave everything on default. A huge portion of my career has been spent as a member of that “Custom collation? What custom collation?” crowd, and so I rarely get an […]