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.
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.
I caution about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
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...
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)...
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)...
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...
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.
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
I warn about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.