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.
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.
Forced Parameterization can be a useful setting to tune workloads, but this can work against you if you're also using filtered indexes.
Give your Docker container port numbers meaning to avoid confusion, especially when presenting or giving demos.
Originally published in 2009, I updated this in 2019 with an example showing an effect on the plan cache.
Aaron shares his slides and demos from his most recent delivery of T-SQL : Bad Habits and Best Practices.
Did you know that not all characters can be used as the separator for STRING_SPLIT?
One of the biggest downsides of using SQL Server Management Studio as an interactive query tool is the limit on text/grid output. SSMS 18.2 fixes that!
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 @@VERSION 11.0.5058 through 11.0.5633
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 12.0.2553 Relevant for @@VERSION 12.0.2000 through 12.0.2552 Note: This cumulative update is only for RTM – […]
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) Build number is 12.0.4422 Relevant for @@VERSION 12.0.4050 through 12.0.4421 Note: This cumulative update is only […]
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 – or the GDR – 11.0.5343), you can still install this cumulative update. If you haven't […]