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

Newest update for SQL Server 2012. This time for SQL Server 2012 with Service Pack 2. In this Cumulative Update No 8 {build 11.0.5634.1} Microsoft released over twenty four bugs and issues. Here is the list of fixed issues:

VSTS BUG: 5020090 | 3081074
FIX: A stalled dispatcher system dump forces a failover and service outage in SQL Server 2014 or SQL Server 2012
High Availability

VSTS BUG: 4812002 | 3082877
FIX: No error is prompted when connection is terminated in sqlcmd
SQL service

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

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

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

VSTS BUG: 5469866 | 3087920
FIX: Excel crashes when you use Excel 2010 on a computer that has the .NET Framework 4.6 installed
Analysis Services

VSTS BUG: 5153046 | 3088480
FIX: Data spill occurs when you sort large amount of data in SQL Server 2012
SQL performance

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

VSTS BUG: 5173142 | 3081150
FIX: Orientation setting is lost when you export a report to a Word document in SSRS 2012
Reporting Services

VSTS BUG: 5510259 | 3089527
FIX: FileStream Share Access fails when you use AlwaysOn Availability Groups feature in SQL Server 2012
High Availability

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

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

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

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

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

VSTS BUG: 5174510 | 3092703
FIX: Access violation occurs in AlwaysOn availability groups scenarios in SQL Server 2012
SQL performance

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

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

VSTS BUG: 5586474 | 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: 5502135 | 3093869
FIX: SQLDiag fails with function 87 error in SQL AlwaysOn scenario where the server name has 15 characters
Management Tools

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

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

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

 

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

  • Microsoft SQL Server 2012 Service Pack 2

 

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:

    SQL Server 2012 | ql11Sp2Cu8x64
    SQL Server 2012 | Sql11Sp2Cu8x86

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!

[EN] SQL Server 2012 SP1 Cumulative Update 8 is available

LOGO__SQLServer2012SP1Second package released last week os for SQL Server 2012 Service Pack 1. Of course this Cumulative Update no 8 {build number: 11.0.3401.0} Microsoft resolved more errors, more than for SQL Server 2008 (wrote about it in my previous post). Here is the list of fixed bugs – thirty four bugs:

VSTS BUG: 1852083 | 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, SQL Server 2008 R2 or SQL Server 2012

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

VSTS BUG: 1664721 | 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: 1664729 | 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: 1664727 | 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: 1664733 | 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: 1852085 | 2888996
FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server 2008 R2 or SQL Server 2012 by using the SA account and then run DBCC CHECKDB

VSTS BUG: 1664739 | 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: 1664719 | 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: 1852087 | 2891115
FIX: "The search text was not found" error when you search for numeric data that contains nonbreaking spaces in SSRS 2008 R2 or SSRS 2012

VSTS BUG: 1852089 | 2891489
FIX: Replication Log Reader Agent fails when you enable CDC and transactional replication for some columns in SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1758070 | 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: 1602236 | 2896903
FIX: You cannot perform any administrator actions on the databases when a data model corruption occurs in SSAS 2012

VSTS BUG: 1629110 | 2899939
FIX: Error messages when you create a project level SMO connection manager together with a password for an SSIS 2012 project

VSTS BUG: 1769272 | 2901714
FIX: Server crashes when you import a Windows Azure SQL database to a local SQL Server 2012 database

VSTS BUG: 1640232 | 2901757
FIX: Minute is overwritten by second in XML data after you migrate from SQL Server 2005 to SQL Server 2012

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

VSTS BUG: 1852110 | 2911026
FIX: Access violation may occur when you query sys.dm_server_memory_dumps in SQL Server 2008 R2 or SQL Server 2012

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

VSTS BUG: 1683049 | 2912928
FIX: SQL Server 2012 PowerPivot for SharePoint 2010 cannot create databases when SharePoint server name is FQDN

VSTS BUG: 1852112 | 2912949
FIX: SSAS crashes when more than one thread tries to access an SSAS 2008 R2 or SSAS 2012 cube at the same time

VSTS BUG: 1636271 | 2913102
FIX: Validation of service accounts takes a long time when you set up SQL Server 2012

VSTS BUG: 1798224 | 2915611
FIX: Left arrow key does not work in Expression Editor of SSDT for Visual Studio 2012

VSTS BUG: 1811621 | 2916827
FIX: "Invalid URI: The Uri string is too long." error message when you render a SSRS 2012 report

VSTS BUG: 1812447 | 2916934
FIX: The option ‘Center map to show an embedded map element’ of tab ‘Center and Zoom’ for a map does not work in SSRS 2012

VSTS BUG: 1818080 | 2917636
FIX: SQL Server Agent cannot forward events to a different server in SQL Server 2012

VSTS BUG: 1861773 | 2918791
FIX: The system function sys.fn_hadr_backup_is_preferred_replica does not work correctly after you have CU7 for SQL Server 2012 SP1 installed

VSTS BUG: 1853069 | 2919584
FIX: Incorrect result in a PDF file when you use expressions that contains Lookup function in a SSRS 2012 report

VSTS BUG: 1814392 | 2923460
FIX: The query deadlocks when the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2012

VSTS BUG: 1910328 | 2923838
FIX: Error messages when you use the AMR tool for SQL Server 2014 CTP2 on SQL Server 2012

VSTS BUG: 1912914 | 2923839
FIX: Oracle CDC service shows aborted status when you use CDC for Oracle by Attunity in SQL Server 2012

VSTS BUG: 1788041 | 957823
FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server 2008 or SQL Server 2012

 

This update could be applied for: Microsoft SQL 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 Express
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Standard

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 08

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

  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_AOrcleSer_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_AOrcleDes_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_PPExcel_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x64 | 2012_SP1_AOrcleSer_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_RSShrPnt_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_AOrcleDes_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_DAC_CU8_2917531_11_0_3401_x64

Enjoy!