Search results matching tags 'hotfixes' and 'SP1'

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)

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.

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.

New cumulative updates for SQL Server 2008 R2 (RTM & SP1) are available!

AaronBertrand — Tue, 17 Apr 2012 12:06:00 GMT

This morning the SQL Server Release Services Team has pushed out new cumulative updates for SQL Server 2008 R2.

Cumulative Update #13 for SQL Server 2008 R2 RTM

Knowledge Base article: http://support.microsoft.com/kb/2679366
Build number: 10.50.1815
Number of fixes: 9
Relevant for builds of SQL Server between 10.50.1600 and 10.50.1814

Cumulative Update #6 for SQL Server 2008 R2 Service Pack 1

Knowledge Base article: http://support.microsoft.com/kb/2679367
Build number: 10.50.2811
Number of fixes: 20
Relevant for builds of SQL Server between 10.50.2500 and 10.50.2810

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

Two new cumulative updates for SQL Server 2008 R2 are available!

AaronBertrand — Thu, 23 Feb 2012 15:23:00 GMT

Last night Microsoft released two new cumulative updates for SQL Server 2008 R2:

Cumulative Update 5 for SQL Server 2008 R2 SP1

KB #2659694
Build 10.50.2806
16 fixes, including a nasty SCOPE_IDENTITY() bug and several performance fixes.

My recommendation: You should test and plan for this update if SELECT @@VERSION is between 10.50.2500 and 10.50.2805.

Cumulative Update 12 for SQL Server 2008 R2 (RTM)

KB #2659692
Build 10.50.1810
3 fixes but none are directly related to the relational engine.

My recommendation: Consider applying if SELECT @@VERSION is between 10.50.1600 and 10.50.1809, you are affected by any of the issues highlighted in the KB article, and you are avoiding Service Pack 1 intentionally (otherwise you should install SP1 and CU5 for SP1).

My usual disclaimer: these updates are NOT for SQL Server 2008. Only apply to systems where @@VERSION returns 10.50.xxxx.

New cumulative updates for SQL Server 2008 R2 are available!

AaronBertrand — Tue, 20 Dec 2011 15:18:00 GMT

Microsoft has just released cumulative updates for both SQL Server 2008 R2 branches - RTM and Service Pack 1.

SQL Server 2008 R2 Service Pack 1 Cumulative Update #4

http://support.microsoft.com/kb/2633146/
Build number is 10.50.2796
Contains 53 fixes (as of February 6, 2012)

SQL Server 2008 R2 RTM Cumulative Update #11

http://support.microsoft.com/kb/2633145/
Build number is 10.50.1809
Contains 23 fixes (as of February 6, 2012)

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

Cumulative Updates for SQL Server 2008 R2 are available!

AaronBertrand — Mon, 17 Oct 2011 23:57:00 GMT

Today Microsoft has released Cumulative Updates for SQL Server 2008 R2.

Cumulative Update #10 for SQL Server 2008 R2 RTM

Build number: 10.50.1807
KB article: KB #2591746
13 fixes

Cumulative Update #3 for SQL Server 2008 R2 Service Pack 1

Build number: 10.50.2789
KB article: KB #2591748
22 fixes

Please note: these updates are for SQL Server 2008 R2 only - not for the original SQL Server 2008 release (regardless of service pack level).

More Cumulative Updates available for SQL Server 2008

AaronBertrand — Wed, 22 Jul 2009 05:04:00 GMT

Looks like dozens of fixes for SQL Server 2008 have made their way into another cumulative rollup; CU3 for SP1 (build 2723), and CU6 for RTM (build 1812). You can get them here:

Cumulative Update 3 for SP1:
http://support.microsoft.com/kb/971491

Cumulative Update 6 for RTM:
http://support.microsoft.com/kb/971490

So what are the main differences? While I won't pretend (like I did last time) that some of the "missing" fixes from a build weren't already in there from a prior cumulative update, and I also won't pretend that I would be motivated in any way to painstakingly go and track them all down, there definitely seem to be some fixes that only made it into one of these builds, and only a handful that made it into both.

KB Article	CU6 for RTM 10.00.1812 KB #971490	CU3 for SP1 10.00.2723 KB #971491	Both
KB #948567	yes	-	-
KB #956574	yes	-	-
KB #967315	yes	-	-
KB #967522	-	yes	-
KB #967552	-	yes	-
KB #968722	yes	-	-
KB #968740	-	yes	-
KB #968741	-	yes	-
KB #968742	-	yes	-
KB #968834	yes	-	-
KB #969050	yes	yes	yes
KB #969357	-	yes	-
KB #969467	-	yes	-
KB #969528	yes	yes	yes
KB #969611	-	yes	-
KB #969793	-	yes	-
KB #969844	yes	yes	yes
KB #969997	-	yes	-
KB #970014	yes	-	-
KB #970044	yes	-	-
KB #970058	yes	yes	yes
KB #970133	yes	-	-
KB #970150	-	yes	-
KB #970160	-	yes	-
KB #970198	yes	-	-
KB #970287	-	yes	-
KB #970399	-	yes	-
KB #970507	-	yes	-
KB #970538	-	yes	-
KB #970551	yes	yes	yes
KB #970666	-	yes	-
KB #970713	yes	yes	yes
KB #970823	yes	yes	yes
KB #970909	yes	yes	yes
KB #970966	yes	yes	yes
KB #971049	-	yes	-
KB #971051	-	yes	-
KB #971057	-	yes	-
KB #971064	-	yes	-
KB #971068	-	yes	-
KB #971132	-	yes	-
KB #971136	yes	yes	yes
KB #971402	yes	yes	yes
KB #971640	-	yes	-
KB #971772	-	yes	-
KB #971780	yes	-	-
KB #971914	yes	-	-
KB #971985	-	yes	-
KB #972068	-	yes	-
KB #972197	-	yes	-
KB #972198	-	yes	-
KB #972200	-	yes	-
KB #972201	-	yes	-
KB #972203	-	yes	-
KB #972207	-	yes	-
KB #972261	-	yes	-
KB #972440	-	yes	-
KB #972521	-	yes	-
KB #972650	yes	-	-
KB #972681	yes	yes	yes
KB #972759	-	yes	-
KB #972763	-	yes	-
KB #972767	yes	yes	yes
KB #972777	-	yes	-
KB #972984	-	yes	-
KB #973200	-	yes	-
KB #973204	yes	-	-
KB #973250	-	yes	-
KB #973257	-	yes	-
KB #973301	yes	yes	yes
KB #973302	yes	-	-