Author: Aaron Bertrand

T-SQL Tuesday #121 : Gifts

For this month's T-SQL Tuesday, I talk about an opportunity earlier this year to significantly change my career trajectory.

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.

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.