[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 2012 Cumulative Update 11 is available

Second part of December’s updates is the last pack for SQL Server 2012 RTM. Why the last? All database administrators should remember about Microsoft Support Lifecycle (site here). For this product, lifecycle going to end:

image

In this Cumulative Update 11 (Build number: 11.0.2424.0) Microsoft fixed fixteen bugs for SQL Server Engine, Analysis Services and Reporting Services. Here is the list:

VSTS BUG: 1664722 | 2823086
FIX: "The MDX function failed because the coordinate for the ‘AttributeName’ attribute contains a set." message when you run an MDX query in SQL Server 2012 or in SQL Server 2008 R2

VSTS BUG: 1497514 | 2844210
FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computer

VSTS BUG: 1535754 |2861456
FIX: Access violation in replication Distribution Agent in SQL Server 2008 R2 or SQL Server 2012 Transactional Replication

VSTS BUG: 1664714 | 2864930
FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL Server 2008 R2 BIDS or n SQL Server 2012 SSDT

VSTS BUG: 1664720 | 2875949
FIX: VSS backup operations are not successful when the auto-recovery option is enabled in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664728 | 2878377
FIX: DecryptByKeyAutoAsymKey() function returns "NULL" value when you decrypt data that is encrypted by an asymmetric key in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664726 | 2878807
FIX: System.NullReferenceException is thrown when an SSRS 2008 R2 or SSRS 2012 report or subscription is opened in SharePoint integrated mode

VSTS BUG: 1664730 | 2878968
FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1664732 | 2885565
FIX: Report Builder 3.0 may close unexpectedly when you search an attribute in Query Designer in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1610539 | 2889492
FIX: You cannot open the SQL Server Analysis Services properties dialog box in Windows 8.1

VSTS BUG: 1664724 | 2889987
FIX: "Invalid column name ‘<ColumnName>’" error when you run some MDX queries that you could previously run successfully in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664738 | 2890095
FIX: Interrupted distributed query may return partial result set without any error in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664718 | 2890818
FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 1664736 | 2891230
FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRS 2008 R2 or SSRS 2012

VSTS BUG: 1758069 | 2892741
FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

 

This update could be applied for: Microsoft SQL Server 2012 RTM

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web

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 11

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 two platforms: 32-bit & 64-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2012 | x86 | 2012_RTM_DAC_CU11_2908007_11_0_2424_x86
  • SQL Server 2012 | x86 | 2012_RTM_SapBI_CU11_2908007_11_0_2424_x86
  • SQL Server 2012 | x86 | 2012_RTM_PPExcel_CU11_2908007_11_0_2424_x86
  • SQL Server 2012 | x86 | SQLServer2012_RTM_CU11_2908007_11_0_2424_x86
  • SQL Server 2012 | x64 | 2012_RTM_DAC_CU11_2908007_11_0_2424_x64
  • SQL Server 2012 | x64 | 2012_RTM_SapBI_CU11_2908007_11_0_2424_x64
  • SQL Server 2012 | x64 | SQLServer2012_RTM_CU11_2908007_11_0_2424_x64
  • SQL Server 2012 | x64 | 2012_RTM_PPExcel_CU11_2908007_11_0_2424_x64
  • SQL Server 2012 | x64 | 2012_RTM_RSShrPnt_CU11_2908007_11_0_2424_x64

Enjoy!

[EN] SQL Server 2008 R2 SP2 Cumulative Update 10 is available

LOGO__SQLServer2008R2v2Two updates pack from December 2013. After two weeks some part of my environment are ready for it. First pack for SQL Server 2008 R2 with SP2. In this Cumulative Update (build 10.50.4297.0) Microsoft fixed about fifteen bugs for many parts of SQL Server environment for SQL Engine, Analysis Services, Reporting Services ans Integration Services. Here is the list:

VSTS BUG: 1258005 | 2297709
FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 1611278 | 2532079
FIX: DML statements do not run on some columns in a table after you enable CDC on some other columns in SQL Server 2008 R2

VSTS BUG: 1590438 | 2671078
FIX: "Attempting to set a non-NULL-able column’s value to NULL" error message when you use a MERGE statement in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1502369 | 2888996
FIX: Data purity corruption in table sys.sysbinobjs on MASTER database when you log on SQL Server 2008 R2 by using SA account and run the DBCC CHECKDB statement

VSTS BUG: 1610543 | 2889492
FIX: You cannot open the SQL Server Analysis Services properties dialog box in Windows 8.1

VSTS BUG: 1519116 | 2891115
FIX: "The search text was not found" error when you search specific formatting numeric values from a report in SSRS 2008 R2

VSTS BUG: 1540252 | 2891489
FIX: The replication Log Reader Agent fails when you enable CDC and Transaction Replication for some columns in SQL Server 2008 R2

VSTS BUG: 1560630 | 2892741
FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1672382 | 2895694
FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012 or in SSAS 2008 R2

VSTS BUG: 1650149 | 2902858
FIX: SSIS package will never stop running when the package contains a Fuzzy Lookup task from BIDS in SQL Server 2008 R2

VSTS BUG: 1659059 | 2904010
FIX: A small number of rows are sampled in SQL Server 2008 R2 when table statistics are updated automatically or together with specified sampling rate

VSTS BUG: 1748108 | 2911026
FIX: Access violation when you query sys.dm_server_memory_dumps in SQL Server 2008 R2

VSTS BUG: 1713989 | 2911385
FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2

VSTS BUG: 1765207 | 2912949
FIX: SSAS crashes when there are more than one threads try to access a SSAS 2008 R2 cube at the same time

VSTS BUG: 1742457 | 2913206
FIX: Cannot pass report parameters to Reports in SharePoint Document Library in SSRS 2008 R2 by using HTML forms

 

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

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

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 10

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: 32-bit, 64-bit & Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2008 R2 | x86 | 2008R2_SP2_SNAC_CU10_2908087_10_50_4297_x86

  • SQL Server 2008 R2 | x86 | SQLServer2008R2_SP2_CU10_2908087_10_50_4297_x86

  • SQL Server 2008 R2 | x64 | 2008R2_SP2_MDS_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | x64 | 2008R2_SP2_SNAC_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | x64 | SQLServer2008R2_SP2_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | x64 | 2008R2_SP2_RSShrPnt_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | ia64 | SQLServer2008R2_SP2_CU10_2908087_10_50_4297_IA64

  • SQL Server 2008 R2 | ia64 | 2008R2_SP2_SNAC_CU10_2908087_10_50_4297_IA64

Enjoy!