Focus Groups at PASS Summit 2019
Register now for focus groups hosted by the product teams at PASS Summit next week!
Monthly Archive: 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.
Impact of UTF-8 support in SQL Server 2019
I take a quick look at the performance and storage impact of the new UTF-8 collations in SQL Server 2019.
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.