Charlotte SQL Server User Group : Fix Slow Queries. Fast.
Aaron Bertrand shares his slide deck from a recent presentation at the Charlotte SQL Server User Group, "Fix Slow Queries. Fast."
Scale SQL Server Bulk Loading On a Budget – Part 2
In part 2 of this series, we add another way to further isolate multiple threads of a bulk import process.
Scale SQL Server Bulk Loading On a Budget – Part 1
In the first of a 2-part series, see how you can easily reduce contention between multiple bulk import threads.
Make SQL Server DMV Queries Backward Compatible
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.
Scalar UDF Inlining in SQL Server 2019
Read a quick overview Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.
Four ways to improve scalar function performance in SQL Server
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.
2018: Community Influencer of the Year
Aaron Bertrand announces the recipient of his third annual Community Influencer of the Year award.
T-SQL Tuesday #99 : The Roundup
What a great experience to host T-SQL Tuesday #99. I could not have predicted that so many of you would be willing to share personal details about your life outside of SQL Server, and...
T-SQL Tuesday #99 : Random Collections
I'm hosting this month's T-SQL Tuesday, and I gave you a choice: tell us something you're passionate about outside of the tech realm, or talk about your favorite (or least favorite) T-SQL bad habit...
T-SQL Tuesday #99 : Dealer's Choice
I am honored to be hosting the 99th installment of T-SQL Tuesday. Can you believe this monthly blog party has been going on, month in and month out, since 2009? This is a great...
Same old content, brand new home
I started blogging at SQLBlog.com in December of 2006. This past year, after a long and successful run, Adam Machanic – a founder of SQLBlog.com and the brain behind T-SQL Tuesday – reached out...
SQL Server 2012 Service Pack 3 is available!
SQL Server has released SQL Server 2012 Service Pack 3. You can download here and see so me other details here. Build number is 11.0.6020.0 37 fixes (see the full list in KB #3072779)...
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!
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!
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
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...
Vulnerability Affecting All Supported Versions of SQL Server
Well, it's that time again: Patch Tuesday. SQL Server hasn't had a security update since August, but today we're giving the hotfix download servers a run for their money. Both GDR and QFE fixes...
SQL Server 2014 Service Pack 1 Cumulative Update #1 is available!
Microsoft has released Cumulative Update #1 for SQL Server 2014 Service Pack 1. See this blog post for more information. KB Article: KB #3067839 121 fixes listed publicly at time of publication (141 total)...
SQL Server 2014 RTM Cumulative Update #8 is available!
Microsoft has released Cumulative Update #8 for SQL Server 2014. See this blog post for more information. KB Article: KB #3067836 38 fixes listed publicly at time of publication (40 total) Build number is...
COD Hotfixes available for SQL Server 2014 (SSIS Unpivot and Clustered Columnstore)
Microsoft has released a hotfix (12.0.2504) which includes two fixes. KB #2999809 : FIX: Poor performance when a query contains table joins in SQL Server 2014 – this actually has to do with segment...