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

LOGO__SQLServer2014Two weeks ago Microsoft released two new packages with cumulative updates. In my first post I writing about Cumulative Update No 9 {build 12.0.2553.0} for SQL Server 2014 RTM release. In this package Microsoft fixed about thirty bugs and here is the list:

VSTSBUG: 4540812 | 3057876
FIX: An AlwaysOn database on a secondary replica shows a “NOT SYNCHRONIZING” status in SQL Server 2014
High Availability

VSTSBUG: 4921071 | 3073294
FIX: “Possible schema corruption. Run DBCC CHECKCATALOG” error occurs when you delete column in SQL Server 2014
SQL service

VSTSBUG: 4744188 | 3054504
FIX: The bcp utility may crash when you use SQL Server 2012 or SQL Server 2014
SQL connectivity

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

VSTSBUG: 5181897 | 3030352
FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database
SQL service

VSTSBUG: 5181899 | 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications
SQL service

VSTSBUG: 5181901 | 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012
SQL service

VSTSBUG: 5181929 | 3064292
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 or SQL Server 2014
SQL service

VSTSBUG: 5181931 | 3064454
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014
SQL performance

VSTSBUG: 5181936 | 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTSBUG: 5181954 | 3068776
FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 or 2014
SQL performance

VSTSBUG: 4157566 | 3038876
FIX: It takes longer time than expected to list the databases in Object Explorer in SSMS 2014
Management Tools

VSTSBUG: 5186732 | 3082005
FIX: Case-sensitive does not work in MDS database in SQL Server 2014
Master Data Services (MDS)

VSTSBUG: 5005435 | 3082860
FIX: Access violation occurs when you execute a query that contains many joins and coalesce functions in SQL Server 2014
SQL performance

VSTSBUG: 4812206 | 3082885
FIX: Cannot find file error occurs when you execute a maintenance plan to back up database in SQL Server 2014
Management Tools

VSTSBUG: 4843278 | 3080155
FIX: Rare index corruption when you build a columnstore index with parallelism on a partitioned table in SQL Server 2014
SQL service

VSTSBUG: 5020180 | 3081020
FIX: A stalled dispatcher system dump occurs resulting in failover and service outage on the availability groups in SQL Server 2014
High Availability

VSTSBUG: 4745312 | 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2014 SP1
SQL service

VSTSBUG: 5181907 | 3076444
FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 or 2014
SQL service

VSTSBUG: 5181913 | 3069154
FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only
SQL service

VSTSBUG: 5181915 | 3074425
FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or SQL Server 2014
SQL service

VSTSBUG: 5181923 | 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014
SQL performance

VSTSBUG: 5181956 | 3069320
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 or 2014 Master Data Services to start the workflow
MDS

VSTSBUG: 5181958 | 2820068
Can’t install SQL Server by using InstallShield or bootstrapping application
Setup & Install

VSTSBUG: 5181962 | 3074535
FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server
SQL service

VSTSBUG: 4811930 | 3072814
FIX: Access violation occurs when you connect to an instance of SQL Server by using sqlcmd utility in SQL Server 2014
SQL connectivity

VSTSBUG: 5181950 | 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014
SQL service

VSTSBUG: 5181967 | 3075176
FIX: Incorrect results from the CHANGETABLE() function when snapshot isolation is enabled for a SQL Server 2012 or 2014 database
SQL service

VSTSBUG: 5196815 | 3083189
FIX: “Requested value was not found” error when you deploy a SQL Server 2014 database to Windows Azure
Management Tools

VSTSBUG: 5181917 | 3061215
FIX: “Cannot read 8 bytes from file” error occurs when you use SSIS 2012 or 2014
Integration Services

 

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

  • Microsoft SQL Server 2014 Service Pack 1 ONLY

 

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 9

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:

    SQLServer2014_RTM_CU9_3075949_12_0_2553_x64
    SQLServer2014_RTM_CU9_3075949_12_0_2553_x86

     

Enjoy!

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

