[EN] SQL Server 2012 SP2 Cumulative Update #5 is available!

LOGO__SQLServer2012SP2First package for updates which have been released in March is for SQL Server 2012 with Service Pack 2. In this Cumulative Updates No 5 {build no 11.0.5582.0} Microsoft resolved almost thirty bugs. Some fixed errors has been published in Cumulative Update No 6 for SQL Server 2014 {post here} like SOS_CACHESTORE or PowerPivot bugs. Here is the full list of fixed bugs.

 

VSTS BUG:  4034265 | KB: 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission
Reporting Services

VSTS BUG:  4067264 | KB: 3016165
FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server
SQL service

VSTS BUG:  3746215 | KB: 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages in SSIS 2012
Integration Services

VSTS BUG:  4067256 | KB: 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS 2012 data mining models
Analysis Services

VSTS BUG:  4067259 | KB: 3026082
FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014
SQL service

VSTS BUG:  4067262 | KB: 3026083
FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014
SQL service

VSTS BUG:  4067274 | KB: 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG:  3995494 | KB: 3029776
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension
Analysis Services

VSTS BUG:  3980976 | KB: 3032476
FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012
SQL service

VSTS BUG:  4058285 | KB: 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source
Integration Services

VSTS BUG:  4077857 | KB: 3034492
FIX: “Call to Excel Services returned an error” error when you refresh the document in the PowerPivot Gallery
Analysis Services

VSTS BUG:  4124969 | KB: 3034679
FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING
High Availability

VSTS BUG:  3987784 | KB: 3036201
FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 MDS
Master Data Services (MDS)

VSTS BUG:  4019503 | KB: 3037624
FIX: Complex parallel query does not respond in SQL Server 2012
SQL performance

VSTS BUG:  4138602 | KB: 3038267
FIX: Error “[BC30494] line is too long” occurs when you upload an SSRS 2012 report to Reporting Service Report Manager
Reporting Services

VSTS BUG:  4001004 | KB: 3038331
FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS 2012
Reporting Services

VSTS BUG:  4111094 | KB: 3038332
FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports
Reporting Services

VSTS BUG:  4136827 | KB: 3038943
FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups
High Availability

VSTS BUG:  4142251 | KB: 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012
SQL service

VSTS BUG:  4166567 | KB: 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012
Reporting Services

VSTS BUG:  4166534 | KB: 3040804
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012
Integration Services

VSTS BUG:  4166659 | KB: 3041056
FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2
Reporting Services

VSTS BUG:  4168490 | KB: 3041859
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application
SQL connectivity

VSTS BUG:  4203721 | KB: 3042007
FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle
SQL service

VSTS BUG:  4142191 | KB: 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012
Analysis Services

VSTS BUG:  4073547 | KB: 3042135
FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012
SQL service

VSTS BUG:  4049132 | KB: 3044958
FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails
SQL service

 

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

     – Microsoft SQL Server 2012 Enterprise

     – Microsoft SQL Server 2012 Developer

     – Microsoft SQL Server 2012 Express

     – Microsoft SQL Server 2012 Standard

     – Microsoft SQL Server 2012 Web

     – Microsoft SQL Server 2012 Analysis Services

     – Microsoft SQL Server 2012 Business Intelligence

     – Microsoft SQL Server 2012 for Embedded Systems

     – Microsoft SQL Server 2012 Parallel Data Warehouse

     – SQL Server 2012 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 5

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

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

    SQLServer2012_SP2_CU5_3037255_11_0_5582_x86

    SQLServer2012_SP2_CU5_3037255_11_0_5582_x64

Enjoy!

