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

Two update packs has been released by Microsoft for SQL Server stack. First package is for SQL Server 2012 Service Pack 2. In this Cumulative Update No 10 {build no 11.0.5644.2} Microsoft fixed eleven bugs listed below.

This update (VSTS BUG: 5285700 | 321185) introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

          SELECT @@VERSION
          SELECT SERVERPROPERTY(‘PRODUCTUPDATELEVEL)

Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

VSTS BUG: 6200864 | 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 service

VSTS BUG: 5794926 | 3135749
FIX: Incorrect group members are obtained when you execute the xp_logininfo stored procedure in SQL Server
SQL security

VSTS BUG: 5680960 | 3095626
FIX: “No such interface supported” error occurs when you click a parameter drop-down list in a SSRS report or a CRM report
Reporting Services

VSTS BUG: 6091773 | 3109051
FIX: Default settings are used when you print to a non-default printer in SQL Server 2012 Reporting Services
Reporting Services

VSTS BUG: 6346685 | 3125526
FIX: You receive errors when you execute a query that uses tempdb in SQL Server
SQL service

VSTS BUG: 6091565 | 3120595
FIX: Column data is deleted when you update another column in a table in SQL Server 2012
SQL service

VSTS BUG: 6384783 | 3123309
FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server 2012
SQL service

VSTS BUG: 6413081 | 3123089
FIX: The INSTEAD OF trigger uses a different collation than the contained database in SQL Server 2012
SQL performance

VSTS BUG: 6293637 | 3132058
FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server
SQL service

VSTS BUG: 6400183 | 3132062
FIX: The SMK initialization fails on one node of SQL Server failover cluster in SQL Server 2012
SQL security

VSTS BUG: 5912517 | 3123485
FIX: Slow performance occurs when you run MDX query in SSAS 2012
Analysis Services

 

This update could be applies to:

  • Microsoft SQL Server 2012 SP2

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

List ofpackages:

  • SQL12SP2QFECU10\x64\SQLServer2012-KB3120313-x64.exe | 649.0 MB
  • SQL12SP2QFECU10\x86\SQLServer2012-KB3120313-x86.exe | 358.7 MB

Small change which is already implemented for downloading prosess – you will get The Latest Update (by default):

image

Enjoy!

[EN] SQL Server 2014 RTM Cumulative Update #10 is available!

LOGO__SQLServer2014Another post, another SQL Server Update package. Ten days ago Microsoft released two packs of packages for SQL Server 2014. Ten days give us enough time to test those packages. In this post I’m writing about update for SQL Server 2014 RTM. In this Cumulative Update No 10 {build 12.0.2556.4} Microsoft fixed over thirty bugs and below you will find list of fixed errors with KB articles numbers. One of the most interesting bug which have been resolved (and it could by applied for SQL Server 2012 SP2 and SQL Server 2014) is connected with Data Transparent Encryption:

FIX: Transparent Data Encryption certificate can’t be created in SQL Server 2012 or SQL Server 2014

Symptoms

This issue occurs when you use a certificate whose serial number is greater than 16 bytes. When this issue occurs, you receive the following error message:

Msg 15297, Level 16, State 56, Line 1
The certificate, asymmetric key, or private key data is invalid.

 

VSTS BUG: 5181892 | 3052461
FIX: All attributes in element are ignored when you transform XML file in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 5181921 | 3068359
FIX: “Cannot find the OLAP cube Model” error when you update the pivot table in a SharePoint document in SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5715070 | 3095156
FIX: Error 9002 and error 3052 when you try to add or back up log file in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 5715079 | 3087114
FIX: PowerPivot for SharePoint doesn’t run automatic data refresh on the first day of each month
Analysis Services

VSTS BUG: 5715081 | 3088307
FIX: Scheduler deadlock on primary replica when you remove a replica from an AlwaysOn availability group in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 5715085 | 3077273
FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715109 | 3088480
FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct
SQL performance