Just one update package in July. In this Cumulative Update No 7 {build 11.0.5623.0} for Microsoft SQL Server 2012 Service Pack 2 (SP2) released two weeks ago Microsoft fixed thirty four bugs. Important information for all DBA (and their SEC friends) is that SQL Server 2012 SP2 Cumulative Update 7 contains the recently released Security Bulletin MS15-058 (KB3065718).

VSTSBUG: 3983191 | 3029096
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly
Integration Services

VSTSBUG: 4346613 | 3030352
FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 database
SQL service

VSTSBUG: 4178633 | 3052461
FIX: Some attributes in element are ignored when you transform XML file in SSIS 2012
Integration Services

VSTSBUG: 4639762 | 3062001
FIX: “Failed to create kernel event for collection set” error occurs when you use Data Collection in SQL Server 2012
Management Tools

VSTSBUG: 4602046 | 3061215
FIX: “Cannot read 8 bytes from file” error occurs when you use SSIS 2012
Integration Services

VSTSBUG: 4713547 | 3064454
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012
SQL performance

VSTSBUG: 4715206 | 3065060
FIX: “Unable to create restore plan due to break in the LSN chain” error when you restore differential backup in SSMS
Management Tools

VSTSBUG: 4743330 | 3068351
FIX: ROLAP Distinct Count on data source is not started when it is running from SSAS 2012 to back-end SQL Server 2014
Analysis Services

VSTSBUG: 4662556 | 3068359
FIX: “Cannot find the OLAP cube Model” error when you update the pivot table in a SharePoint document in SQL Server 2012
Analysis Services

VSTSBUG: 4520905 | 3068439
FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012
SQL performance

VSTSBUG: 4694348 | 3068468
FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2012
SQL service

VSTSBUG: 4804569 | 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012
SQL service

VSTSBUG: 4805976 | 3068776
FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012
SQL performance

VSTSBUG: 4524535 | 3069154
FIX: You cannot set a SQL Server 2012 database to single-user mode if the database is read-only
SQL service

VSTSBUG: 4436770 | 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012
SQL service

VSTSBUG: 4925413 | 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012
Analysis Services

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

VSTSBUG: 4928677 | 3074535
FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server
SQL service

VSTSBUG: 4683321 | 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012
SQL performance

VSTSBUG: 4547054 | 3074425
FIX: Contention occurs when you execute many ad-hoc queries in SQL Server 2012
SQL service

VSTSBUG: 5013383 | 3075176
FIX: You receive incorrect results from the CHANGETABLE() function when snapshot isolation for a SQL Server 2012 database
SQL service

VSTSBUG: 4495133 | 3076444
FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 SP2
SQL service

VSTSBUG: 4781857 | 3075669
FIX: SSAS 2012 crashes when you execute an MDX query that contains a large number of Union expressions
Analysis Services

VSTSBUG: 4376957 | 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications
SQL service

VSTSBUG: 4705249 | 3064292
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012
SQL service

VSTSBUG: 4933896 | 3073907
FIX: A SQL Server 2012 SSIS package with an Execute SQL Task may stop responding
Analysis Services

VSTSBUG: 4691746 | 3063438
FIX: XSLT transformation fails when you run an SSIS 2014 package that contains multiple concurrent XML tasks
Integration Services

VSTSBUG: 4716342 | 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTSBUG: 4939175 | 3070147
FIX: Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server
SQL service

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

VSTSBUG: 4817323 | 3069320
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 Master Data Services to start the workflow
MDS

VSTSBUG: 4465179 | 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem
Management Tools

VSTSBUG: 4834221 | 2820068
FIX: Can’t install SQL Server by using InstallShield or bootstrapping application
Setup & Install

 

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

  • Microsoft SQL Server 2012 Service Pack 2 ONLY

 

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 7

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_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleDes_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleSer_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleDes_CU7_3072100_11_0_5623_x86
    SQLServer2012_SP2_CU7_3072100_11_0_5623_x86
    2012_SP2_AOrcleSer_CU7_3072100_11_0_5623_x86

     

Enjoy!

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

LOGO__SQLServer2014On June 22nd (about week ago) Microsoft released two packages of updates. First package is the Cumulative Update No 8 {bulid no 12.0.2546.0} for Microsoft SQL Server 2012 SP2 and Microsoft fixed about forty bugs. Released list of bugs are below:

