Search results matching tag 'hotfixes'

March 2013 Cumulative Updates - SQL Server 2012 SP1 & 2008 SP3

AaronBertrand — Mon, 18 Mar 2013 21:40:00 GMT

SQL Server 2012 Service Pack 1 Cumulative Update #3

Build # 11.0.3349
KB Article: KB #2812412
38 fixes!
Relevant for builds 11.0.3000 -> 11.0.3348
NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999)

SQL Server 2008 Service Pack 3 Cumulative Update #10

Build # 10.00.5835
KB Article: KB #2814783
8 fixes
Relevant for builds 10.00.5500 -> 10.00.5834
NOT for SQL Server 2008 R2 (10.50.xxxx)

February 2013 Cumulative Updates for SQL Server 2008 R2

AaronBertrand — Mon, 18 Feb 2013 19:00:00 GMT

Today Microsoft released new cumulative updates for SQL Server 2008 R2.

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 11

KB Article: KB #2812683
4 fixes listed at time of publication
Build number is 10.50.2869
Relevant for @@VERSION 10.50.2500 through 10.50.2868

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 5

KB Article: KB #2797460
21 fixes listed at time of publication
Build number is 10.50.4276
Relevant for @@VERSION 10.50.4000 through 10.50.4275

My usual disclaimer: these updates are NOT for SQL Server 2008 (or SQL Server 2012). Only apply to systems where SELECT @@VERSION returns 10.50.xxxx, where xxxx is >= 2500. If xxxx < 2500, you need to start thinking about getting off the RTM branch. And based on the number of fixes making it into the SP2 updates, you might consider abandoning SP1, too, if possible...

SQL Server 2012 RTM Cumulative Update #6 is available!

AaronBertrand — Mon, 18 Feb 2013 18:49:00 GMT

The SQL Server team has released CU #6 for SQL Server 2012 RTM.

KB article: http://support.microsoft.com/kb/2728897
Build # is 11.0.2401
This build has 22 fixes

Relevant for builds 11.0.2100 -> 11.0.2400. Do not attempt to install on SQL Server 2012 SP1 (any build >= 11.0.3000) or any previous version.

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

AaronBertrand — Thu, 24 Jan 2013 18:42:00 GMT

The SQL Server team has released CU #2 for Service Pack 1, which should include all of the fixes from CU #5, as well as some others.

KB article: KB #2790947
Build # is 11.0.3339
This build has FIFTY fixes!

