Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events page! (Direct link to WMV.) Tomorrow (as of the blog’s publish date) at8:30am, I will be teaching “T-SQL’s Hidden Support Feature” at SQL Saturday Oklahoma City (totally free, did you know? Free IT training, y’all.) I said […]
Category: Tech and Learning
Tricky TSQL: NOT IN (NULL)
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means “I don’t know”. It stand for an unknown value. Nothing can be equal to NULL. We simply can’t say that 1 = NULL, or ‘ABBA’ = NULL, because we don’t know what value NULL might possibly be […]
Slash star, dash dash: Be obsessive about comments
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the reasons why I’m writing and presenting an hour long session on /* */ and — a bit later, but first: Why am I calling comments a “hidden support feature”? Comments themselves aren’t hidden; it’s the […]