VSTS BUG: 5715111 | 3080856
FIX: Information disclosure when you create a session cube by using dynamic role-based security in SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5715122 | 3089687
FIX: Can’t export empty Tablix header in CSV file when NoHeader is false in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 5715130 | 3087872
FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5586478 | 3074434
FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory
SQL service

VSTS BUG: 4842820 | 3070382
FIX: Server crash occurs when you run a remote query in a stored procedure by using an invalid user in SQL Server 2014
SQL service

VSTS BUG: 5036524 | 3081757
FIX: Error occurs when you try to view the property of the contained database in SQL Server 2014
Management Tools

VSTS BUG: 5618809 | 3092704
Improvements for Distribution Agent telemetry for Azure Subscriber are available in SQL Server 2014
SQL service

VSTS BUG: 5750004 | 3097073
FIX: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool
SQL service

VSTS BUG: 5707961 | 3097601
FIX: Access violation when you query against a table that contains column store indexes in SQL Server 2014
SQL service

VSTS BUG: 5506182 | 3098529
FIX: Assert occurs when you change the type of column in a table that has clustered columnstore index in SQL Server 2014
SQL service

VSTS BUG: 5181925 | 3063438
FIX: Both XSD validation and XSLT transformation fail when you run an SSIS 2014 package that contains multiple concurrent XML tasks
Integration Services

VSTS BUG: 5181940 | 3066299
FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English
Master Data Services (MDS)

VSTS BUG: 5181948 | 3075669
FIX: SSAS 2012 or SSAS 2014 crashes when you execute an MDX query that contains lots of Union expressions
Analysis Services

VSTS BUG: 5181960 | 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5181964 | 3073907
FIX: SSIS 2012 or SSIS 2014 package with an Execute SQL Task may stop responding
Analysis Services

VSTS BUG: 5715088 | 3080209
FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 5715093 | 3090049
FIX: Transparent Data Encryption certificate can’t be created in SQL Server 2012 or SQL Server 2014
SQL security

VSTS BUG: 5715096 | 3081580
FIX: “String or binary data would be truncated” error when you use peer-to-peer replication in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715106 | 3087094
FIX: It takes longer than expected when you run a query with non-admin user role in SSAS 2012 or SSAS 2014 in Tabular model
Analysis Services

VSTS BUG: 5737533 | 2682488
FIX: Backup operation fails in a SQL Server database after you enable change tracking
SQL service

VSTS BUG: 5715101 | 3091643
FIX: Error occurs when you configure SQL Server replication or set up a linked server in SQL Server 2012 or SQL Server 2014
SQL security

VSTS BUG: 5036524 | 3081758
FIX: Can’t view the properties of a contained database in Object Explorer in SQL Server 2014 SP1
SQL service

VSTS BUG: 5038262 | 3092702
FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012
SQL service

 

This update could be applied Microsoft SQL Server 2014, when used applies to applies to

  • Microsoft SQL Server 2014 Business Intelligence
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Enterprise Core
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Web
  • SQL Server 2014 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 10

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:

    SQL Server 2014|SQL_AS_OLEDB_64
    SQL Server 2014|SQL14_RTM_QFE_CU10_x64
    SQL Server 2014|SQL_AS_OLEDB_64
    SQL Server 2014|SQL_AS_OLEDB_86
    SQL Server 2014|SQL14_RTM_QFE_CU10_x86
    SQL Server 2014|SQL_AS_OLEDB_86

Enjoy!

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

Today Microsoft released tenth package with updates for SQL Server. In this Cumulative Update No 10 (build number: 11.0.3431.0) for SQL Server 2012 with Service Pack 1 Microsoft resolved almost forty problems. Here is the list of bugs and addressed areas:

VSTS BUG: 2306164 | 2881285
FIX: You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014
Integration Services

VSTS BUG: 2002694 | 2928300
FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server 2012
SQL performance

VSTS BUG: 2052021 | 2932559
FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012
Analysis Services

VSTS BUG: 2357156 | 2933103
FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server 2008 R2 or SQL Server 2012
SQL performance

