Category: SQL Server

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

SQL Server 2014 Cumulative Update #5 is available!

SQL Server 2014 Cumulative Update #5 is available!

Microsoft has released Cumulative Update #5 for SQL Server 2014. KB Article: KB #3011055 56 fixes total (47 fixes listed publicly at time of publication). Build number is 12.0.2456 Relevant for @@VERSION 12.0.2000 through...

November 2014 Cumulative Updates for SQL Server 2012

November 2014 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 #4 is available!

SQL Server 2014 Cumulative Update #4 is available!

Microsoft has released Cumulative Update #4 for SQL Server 2014. KB Article: KB #2999197 66 fixes total (54 fixes listed publicly at time of publication), including several fixes for Management Studio. Build number is...

SQL Server 2008 Service Pack 4 is available!

SQL Server 2008 Service Pack 4 is available!

Microsoft has released the final Service Pack (SP4) for SQL Server 2008. Build # 10.00.6000 KB Article: KB #2979596 (Download) 6 public fixes, including important security fixes from MS14-044 Relevant for builds < 10.00.6000...

SQL Server 2008 R2 Service Pack 3 is available!

SQL Server 2008 R2 Service Pack 3 is available!

Microsoft has released a final service pack for SQL Server 2008 R2: Service Pack 3. The build # is 10.50.6000.34 and you can download it here. This is essentially a rollup of all of...

September 2014 Cumulative Updates for SQL Server 2012

September 2014 Cumulative Updates for SQL Server 2012

The SQL Server team has released two cumulative updates for SQL Server 2012. SQL Server 2012 Service Pack 2 Cumulative Update #2 KB Article: KB #2983175 Build # is 11.0.5548 Currently there are 50...

SQL Server 2014 Cumulative Update #3 is Available

SQL Server 2014 Cumulative Update #3 is Available

Microsoft has released Cumulative Update #3 for SQL Server 2014. Important! This Cumulative Update includes MS14-044, which I blogged about here and also mention here. KB Article: KB #2984923 32 fixes listed publicly at time...

Security Updates Available for SQL Server 2008, 2008 R2, 2012, 2014

Security Updates Available for SQL Server 2008, 2008 R2, 2012, 2014

If you are running 2008 SP3, 2008 R2 SP2, 2012 SP1 (SP2 is not affected, RTM is no longer supported), or 2014, you'll want to check out Security Bulletin MS14-044 for details on a...