[EN] Speaking in Sofia again

sqlsat311_webTwo years break. And now is time to back for Sofia (even just for twenty hours). My plan is very simple:

  • Fridays’s morning flight from Warsaw via Belgrad to Sofia
  • speaker dinner and entertainment evening…
  • morning session at Infragistics Head Office
  • Saturday’s afternoon flight back from Sofia via Belgrad to Warsaw

This time (based on my busy scheduled calendar) I’m not able to stay longer in Sofia. Even that – even conference organizer Mihail Mateev {BLOG|TWITTER|LINKEDIN} want more – I’m very proud to be presenting one of my favourite session: SQL Server Source Control for DBA. Just short talk, demo and video fof DBA’a about controling data. Of course I will use Redgate Source Control tool and maybe something more on my demo. Five track: Development, DBA, BI, Mixed&Azure, Mixed&OSS for over four hundred registered attendees.

On the other side speaker’s room will be multi-kulti room:

Margarita Naumova, Janos Berke, Ivelin Andreev, Daniel Joskovsky, Laerte Junior, Zoltan Horvath, Dejan Sarka, Mihail Mateev, Ivan Donev, Alexander Karl, Rasmus Reinholdt, Sergey Olontsev, Marcin Szeliga, Denis Reznik, Boris Hristov, Kaloyan Kosev, Boriana Petrova, Oleksii Kovalov, Satya Shyam Jayanty, Milos Radivojevic, Turgay Sahtiyan Bulgaria, Russia, Ukraina, Turkey, Poland, Slovenia, Germany, Denmark, Kosovo, United Kingdom, Brazil

Really, really exciting!

PS. Quiet, please. I will bring one full license of Redgate Source Control Software…

[EN] SQL Server 2008 R2 Service Pack 3 is available!

LOGO__SQLServer2008SP3Long awaited Service Pack 3 for Microsoft SQL Server 2008 R2 is available from last week. This Service Pack 3 (build number 10.50.600.34) include whole previously published updates for Service Pack 2 and up to Cumulative Update 13. And it is the last update for this platform, Microsoft will not release any Cumulative Update for Service Pack 3.

You cand download this update form Microsoft Download Centre and you can get two files (for x86 and x64 platforms):

  • ENU\SQLServer2008R2SP3-KB2979597-x64-ENU.exe | 358.4 MB
  • ENU\SQLServer2008R2SP3-KB2979597-x86-ENU.exe | 247.2 MB

This package can be used for upgrading following SQL Server 2008 R2 editions:

  • SQL Server 2008 R2 Parallel Computing Edition
  • SQL Server 2008 R2 Datacenter Edition
  • SQL Server 2008 R2 Enterprise Edition and Developer Edition
  • SQL Server 2008 R2 Standard Edition
  • SQL Server 2008 R2 Web Edition
  • SQL Server 2008 R2 Workgroup Edition

 

In the same moment MIcrosoft released Microsoft® SQL Server® 2008 R2 SP3 Feature Pack. It’s very important stand-alone packages which provide additional value of SQL Server 2008 R2 SP2. Here is the link for Knowledge Base Article and list of packages:

  • Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
  • Microsoft® System CLR Types for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Remote Blob Store
  • Microsoft® SQL Server® 2008 R2 Native Client
  • Microsoft® SQL Server® 2008 R2 Command Line Utilities
  • Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2  The Microsoft SQL Server 2008 R2 Service Broker External
  • Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET
  • Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Analysis Management Objects

and full list of downloadable files:

image

 

Please read more information on all of those products and updates under linked addresses:

 

More important notes from producer:

  • We are not releasing  SQL Server 2008 R2 Express Service Pack 3 refresh.
  • This Service Pack will not be available on Microsoft Update. To facilitate the deployment on your side you could either use custom rules in SCCM or local publishing in WSUS as explained here.
  • Slipstream technology is not available for SQL Server 2008 R2. To slipstream a SQL Server 2008 R2  with Service Pack 3 please see this post .
  • October 16th 2014: We have discovered an issue with Report Builder 3.0 that ships with SQL Server 2008 R2 Service Pack 3.You will find on the SQL Server Release Services blog a public message sharing details and mitigations.

[EN] SQL Server 2008 R2 SP2 Cumulative Update 13 isavailable!

NOTE:
This is the final Cumulative Update for SQL Server 2008 R2 Service Pack 2.  SQL Server 2008 R2 SP2 exits mainstream support on July 8, 2014.

The sentence above is most important part in this post. In Last Cumulative Update No 13 (build number: 10.50.4319.0) for SQL Server 2008 R2 SP2 Microsoft fixed fifteen bugs:

 

VSTS BUG: 1918779 | 2922526
FIX: Missing rows on subscriber when you drop and re-add article from another publication or add subscription
SQL service

VSTS BUG: 2463716 | 2926217
FIX: Performance problems occur when database lock activity increases in SQL Server
SQL service

VSTS BUG: 2556589 | 2936984
FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server 2008 or SQL Server 2008 R2
SQL service

VSTS BUG: 2371475 | 2939277
FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
SQL performance

VSTS BUG: 2525246 | 2952260
FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server
SQL service

VSTS BUG: 2272416 | 2957174
FIX: Cannot create compressed nonclustered index on a table that has a clustered index with two or more bit columns
SQL service

VSTS BUG: 2556600 | 2963408
FIX: Error 5180 occurs when you query BLOB column data in SQL Server
SQL service

VSTS BUG: 2447011 | 2963658
FIX: The TDE enabled database stops responding indefinitely on WRITELOG or LOGBUFFER wait in SQL Server
SQL service

VSTS BUG: 2442037 | 2963668
FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions
SQL service

VSTS BUG: 2403831 | 2967103
FIX: Service broker stops working when you unregister and remove a session in SQL Server 2008 R2
SQL service

VSTS BUG: 2462604 | 2967240
FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server
SQL service

VSTS BUG: 2451659 | 2971611
FIX: Memory leak occurs during Process Update on a dimension in SSAS 2008 R2
Analysis Services

VSTS BUG: 2626083 | 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server 2008 R2
SQL service

VSTS BUG: 2691569 | 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS 2008 R2
Analysis Services

VSTS BUG: 2624484 | 2977312
FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server 2008 R2
SQL service

This update could be applied to Microsoft SQL Server 2008 R2 Service Pack 2, when used with:

  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Integration Services
  • Microsoft SQL Server 2008 R2 Reporting Services

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 13 

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for all platforms: 64-bit, 32-bit and Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

>> 2008R2_SP2_CU13_2967540_10_50_4319_IA64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_IA64
>> 2008R2_SP2_MDS_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_x64
>> SQLServer2008R2_SP2_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_RSShrPnt_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_x86
>> SQLServer2008R2_SP2_CU13_2967540_10_50_4319_x86

Enjoy for Last Time!