October 2019
Simulating ON DELETE CASCADE

See how to generate a set of scripts that will delete rows from dependent tables and show you how many rows will be deleted from each.

T-SQL Tuesday #119: Changing my mind

For this month's T-SQL Tuesday, I talk about an incident where I've changed my mind about something I was previously pretty stubborn about.

Document columns across systems

Find out how to use dynamic SQL to quickly generate metadata queries to pull attributes for all columns across a database or even a set of databases.