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

Yes, you can install SQL Server 2014 Books Online locally

Update 2014-08-01: Below I mention that the T-SQL and XQuery references were not available locally with the initial release; they have now been provided (see this post for more details). I've seen people complain that SQL Server 2014 did not ship with documentation you could install locally. While true, it is […]

SQL Server 2014 Cumulative Update #1 is Available

Microsoft has released Cumulative Update #1 for SQL Server 2014. KB Article: KB #2931693 114 fixes listed at time of publication (121 total) Build number is 12.0.2342 Relevant for @@VERSION 12.0.2000 through 12.0.2341 UPDATE 2014-05-05 The download links for the Cumulative Update packages have been restored over the weekend. UPDATE […]

April 2014 Cumulative Update for SQL Server 2008 R2 SP2

Microsoft has released Cumulative Update #12 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2938478 13 fixes listed at time of publication Build number is 10.50.4305 Relevant for @@VERSION 10.50.4000 through 10.50.4304 My usual disclaimer: these updates are NOT for SQL Server 2008 (or SQL Server 2012). […]