[EN] SQL Server 2012 SP1 Cumulative Update #16 is available!

On May 18th Microsoft released two packages of updates. First is the Cumulative Update No 16 {build no 11.0.3492.0) for Microsoft SQL Server 2012 SP1 RTM and Microsoft fixed last four errors. The short list of fixed bugs are available below. But most important messge from this release are:

This is the final Cumulative Update for SQL Server 2012 Service Pack 1. 

SQL Server 2012 SP1 exits mainstream support on July 14, 2015.

VSTS BUG:  4474328 | KB: 3054530
FIX: Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable
SQL service

VSTS BUG:  4217349 | KB: 3042629
FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012
SQL service

VSTS BUG:  1335674 | KB: 2867316
FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service
SQL service

VSTS BUG:  4225562 | KB: 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012
SQL service

This update could be applied Microsoft SQL Server 2012 Service Pack 1, 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 Business Intelligence
  • Microsoft SQL Server 2012 Analysis Services
  • 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 16

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:

    2012_SP1_PPExcel_CU16_3052476_11_0_3492_x86
    SQLServer2012_SP1_CU16_3052476_11_0_3492_x86
    2012_SP1_RSShrPnt_CU16_3052476_11_0_3492_x64
    2012_SP1_PPExcel_CU16_3052476_11_0_3492_x64
    SQLServer2012_SP1_CU16_3052476_11_0_3492_x64

Enjoy!

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

On May 18th Microsoft released two packages of updates. Second is the Cumulative Update No 6 {bulid no 11.0.5592.0} for Microsoft SQL Server 2012 SP2 and Microsoft fixed twenty three bugs. Released list of bugs are below.

VSTS BUG: 4385496 | KB: 3053960
FIX: A system assertion in longrec.inl:1318 occurs when you rebuild or create an index on a table in SQL Server 2012
SQL service

VSTS BUG: 4259067 | KB: 3054180
FIX: Time to create a SQL Server LineString instance may take longer than expected in SQL Server 2012
SQL service

VSTS BUG: 3983191 | KB: 3029096
FIX: The changes in Oracle database are not replicated to the SQL Server 2012 database correctly
Integration Services

VSTS BUG: 4302331 | KB: 3047538
FIX: Result of aggregated values is incorrect when you execute a MDX query in SSAS 2012
Analysis Services

VSTS BUG: 4270418 | KB: 3054504
FIX: The bcp utility may crash when you use SQL Server 2012
SQL connectivity

VSTS BUG: 4320246 | KB: 3054530
FIX: Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable
SQL service

VSTS BUG: 4227763 | KB: 3043889
FIX: The chart in SSRS 2012 report is not updated correctly when you update the parameter in the URL of the report
Reporting Services

VSTS BUG: 4433378 | KB: 3042629
FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012
SQL service

VSTS BUG: 4346311 | KB: 3050636
FIX: Cannot schedule a subscription in an SSRS 2012 report when the data source is SAP NetWeaver BI type
Reporting Services

VSTS BUG: 4333683 | KB: 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012
SQL service

VSTS BUG: 4001676 | KB: 3033456
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012
Analysis Services

VSTS BUG: 4230622 | KB: 3051993
FIX: The value of NUMBER type is truncated when you select data from Oracle linked server by using OLE DB provider
SQL service

VSTS BUG: 3934649 | KB: 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012
Integration Services

VSTS BUG: 4452477 | KB: 3011867
SQL Server in-place upgrade fails if the there’s no JOBS folder
Setup & Install

VSTS BUG: 4254787 | KB: 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server
SQL security

VSTS BUG: 4095370 | KB: 3035737
FIX: Access violation occurs when you run cube writeback commit transaction and batch processing at the same time
Analysis Services

VSTS BUG: 4219927 | KB: 3041476
FIX: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014 or SQL Server 2012
SQL service

VSTS BUG: 4221342 | KB: 2867316
FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service
SQL service

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

VSTS BUG: 4301100 | KB: 2619077
FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry
SQL service

VSTS BUG: 4326594 | KB: 3036601
FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 or 2014 MDS
Master Data Services (MDS)

VSTS BUG: 4204971 | KB: 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services
Analysis Services

VSTS BUG: 4302623 | KB: 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012
SQL connectivity

 

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
  • SQL Server 2012 Reporting Services
  • Microsoft SQL Server 2012 Analysis Services
  • 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 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:

    2012_SP2_SNAC_CU6_3052468_11_0_5592_x86
    SQLServer2012_SP2_CU6_3052468_11_0_5592_x86
    2012_SP2_SNAC_CU6_3052468_11_0_5592_x64
    SQLServer2012_SP2_CU6_3052468_11_0_5592_x64

Enjoy!

[EN] SQL Server 2012 SP1 Cumulative Update #15 is available!

LOGO__SQLServer2012SP1The second pack of updates for SQL Server in March is for SQL Server 2012 with Service Pack 1. In this Cumulative Update no 15 {build no 11.0.3487.0} Microsoft solved only one problem, which has been reported after latest CU 14.

VSTS BUG:  4106885 | KB: 3036601
FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 MDS
Master Data Services (MDS)

This update could be applied to applies Microsoft SQL Server 2012 Service Pack 1, 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
  • SQL Server 2012 Reporting Services
  • Microsoft SQL Server 2012 for Embedded Systems

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 15

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:

    2012_SP1_PPExcel_CU15_3038001_11_0_3487_x86
    SQLServer2012_SP1_CU15_3038001_11_0_3487_x86
    2012_SP1_RSShrPnt_CU15_3038001_11_0_3487_x64
    2012_SP1_PPExcel_CU15_3038001_11_0_3487_x64
    SQLServer2012_SP1_CU15_3038001_11_0_3487_x64

Enjoy!