Patch Tuesday : Security Updates for SQL Server 2012, 2014, 2016
Security updates were released today to patch a remote code execution vulnerability in Reporting Services, but I would install the patch even if you're not running SSRS.
Category: SQL Server 2014
A "drop column" fix you will want for SQL Server 2012 / 2014
I caution about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
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 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...
How not to call Hekaton natively-compiled stored procedures
I take a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
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!
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...
Information about the SQL Server 2014 Service Pack 1 snafu
Updated April 17, 2015: SQL Server 2014 Service Pack 1 has been released, but was quickly pulled. This post explains why and shows how to fix any affected instances.
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
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
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...
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 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!
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...
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 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
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...
SQL Server 2014 Cumulative Update #2 is Available
Microsoft has released Cumulative Update #2 for SQL Server 2014. Important! This Cumulative Update fixes the data loss / corruption issue with online index rebuilds that I talked about in this blog post on...
Fixes for SQL Server 2012 & 2014 Online Index Rebuild Issue
I warn about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.