Category: All Things MidnightDBA

Contest: Who Wants to Attend InapproPASS?

If you missed out on the initial run to register for the unofficial PASS Summit Inappropriate PASS Sessions event, take heart…there is a ray of hope. Send us your Inappropriate PASS session idea before midnight of Sunday November 7 (that’s this weekend, kids). We’ll pick the one we like best and announce the winner at […]

MERGE Statement Corrected, or, How to Eat Crow in Public

I have no excuse, none whatsoever. In my T-SQL Brush-Up presentation to the North Texas SQL Server User Group (NTSSUG) in September – and again in the T-SQL Brush-Up 24HOP session I gave that same day – I mentioned that you can only have one WHEN NOT MATCHED clause in a MERGE statement (as per SQL […]

Attend the PASS Summit From Home

You there, sitting in your cube and fuming at all the PASS Summit talk: you couldn’t talk your company into sending you to PASS this year, could you? Or, you got on the bandwagon too late. Whatever the reason, you’re stuck working next week, and you’re mad. We feel your pain, and we’re here to […]