Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
See one approach to collecting extended properties information across all of the databases on a server.
Break free from the limitations of history retention and take control at the job or even step level.
See what improvements were made in SentryOne Plan Explorer 19.0.2.
Get a quick overview of one of the most important features in SQL Server 2019.
Aaron Bertrand shares his slide deck from a recent presentation at the Charlotte SQL Server User Group, "Fix Slow Queries. Fast."
In part 2 of this series, we add another way to further isolate multiple threads of a bulk import process.
In the first of a 2-part series, see how you can easily reduce contention between multiple bulk import threads.
This tip shows a neat trick with CROSS APPLY that lets older versions of SQL Server ignore columns in your metadata queries that don't exist yet.
Read a quick overview Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.
If you use scalar user-defined functions, and can't take advantage of new handling in SQL Server 2019, see some other ways to reduce the impact on performance.
Aaron Bertrand announces the recipient of his third annual Community Influencer of the Year award.
I recap a grand total of FIFTY entries in this month's T-SQL Tuesday. A lot of interesting submissions!
For my T-SQL Tuesday entry, I show off my hockey and football card collection, license plates from all over the world, and a very special collection of "Everything Happens to Aaron" books.
For this month's T-SQL Tuesday, I would love to hear about something you are passionate about, outside of the SQL Server or tech community.
Some background and disclaimers about moving my content from sqlblog.com to sqlblog.org.
SQL Server has released SQL Server 2012 Service Pack 3. You can download here and see some other details here. Build number is 11.0.6020.0 37 fixes (see the full list in KB #3072779) SP3...
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...
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...
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)...
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...