October 2021
A handy search procedure

Updated this stored procedure I wrote a decade ago to search for a string in procedure bodies, object names, job steps, and more…

Bad Habits to Kick: Abusing bit columns

I talk a bit about bit columns: names with negative context, allowing NULLs, and using cryptic BITWISE operators instead of readable, self-documenting expressions.