Category: SQL Server

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.

SQL Server 2012 Service Pack 2 Cumulative Update #8

SQL Server 2012 Service Pack 2 Cumulative Update #8

Microsoft has released Cumulative Update #8 for SQL Server 2012 Service Pack 2. KB Article: KB #3082561 24 fixes total (23 fixes listed publicly at time of publication)  Build number is 11.0.5634  Relevant for...

SQL Server 2014 RTM Cumulative Update #9 is available!

SQL Server 2014 RTM Cumulative Update #9 is available!

Microsoft has released Cumulative Update #9 for SQL Server 2014. See this blog post for more information. KB Article: KB #3075949 30 fixes listed publicly at time of publication (31 total) Build number is...

SQL Server 2014 Service Pack 1 Cumulative Update #2 is available!

SQL Server 2014 Service Pack 1 Cumulative Update #2 is available!

Microsoft has released Cumulative Update #2 for SQL Server 2014 Service Pack 1. See this blog post for more information. KB Article: KB #3075950 46 fixes listed publicly at time of publication (51 total)...

SQL Server 2012 Service Pack 2 Cumulative Update #7

SQL Server 2012 Service Pack 2 Cumulative Update #7

Microsoft has released Cumulative Update #7 for SQL Server 2012 Service Pack 2. This update has 38 fixes, including the QFE security fix from MS15-058. If you've installed MS15-058 (either the QFE – 11.0.5613...