A subtle redirection
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 12.0.2430 Relevant for @@VERSION 12.0.2000 through 12.0.2429
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 NOT for SQL Server 2008 R2 (10.50.xxxx) Once more, this is the last service pack for […]
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 the fixes from the 13 cumulative updates for this branch (if you want to get a […]
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 public fixes listed (52 total) Relevant for builds 11.0.5058 -> 11.0.5547. Do not attempt to install […]
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 of publication (40 total) Build number is 12.0.2402 Relevant for @@VERSION 12.0.2000 through 12.0.2401 As a […]
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 denial of service / privilege escalation issue that has been patched: http://technet.microsoft.com/en-us/library/security/MS14-044 For SQL Server 2012 […]
The SQL Server team has released SQL Server 2012 SP2 Cumulative Update #1. This cumulative updates Service Pack 2 to include the fixes from SP1 CU#10 and a few from CU#11, including the fix for the online index rebuild corruption issue I discussed recently on SQLPerformance.com. It also marks the […]
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #11. This cumulative update includes a fix for the online index rebuild corruption issue I discussed recently on SQLPerformance.com. KB Article: KB #2975396 Build # is 11.0.3449 Currently there are 32 public fixes listed (32 total) Relevant for […]
This month's T-SQL Tuesday is about assumptions in SQL Server. Over on our new consolidated team blog at SQL Sentry, I discuss the following assumptions I come across with relative frequency: Case will always short circuit A seek is better than a scan, always A query without ORDER BY will […]
Microsoft has released the final Cumulative Update (#13) for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2967540 15 public fixes listed at time of publication (17 fixes total) Build number is 10.50.4319 Relevant for @@VERSION 10.50.4000 through 10.50.4318 My usual disclaimer: these updates are NOT for SQL […]
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 sqlperformance.com. KB Article: KB #2967546 48 fixes listed publicly at time of publication (52 total) Build […]
Service Pack 2 is available: http://www.microsoft.com/en-us/download/details.aspx?id=43340 The build number is 11.0.5058, and this includes fixes up to and including SQL Server 2012 SP1 CU #9. (The complete list of fixes is exhaustive, including all fixes from SP1 CU #1 -> #9, but the post-CU #9 fixes are listed here: http://support.microsoft.com/KB/2958429 […]