Yearly Archive: 2014

SQL Server 2014 Cumulative Update #5 is available!

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...

November 2014 Cumulative Updates for SQL Server 2012

November 2014 Cumulative Updates for SQL Server 2012

Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL...

SQL Server 2014 Cumulative Update #4 is available!

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 2008 Service Pack 4 is available!

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...

SQL Server 2008 R2 Service Pack 3 is available!

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...

September 2014 Cumulative Updates for SQL Server 2012

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...

SQL Server 2014 Cumulative Update #3 is Available

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

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 2012 Service Pack 2 Cumulative Update #1 is available!

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

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...

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

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...

T-SQL Tuesday #56 : Assumptions

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...

June 2014 Cumulative Update for SQL Server 2008 R2 SP2

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...

SQL Server 2014 Cumulative Update #2 is Available

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...

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

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...

The final Cumulative Update for SQL Server 2008 SP3

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...

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

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

The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #10. KB Article: KB #2954099 Build # is 11.0.3431 Currently there are 36 public fixes listed (38 total)  Relevant for builds 11.0.3000...

Yes, you can install SQL Server 2014 Books Online locally

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 Cumulative Update #1 is Available

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...

April 2014 Cumulative Update for SQL Server 2008 R2 SP2

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...

SQL Saturday #262 : Boston

SQL Saturday #262 : Boston

Today I gave my T-SQL : Bad Habits & Best Practices session at SQL Saturday #262 at Microsoft in Cambridge. Fun event with a lot of friendly faces. A few mishaps along the way:...

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

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

The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #9. KB Article: KB #2931078 Build # is 11.0.3412 Currently there are 29 public fixes listed (33 total)  Relevant for builds 11.0.3000...