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 NOT for SQL Server 2008 R2 (10.50.xxxx) Once more, this is the last service pack for […]

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 the fixes from the 13 cumulative updates for this branch (if you want to get a […]

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 public fixes listed (52 total)  Relevant for builds 11.0.5058 -> 11.0.5547. Do not attempt to install […]

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 of publication (40 total) Build number is 12.0.2402 Relevant for @@VERSION 12.0.2000 through 12.0.2401 As a […]

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 denial of service / privilege escalation issue that has been patched: http://technet.microsoft.com/en-us/library/security/MS14-044 For SQL Server 2012 […]

SQL Server 2012 Service Pack 1 Cumulative Update #11 is available!

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 […]

T-SQL Tuesday #56 : Assumptions

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 […]

June 2014 Cumulative Update for SQL Server 2008 R2 SP2

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 […]

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 sqlperformance.com. KB Article: KB #2967546 48 fixes listed publicly at time of publication (52 total) Build […]

SQL Server 2012 Service Pack 2 is available – but there's a catch!

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 […]

The final Cumulative Update for SQL Server 2008 SP3

Microsoft has released the final Cumulative Update (#17) for SQL Server 2008 Service Pack 3. Build # 10.00.5861 KB Article: KB #2958696 9 public fixes Relevant for builds 10.00.5500 -> 10.00.5860 NOT for SQL Server 2008 R2 (10.50.xxxx) Once more, this is the last cumulative update for SQL Server 2008. […]