Search results matching tag 'SQL Server 2008 R2'

April 2013 Cumulative Updates for SQL Server 2008 R2

AaronBertrand — Mon, 15 Apr 2013 18:00:00 GMT

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

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 12

KB Article: KB #2828727
7 fixes listed at time of publication
Build number is 10.50.2874
Relevant for @@VERSION 10.50.2500 through 10.50.2873

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 6

KB Article: KB #2830140
13 fixes listed at time of publication
Build number is 10.50.4279
Relevant for @@VERSION 10.50.4000 through 10.50.4278

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

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

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.

MS12-070 : Security Updates for all supported versions of SQL Server

AaronBertrand — Wed, 10 Oct 2012 16:57:00 GMT

This week there was a security release for all supported versions of SQL Server. Each version has 32-bit and 64-bit patches, and each version has GDR (General Distribution Release) and QFE (Quick-Fix Engineering) patches. GDR should be applied if you are at the base (RTM or SP) build for your version, while QFE should be applied if you have installed any cumulative updates after the RTM or SP build. (More details here.)

SQL Server 2005

RTM, SP1, SP2, SP3 - not supported
SP4 - GDR = 9.00.5069, QFE = 9.00.5324

SQL Server 2008

RTM, SP1 - not supported
SP2 - GDR = 10.00.4067, QFE = 10.00.4371
SP3 - GDR = 10.00.5512, QFE = 10.00.5826

SQL Server 2008 R2

RTM - not supported
SP1 - GDR = 10.50.2550, QFE = 10.50.2861
SP2 - not affected

SQL Server 2012

RTM: GDR = 11.00.2218, QFE = 11.00.2376
SP1 - not yet supported; should not be affected once SP1 is released.

Now, a couple of oddities you might have noticed:

The security bulletin mentions something about SQL Server instances with Reporting Services installed. Yet the KB articles for individual updates state that all instances of SQL Server are eligible for the update. And the update does, in fact, update sqlservr.exe and @@VERSION, even for systems where SSRS is not installed. So until there is some clarification on this point, I'm going to treat this as a patch for all instances.
Both the GDR and QFE KBs for multiple patches state that the preceding cumulative updates are included. I believe this is a copy & paste error and that the cumulative updates for a specific branch are only included with the QFE patch. I will update here if I get any confirmation on this.

Even if they come back and say, whoops, our bad, the KBs should mention it is SSRS only, and the GDRs do not affect sqlservr.exe and do not include the CU updates, I'm still going to apply the patch everywhere. Why? Well, for consistency, I'd rather have all of my instances at @@VERSION = x, than have the SSRS instances at x and the non-SSRS instances at < x.

SQL Server 2008 R2 Service Pack 2 Cumulative Update #1 is available

AaronBertrand — Wed, 01 Aug 2012 19:23:00 GMT

Microsoft has released a cumulative update for SQL Server 2008 R2 SP2, which was only released last week.

KB article is http://support.microsoft.com/kb/2720425
Build number is 10.50.4260.0
There are 35 fixes published as of 2012-08-01
This update is relevant for builds between 10.50.4000 and 10.50.4259

My recommendation: if you have already installed Service Pack 2, or were waiting on the first cumulative update before doing so, this may be what you've been waiting for. According to the SQL Release Services Blog, SP2 CU#1 includes all of the fixes from SP1 CU#6 and CU#7 (which were not included in SP2 RTM).

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

SQL Server 2008 R2 Service Pack 2 is available

AaronBertrand — Thu, 26 Jul 2012 18:50:00 GMT

Today Microsoft has released Service Pack 2 for SQL Server 2008 R2.

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

The build number is 10.50.4000.0 and it includes fixes from 2008 R2 SP1 Cumulative Updates 1, 2, 3, 4 and 5. The fixes from Cumulative Updates 6 and 7 will be published in a subsequent cumulative update, so if you're relying on those fixes, do *not* install the service pack until SP2 CU#1 is available.

The SQL Server team talks about it a bit on their blog, but their download link currently points to the 2008 SP2 download. Which will only further the confusion that 2008 and 2008 R2 are the same!

The KB is here but it is currently broken (should be published soon): http://support.microsoft.com/kb/2630458

Cumulative Updates available for SQL Server 2008 R2

AaronBertrand — Mon, 18 Jun 2012 17:51:00 GMT

Today the SQL Server Release Services Team has pushed out new cumulative updates for SQL Server 2008 R2:

Cumulative Update #14 for SQL Server 2008 R2 RTM

- KB article http://support.microsoft.com/kb/2703280
- build number 10.50.1817.0
- 7 fixes
- relevant for builds between 10.50.1600 and 10.50.1816

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

- KB article http://support.microsoft.com/kb/2703282
- build number 10.50.2817.0
- 24 fixes
- relevant for builds between 10.50.2500 and 10.50.2816

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

And an additional disclaimer: do not install either of these updates if you have installed SQL Server 2008 R2 SP2 CTP.

And one more: this is highly likely to be the last CU you'll see on the RTM branch.

SQL Server 2008 R2 Service Pack 2 CTP is available

AaronBertrand — Mon, 14 May 2012 18:23:00 GMT

You can download the Service Pack 2 CTP from the following URL:

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

The build # is 10.50.3720. This service pack contains all of the fixes from Service Pack 1 & Cumulative Updates 1 through 5, and a couple of other minor fixes (a couple of SSRS bugs and a bug about an ALTER TABLE batch not being cached correctly). It does not include fixes from Service Pack 1 Cumulative Update #6, which I mentioned recently.

You should *NOT* install this service pack preview if:

your build number (SELECT @@VERSION;) is 10.00.xxxx (since this is SQL Server 2008, not SQL Server 2008 R2);
your build number is >= 10.50.1815 and < 10.50.2500 (since you may be undoing fixes you are using from RTM CU13); or,
your build number is >= 10.50.2811 (since you will be undoing fixes you might be using from SP1 CU6).

New White Paper: SQL Server Extended Events and Notifications

KKline — Wed, 25 Apr 2012 13:13:00 GMT

SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. But where to look?

As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white paper, we will look at a couple technologies – event notifications and extended events – that can help you achieve these goals. With these two features, we’ll look at the error log and deadlocks, and demonstrate how you can get relevant information delivered as it occurs. We’ll also look at ways that run-time errors can be captured and used to help reduce the amount of time required to investigate issues.

This white paper, written by SQL Server MVP Jason Strate (blog | twitter), is a free download but requires a registration. Download the Extended Events white paper here.

And, as always, I enjoy your feedback. Thanks!

-Kev

Follow me on Twitter!

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