[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 SP1 Cumulative Update 6 is available

LOGO__SQLServer2012Another update for SQL Server 2012 is available. This Cumulative Update No 6 for SQL Server 2012 with Service Pack 1 (Build number: 11.0.3381.0) resolving over twenty five requested bugs, appeared after Service Pack 1. The list are below:

VSTS BUG: 1222472 | 2827857
FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation

VSTS BUG: 1293680 | 2847735
FIX: "A PivotTable, cube function or slicer using connection <conn> had failed to refresh" error when you update data in an Excel workbook that is sourced from a perspective in SSAS 2012

VSTS BUG: 1396889 | 2859713
FIX: "The decryption key is incorrect" error when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2008, SQL Server 2012 or SQL Server 2008 R2

VSTS BUG: 1347148 | 2860446
FIX: An unexpected error occurs in function ‘XMCompressionAnalyzer::SelectBitPackCompression’ when you perform a Process command against a partitioned table in SSAS 2012

VSTS BUG: 1366483 | 2864111
FIX: It takes longer than expected to cancel an MDX query that contains many GROUP BY clauses in SSAS 2012

VSTS BUG: 1382357 | 2872854
FIX: Error 14420 when you enable Log Shipping on databases that are in an AlwaysOn availability group in SQL Server 2012

VSTS BUG: 1405603 | 2872946
FIX: CPU spinning occurs when you use Power View to run a DAX query against a Multidimensional model in SSAS 2012

VSTS BUG: 1384027 | 2873474
FIX: Error "Column ‘<column name>’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause" when you run a query in SQL Server 2012

VSTS BUG: 1416030 | 2874875
FIX: Dependent DBA member data is not updated when you use entity-based staging in MDS in SQL Server 2012

VSTS BUG: 1377755 | 2874957
FIX: Scheduled data refresh disabled after you make some modifications to the PowerPivot workbook in SharePoint 2013 that interacts with SSAS 2012

VSTS BUG: 1362520 | 2875158
FIX: Inconsistent data order when you copy data from a PowerPivot worksheet to an Excel worksheet

VSTS BUG: 1428610 | 2876733
FIX: Slow performance on SQL Server 2012 linked server when you update the data together with different collation on the remote server

VSTS BUG: 1428782 | 2876882
FIX: "Internal error: An unexpected error occurred" when you run a Process command against the TFS SSAS cube

VSTS BUG: 1457677 | 2877100
FIX: A memory leak occurs when you enable AlwaysOn Availability Groups or SQL Server failover cluster in Microsoft SQL Server 2012

VSTS BUG: 1435963 | 2877857
FIX: "The OLE DB provider ‘<ProviderName>’ provided invalid collation" when you execute distributed queries through a linked server in SQL Server 2012 SP1

VSTS BUG: 1436162 | 2878139
FIX: "Using ‘dbghelp.dll’ version ‘4.0.5’" error is logged in SQL Server 2012 when a statement or job executes the sys.fn_xe_file_target_read_file stored procedure

VSTS BUG: 1403970 | 2878975
FIX: Access violation when you run a query that uses the "change_tracking_current_version()" function in SQL Server 2012

VSTS BUG: 1402400 | 2879619
FIX: Date data is incorrect when you export an SSRS report that references a date that is earlier than March 1, 1900 as an Excel worksheet

VSTS BUG: 1428185 | 2880071
FIX: Error messages when you perform ProcessRecalc operation after the ProcessData operation on an SSAS 2012 tabular model

VSTS BUG: 1328807 | 2880094
FIX: Grand total or subtotal rows display incorrect result in a Power View report that runs against a multidimensional cube in SSAS 2012

VSTS BUG: 1402434 | 2884124
FIX: "Type mismatch" error when you run an MDX query that uses the Member.Name property against an SSAS 2012 database

VSTS BUG: 1387645 | 2884126
FIX: "RESTORE DATABASE is terminating abnormally" error when you restore the secondary database in SQL Server 2012

VSTS BUG: 21593 | 2886673
FIX: Incorrect returned value when you run an MDX query that contains a filter on a parent/child dimension in SSAS 2012

 

This update could be applied for: Microsoft SQL Server 2012 Service Pack 1, when used with:

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

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 6

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

  • SQL Server 2012 | x86 | 2012_SP1_PPExcel_CU6_2874879_11_0_3381_x86
  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU6_2874879_11_0_3381_x86
  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU6_2874879_11_0_3381_x86
  • SQL Server 2012 | x64 | 2012_SP1_DAC_CU6_2874879_11_0_3381_x64
  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU6_2874879_11_0_3381_x64
  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU6_2874879_11_0_3381_x64

Enjoy!