Charlotte SQL Server User Group : Fix Slow Queries. Fast.

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."

Make SQL Server DMV Queries Backward Compatible

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.

Four ways to improve scalar function performance in SQL Server

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.

T-SQL Tuesday #99 : The Roundup

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

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

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

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 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

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...

Vulnerability Affecting All Supported Versions of SQL Server

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!

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!

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)

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...