VSTS BUG: 2357158 | 2936154
FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server 2008 R2 or SQL Server 2012
Management Tools

VSTS BUG: 2356242 | 2936328
FIX: Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 2116531 | 2938192
FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012
Integration Services

VSTS BUG: 2357154 | 2938476
FIX: Errors when you use export/import data wizard to move data after apply CU2 for SQL Server 2008 R2 SP2 or in SQL Server 2012
Integration Services

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

VSTS BUG: 2129886 | 2950189
FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 2186130 | 2950209
FIX: Access violation when the start offset is larger than the string length in function Substring in SQL Server 2012
SQL service

VSTS BUG: 2197034 | 2952101
FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server 2012
SQL performance

VSTS BUG: 2356248 | 2953354
FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 2115512 | 2954480
FIX: SSAS instance crashes when you perform writeback action by using the role with cell security defined
Analysis Services

VSTS BUG: 2232058 | 2954861
FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT 2012
Integration Services

VSTS BUG: 2306969 | 2956619
FIX: The execution of an SSIS 2012 package that is stored in MSDB is slower than it is stored on the file system
Integration Services

VSTS BUG: 2281773 | 2957768
FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012
Reporting Services

VSTS BUG: 2125329 | 2957957
FIX: Attributes sort incorrectly after using the Attribute Properties function in SQL Server 2012 MDS Add-in for Excel
Data Quality Services (DQS)

VSTS BUG: 2283857 | 2958012
FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012
SQL service

VSTS BUG: 2279622 | 2958062
FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012
SQL service

VSTS BUG: 2303094 | 2959342
FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012
Reporting Services

VSTS BUG: 2149812 | 2960237
FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server 2012
DQS

VSTS BUG: 2311200 | 2960310
FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server 2012
SQL service

VSTS BUG: 2420698 | 2960735
FIX: Windows Update for SQL Server 2012 image does not work in Microsoft Azure Virtual Machine gallery
Setup & Install

VSTS BUG: 2304784 | 2960989
FIX: Error when you use DQS Cleansing Component with large batch in an SSIS 2012 package
DQS

VSTS BUG: 2285141 | 2961254
FIX: The execution of an MDX query in SSAS 2012 is much slower than it is SSAS 2008 R2
Analysis Services

VSTS BUG: 2306218 | 2961525
FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms application
Reporting Services

VSTS BUG: 2325197 | 2961559
FIX: Incorrect folder when deploying PowerPivot solutions through CA
Analysis Services

VSTS BUG: 2361530 | 2962650
FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012
Analysis Services

VSTS BUG: 2060158 | 2963138
FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012
SQL service

VSTS BUG: 2357979 | 2963372
FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 
Analysis Services

VSTS BUG: 2262879 | 2963373
FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012
Analysis Services

VSTS BUG: 2262837 | 2963377
FIX: An exception and access violation occur when you run an MDX calculation in SSAS 2012
Analysis Services

VSTS BUG: 2288955 | 2963836
FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012
Reporting Services

VSTS BUG: 2024232 | 2967634
FIX: SSIS 2012 XML validator only outputs "TRUE" or "FALSE" when you perform XML validation
Integration Services

VSTS BUG: 2290141 | 2967635
FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS
DQS

 

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

  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Express

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 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_RBS_CU10_2954099_11_0_3431_x64
>> 2012_SP1_RSShrPnt_CU10_2954099_11_0_3431_x64
>> 2012_SP1_DAC_CU10_2954099_11_0_3431_x64
>> 2012_SP1_CU10_2954099_11_0_3431_x64
>> 2012_SP1_PPExcel_CU10_2954099_11_0_3431_x64
>> 2012_SP1_RBS_CU10_2954099_11_0_3431_x86
>> 2012_SP1_DAC_CU10_2954099_11_0_3431_x86
>> 2012_SP1_PPExcel_CU10_2954099_11_0_3431_x86
>> SQLServer2012_SP1_CU10_2954099_11_0_3431_x86

Enjoy!