There is also a KB article (KB #2792921) describing a couple of new features delivered with this cumulative update: enhancements to sysprep, and the ability to backup directly to Windows Azure Blob storage.

Relevant for builds 11.0.3000 -> 11.0.3338. Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any previous version.

Cumulative Update #9 for SQL Server 2008 SP3 is available

AaronBertrand — Tue, 22 Jan 2013 10:55:00 GMT

Today Microsoft has released a new cumulative update for SQL Server 2008 SP3.

KB article: KB #2799883
There are three fixes listed at the time of writing
The build number is 10.00.5829.00
Relevant for @@VERSION between 10.00.5500 and 10.00.5828

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

December 2012 Cumulative Updates are available for SQL Server 2008 R2

AaronBertrand — Tue, 18 Dec 2012 03:47:00 GMT

Microsoft released new cumulative updates for SQL Server.

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 10

KB Article: KB #2783135
16 fixes are listed at the time of publication
Build number is 10.50.2868
Relevant for @@VERSION 10.50.2500 through 10.50.2867

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 4

KB Article: KB #2777358
34 fixes are listed at time of publication
Build number is 10.50.4270
Relevant for @@VERSION 10.50.4000 through 10.50.4269

My usual disclaimer: these updates are NOT for SQL Server 2008. Only apply to systems where @@VERSION returns 10.50.xxxx, where xxxx is >= 2500. If xxxx < 2500, you need to start thinking about getting off the RTM branch.

Cumulative Update #5 is available for SQL Server 2012 RTM

AaronBertrand — Tue, 18 Dec 2012 03:44:00 GMT

Microsoft has released Cumulative Update #5 for SQL Server 2012 RTM. Note this is *not* a cumulative update for Service Pack 1. So if your build # is >= 11.0.3000, you should not be installing this update.

KB Article: KB #2777772
Build # 11.0.2395
28 fixes at the time of writing

Looking for an update for the Service Pack 1 branch? You'll find that in January. For now at least, unlike the SQL Server 2008 R2 SP1/SP2 branches (which are in sync), the release cycles for SQL Server 2012 CUs will alternate - RTM one month, SP1 the next. This is mainly due to the out-of-band release of SP1 CU1 to get it caught up the the RTM CUs.

This update is only relevant for builds 11.0.2100 -> 11.0.3329. Do not attempt to install on SQL Server 2012 SP1 (any build >= 11.0.3000) or any previous version of SQL Server.

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

AaronBertrand — Tue, 20 Nov 2012 20:17:00 GMT

Waited to deploy SQL Server 2012 until Service Pack 1 was released? Then held off because Service Pack 1 did not include important updates from Cumulative Update #3 and Cumulative Update #4? You're running out of reasons to procrastinate! The SQL Server team has released CU #1 for Service Pack 1, which should include all of the fixes from CU #3 & CU #4, as well as some others.

KB article: KB #2765331
Build # is 11.0.3321
I count a whopping 44 fixes!

Relevant for builds 11.0.3000 -> 11.0.3320. Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any previous version.

Cumulative Update #8 for SQL Server 2008 SP3 is available

AaronBertrand — Mon, 19 Nov 2012 21:51:00 GMT

Today Microsoft has released a new cumulative update for SQL Server 2008 SP3.

KB article: KB #2771833
There are 9 fixes listed at the time of writing
The build number is 10.00.5828.00
Relevant for @@VERSION between 10.00.5500 and 10.00.5827

It seems clear that Service Pack 2 servicing has been discontinued. So there is even less reason to hold onto those old builds, and every reason to upgrade to Service Pack 3.

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

SQL Server 2012 Service Pack 1 is available - this time for sure!

AaronBertrand — Thu, 15 Nov 2012 18:21:00 GMT

Last week I mentioned in passing that Service Pack 1 is now available, while I was blogging from the PASS Summit keynote. I wanted to put up an official post instead of having it appear as a footnote there (I also updated my April Fools' joke to point to the right place).

Service Pack 1 Details

Service Pack 1 is build # 11.0.3000 and includes 13 fixes to public KB items and 35 other internal (VSTS) items. You can see the list of fixes in KB #2674319.

You can also read about new features included in SP1 (well, first included in SP1 CTP4) on the Analysis Services team blog or in Books Online on MSDN.

You can download Service Pack 1 from the following URL:

http://www.microsoft.com/en-us/download/details.aspx?id=35575

A Caveat for Slipstreamers

The download page currently offers slipstreamed ISOs. However, another knowledge base article claims that, at least at the time of writing, these ISOs do not work. See more info in KB #2783963 - but for now I would suggest just downloading the standard SP1 installer (SQLServer2012SP1-KB2674319-x64-ENU.exe or SQLServer2012SP1-KB2674319-x86-ENU.exe). I haven't tested it, but you should still be able to build your own slipstream installs by combining these standard installers with your existing images, the "old-fashioned way."

Fixes from Cumulative Updates

Due to the length of time that goes into testing a Service Pack, SP1 includes only the updates from Cumulative Update #1 (11.0.2316) and Cumulative Update #2 (11.0.2325). So if you are relying on updates from Cumulative Update #3 (11.0.2332) or Cumulative Update #4 (11.0.2383), you may want to hold off on Service Pack 1 until the first post-SP1 Cumulative Update is available. Typically this is advanced so that you're not waiting an entire Cumulative Update cycle (~8 weeks), so I would expect it well before the end of the year.

Feature Pack

The SQL Server 2012 SP1 Feature Pack downloads are also available:

http://www.microsoft.com/en-us/download/details.aspx?id=35580

SQL Server 2012 Express Edition Service Pack 1

If you are looking for Express SP1, general web searches will probably lead you through a bunch of registration brouhaha - here is a direct link:

http://www.microsoft.com/en-us/download/details.aspx?id=35579

The most interesting thing about the Express release, to me, is that now the full version of Management Studio is completely free. The Express download page says that it includes Management Studio Express, but I have installed this, and it actually installs Management Studio proper with none of the limitations you are used to. Obviously some of the features that didn't exist before still don't make sense when you're only managing an Express instance (e.g. SQL Server Agent), but now you can use the free version of Management Studio to fully and properly manage all editions. Other tools such as Profiler and the Database Engine Tuning Advisor are now included also.