VSTS BUG: 4523243 | 3067826
An “Access Violation” occurs when you connect to an instance of SQL Server 2014
SQL service

VSTS BUG: 4778150 | 3067257
FIX: Partial results in a query of a clustered columnstore index in SQL Server 2014
SQL service

VSTS BUG: 4745322 | 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4544422 | 3029096
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly
Integration Services

VSTS BUG: 4638931 | 3058512
FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014
Integration Services

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

VSTS BUG: 4745295 | 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: 4745316 | 3047538
FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 4520890 | 3067896
Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014
SQL performance

VSTS BUG: 4715603 | 3070139
FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014
SQL service

VSTS BUG: 4516100 | 3069488
“Non-yielding Scheduler” error occurs and SQL Server stops responding when a database has columnstore indexes on a Microsoft SQL Server 2014 instance
SQL service

VSTS BUG: 4745318 | 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

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

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

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

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

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

VSTS BUG: 4638932 | 2999809
FIX: Poor performance when a query contains table joins in SQL Server 2014
Management Tools

VSTS BUG: 4838266 | 3070147
Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014
SQL service

VSTS BUG: 4320465 | 3048734
FIX: An I/O error that occurs on BPE files causes SQL Server 2014 to disable BPE
SQL service

VSTS BUG: 4319316 | 3048627
FIX: “Cannot access the specified path or file on the server” when you use CSV in SSMS to back up or restore database
Management Tools

VSTS BUG: 4794520 | 3067968
FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014
SQL service

VSTS BUG: 4465182 | 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem
Management Tools

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

VSTS BUG: 4488005 | 3066682
FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014
MDS

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

VSTS BUG: 4745709 | 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: 4745297 | 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time
Analysis Services

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

VSTS BUG: 4729309 | 3052167
FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014
SQL performance

VSTS BUG: 4745312 | 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4632737 | 3061685
FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014
SQL performance

VSTS BUG: 4729310 | 3063054
Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures
SQL service

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

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

VSTS BUG: 4728820 | 3067659
FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks
SQL service

VSTS BUG: 4633760 | 3053752
FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source
Analysis Services

VSTS BUG: 4507041 | 3055646
FIX: Error 35377 when you run a parallel query that contains MERGE statements in SQL Server 2014
SQL service

 

Newest part of updates is published list detailed publishing time and name of all necessary files in the package. The English version of this package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

x86-based versions

  • SQL Server 2014 Business Intelligence Development Studio
  • SQL Server 2014 Analysis Services
  • SQL Server 2014 Database Services Common Core
  • SQL Server 2014 Data Quality Client
  • SQL Server 2014 Data Quality
  • SQL Server 2014 sql_dreplay_client
  • SQL Server 2014 sql_dreplay_controller
  • SQL Server 2014 Database Services Core Instance
  • SQL Server 2014 Database Services Core Shared
  • SQL Server 2014 Integration Services
  • SQL Server 2014 Reporting Services
  • SQL Server 2014 Management Studio
  • SQL Server 2014 Tools and Workstation Components

x64-based versions

  • SQL Server 2014 Business Intelligence Development Studio
  • SQL Server 2014 Analysis Services
  • SQL Server 2014 Database Services Common Core
  • SQL Server 2014 Data Quality Client
  • SQL Server 2014 Data Quality
  • SQL Server 2014 sql_dreplay_client
  • SQL Server 2014 sql_dreplay_controller
  • SQL Server 2014 Database Services Core Instance
  • SQL Server 2014 Database Services Core Shared
  • SQL Server 2014 Integration Services
  • SQL Server 2014 Reporting Services
  • SQL Server 2014 Management Studio
  • SQL Server 2014 Tools and Workstation Components

 

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

  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Web
  • SQL Server 2014 Reporting Services
  • Microsoft SQL Server 2014 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 8

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:

    SQLServer2014_RTM_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleDes_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleSer_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleDes_CU8_3067836_12_0_2546_x86
    SQLServer2014_RTM_CU8_3067836_12_0_2546_x86
    2014_RTM_AOrcleSer_CU8_3067836_12_0_2546_x86

     

Enjoy!