Yearly Archive: 2015

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

SQL Server 2014 Cumulative Update #7 is available!

SQL Server 2014 Cumulative Update #7 is available!

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

SQL Server 2014 Service Pack 1 was available – but there's a catch!

SQL Server 2014 Service Pack 1 was available – but there's a catch!

Stop me if you've heard this one before.  Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB). From the Release Services...

On-Demand Hotfix for Parallel Batch-Mode Deadlocks in SQL Server 2014

On-Demand Hotfix for Parallel Batch-Mode Deadlocks in SQL Server 2014

Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock...

On-Demand Hotfix for Availability Groups in SQL Server 2014

On-Demand Hotfix for Availability Groups in SQL Server 2014

Last week, Microsoft released an on-demand hotfix for SQL Server 2014, which you shgould consider installing if you are using Availability Groups and any of the relevant databases use CLR user-defined types (UDTs). The...

March 2015 Cumulative Updates for SQL Server 2012

March 2015 Cumulative Updates for SQL Server 2012

Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL...

SQL Server 2014 Cumulative Update #6 is available!

SQL Server 2014 Cumulative Update #6 is available!

Microsoft has released Cumulative Update #6 for SQL Server 2014. This update fixes a few important issues exposed in Cumulative Update #5; see this blog post for some more information about those issues. KB...

Out-of-band hotfix releases for SQL Server 2008 SP4 and 2008 R2 SP3

Out-of-band hotfix releases for SQL Server 2008 SP4 and 2008 R2 SP3

Back in September, I blogged about the availability of SQL Server 2008 R2 Service Pack 3 and SQL Server 2008 Service Pack 4. I made it clear that there would be no cumulative updates after...

Out-of-band AG hotfix for SQL Server 2012 SP2 and SQL Server 2014

Out-of-band AG hotfix for SQL Server 2012 SP2 and SQL Server 2014

A hotfix has been released for an issue that causes Availability Groups to show as NOT SYNCHRONIZING. The original issue is described in KB #3033492 and in this SQL Server Release Services Team blog...

Out-of-band query compile hotfix for SQL Server 2014

Out-of-band query compile hotfix for SQL Server 2014

Last week, Microsoft released an out-of-band hotfix to resolve an issue surrounding excessive RESOURCE_SEMAPHORE_QUERY_COMPILE waits. If you are experiencing this issue, or if you are diligent about applying the most recent hotfixes, you should...