[EN] SQL Server 2014 SP1 Cumulative Update #3 is available!

LOGO__SQLServer2014Ten 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 with Service Pack 1. In this Cumulative Update No 3 {build 12.0.4427.24} Microsoft fixed about forty bugs and here is the list of fixed KB articles:

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

VSTS BUG: 5666744 | 3094865
FIX: “The process could not initialize ”” error occurs when you use merge publication in SQL Server 2014
SQL service

VSTS BUG: 5704512 | 3096617
FIX: Can’t backup in-memory OLTP database that is restored by using full and differential restore in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5575649 | 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: 5544313 | 3097970
FIX: Sp_describe_undeclared_parameters returns incorrect result when undeclared parameter targets a decimal column
SQL service

VSTS BUG: 5181922  | 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: 5181941 | 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: 5715080 | 3087114
FIX: PowerPivot for SharePoint doesn’t run automatic data refresh on the first day of each month
Analysis Services

VSTS BUG: 5715082 | 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: 5715087 | 3077273
FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014
SQL service

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

VSTS BUG: 5715112 | 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: 5715123 | 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: 5715131 | 3087872
FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715193  | 3097114
FIX: Queries take longer time to compile in SQL Server 2014 than in earlier versions
SQL performance

VSTS BUG: 4745298 | 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time
Analysis Services

VSTS BUG: 5489704 | 3099487
FIX: 100% CPU usage occurs when in-memory OLTP database is in recovery state in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5687518 | 3095958
FIX: Metadata inconsistency error occurs after you switch table partitions and drop corresponding files and filegroups
SQL service

VSTS BUG: 5808923 | 3099323
FIX: DBCC CHECKFILEGROUP reports false inconsistency errors on database that has partitioned table in SQL Server 2014
SQL service

VSTS BUG: 5667070 | 3096400
FIX: It takes longer to run the ALTER DATABASE SET HADR OFF command on a secondary replica in SQL Server 2014
High Availability

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

VSTS BUG: 5181961 | 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: 5181966 | 3073907
FIX: SSIS 2012 or SSIS 2014 package with an Execute SQL Task may stop responding
Analysis Services

VSTS BUG: 5715073 | 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: 5715100 | 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: 5715108 | 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: 5715110 | 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: 5522017 | 2682488
FIX: Backup operation fails in a SQL Server database after you enable change tracking
SQL service

VSTS BUG: 5536023 | 3090141
FIX: Offline checkpoint thread shuts down without providing detailed exception information in SQL Server 2014
In-Memory OLTP

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

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

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

VSTS BUG: 5523600 | 3082005
FIX: Case-sensitive does not work in MDS database in SQL Server 2014
MDS

VSTS BUG: 5715102 | 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: 5829179 | 3100361
FIX: DBCC CHECKDB doesn’t report metadata inconsistency of invalid filegroups in its summary in SQL Server 2014
SQL service

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

  • Microsoft SQL Server 2014 Service Pack 1

 

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 3

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|MS_SQL14_SP1_QFE_CU3_x64
    SQL Server 2014|SQL_AS_OLEDB_64
    SQL Server 2014|MS_SQL14_SP1_QFE_CU3_x86
    SQL Server 2014|SQL_AS_OLEDB_86

Enjoy!

[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 2014 SP1 Cumulative Update #1 is available!

LOGO__SQLServer2014downloadThe second package of June’s cumulative updates for SQL Server is also for SQL Server 2014. But this time for SQL Server 2014 with Service Pack 1. In this Cumulative Update No 1 {build 12.0.4416.0} Microsoft released over one hundred forty bugs (!). The Memory Remains. Similar stories happened with SQL Server 2012 and of course for SQL Server 2014 RTM {with over one hundered twenty bugs LINK}. In this case list of fixed bugs is really impressive:

VSTS BUG: 4584557 | 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: 4584559 | 3041859
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application
SQL connectivity

VSTS BUG: 4736925 | 3036330
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005
Management Tools

VSTS BUG: 4741675 | 3035077
FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking
Management Tools

VSTS BUG: 4736715 | 3008416
FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 4766925 | 3008135
FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
SQL service

VSTS BUG: 4736689 | 3000562
FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file
Reporting Services

VSTS BUG: 4584566 | 3053664
FIX: Improved memory management for columnstore indexes to deliver better query performance in SQL Server 2014
SQL service

VSTS BUG: 4767299 | 3053040
FIX: Hidden MDS data entries are deleted unexpectedly when you use the Master Data Services add-in for Microsoft Excel in SQL Server 2014
Master Data Services (MDS)

VSTS BUG: 4584497 | 3048752
FIX: A SELECT query that’s run as a parallel batch-mode scan triggers a deadlock in SQL Server 2014
SQL service

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

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

VSTS BUG: 4838259 | 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: 4834679 | 3071024
“Alter failed for Database” error occurs when you enable the “Change Tracking” option for the Azure SQL Database in SQL Server Management Studio 2014
Management Tools

VSTS BUG: 4584529 | 3045410
FIX: A query that uses the DECRYPTBYKEY function takes a long time in SQL Server 2014
SQL security

VSTS BUG: 4584511 | 3042683
FIX: Data Tools error occurs when you upgrade a DTS package in SQL Server 2014
Integration Services

VSTS BUG: 4584536 | 3042370
An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014
SQL service

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

VSTS BUG: 4767960 | 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: 4584564 | 3037624
FIX: Complex parallel query does not respond in SQL Server 2012 or SQL Server 2014
SQL performance

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

VSTS BUG: 4844571 | 3063438
FIX: XSLT transformation fails when you execute an SSIS 2014 package that contains multiple concurrent XML tasks
Integration Services

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

VSTS BUG: 4584539 | 3036601
FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 or 2014 MDS
MDS

VSTS BUG: 4736767 | 3036328
FIX: The value of statement_start_offset column is incorrect in DMV sys.dm_exec_requests in SQL Server 2014
SQL service

VSTS BUG: 4767646 | 3067828
FIX: Access violation occurs when you connect to an instance of SQL Server 2014
SQL service

VSTS BUG: 4767614 | 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: 4767950 | 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: 4584565 | 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source
Integration Services

VSTS BUG: 4602057 | 3061218
FIX: “Cannot read 8 bytes from file using caching” error when you execute an SSIS 2014 package
Integration Services

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

VSTS BUG: 4736765 | 3032068
FIX: No MDSTrace.log file is generated after you enable tracing in the MDS 2014 web.config file
MDS

VSTS BUG: 4736724 | 3032067
FIX: Access denied when a newly added user browses to an MDS website in SQL Server 2014
MDS

VSTS BUG: 4741563 | 3029825
FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 4736736 | 3029762
FIX: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 2014
SQL service

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

VSTS BUG: 4736916 | 3027847
FIX: Date conversion error when you use German SQL Server 2014 MDS in a German Windows operating system
MDS

VSTS BUG: 4798768 | 3068297
FIX: A severe error occurs in SQL Server 2014 during compilation of a query on a table with clustered columnstore index
SQL performance

VSTS BUG: 4067311 | 3027425
FIX: Metadata cannot be removed at publisher and synchronization time increases when you use merge replication
SQL service

VSTS BUG: 4736921 | 3024815
Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014
SQL performance

VSTS BUG: 4741501 | 3024790
FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version
Setup & Install

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

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

VSTS BUG: 4745313 | 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: 4584522 | 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: 4744179 | 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012
SQL service

VSTS BUG: 4736554 | 2994082
FIX: Error when you edit models for some groups or users in MDS for SQL Server 2012 or SQL Server 2014
MDS

VSTS BUG: 4737087 | 2995622
FIX: “Specified cast is not valid” when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 4584501 | 3020750
FIX: Error or blank page when you click the workbook link under “Data Refresh – Recent Activity”
Analysis Services

VSTS BUG: 4584502 | 3023620
FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013
Analysis Services

VSTS BUG: 4736769 | 3025845
FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014
SQL service

VSTS BUG: 4736968 | 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: 4584506 | 3027232
FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server PowerPivot for SharePoint 2013
Analysis Services

VSTS BUG: 4736749 | 3030041
FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014
Setup & Install

VSTS BUG: 4736878 | 3030325
FIX: The scheduled refresh only occurs every other day instead of every day in SQL Server 2014 PowerPivot data refresh
Analysis Services

VSTS BUG: 4736752 | 3030326
FIX: Entries are no longer recorded on history page when you customize data refresh in PowerPivot for SharePoint 2013
Analysis Services

VSTS BUG: 4736730 | 3030619
FIX: Incorrect data returned when you query the DATE column in SQL Server 2014
SQL service

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

VSTS BUG: 4741593 | 3034615
FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014
SQL service

VSTS BUG: 4741641 | 3035071
FIX: Error when you run a query that contains “Use database_name” or “Execute Stored_Procedure_name” command
Management Tools

VSTS BUG: 4736953 | 3035165
FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014
SQL service

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

VSTS BUG: 4584521 | 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: 4584515 | 3041967
FIX: “Unable to retrieve data for this section of the report” error when you request the Service Broker Statistics report in SQL Server 2014
Management Tools

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

VSTS BUG: 4584560 | 3048856
FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014
SQL service

VSTS BUG: 4584538 | 3051663
FIX: “8156: A database error has occurred” when you run a business rule in SQL Server 2014 Master Data Services
MDS

VSTS BUG: 4584526 | 3052244
FIX: Incorrect result when the “must be unique” action is evaluated for an attribute by using SQL Server 2014 Master Data Services
MDS

VSTS BUG: 4741603 | 3020402
FIX: SQL Server 2014 Object Explorer does not display the SQL Azure objects correctly
Management Tools

VSTS BUG: 4736940 | 3029504
FIX: “Error converting data type nvarchar to datetime” error occurs when you use business rule in SQL Server 2014 MDS
MDS

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

VSTS BUG: 4584537 | 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: 4736612 | 2995211
FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 or 2014 report
Reporting Services

VSTS BUG: 4736599 | 2997020
FIX: “An item with the same key has already been added” error when you review a report in SSRS 2012 or 2014
Reporting Services

VSTS BUG: 4736605 | 3000494
The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
Reporting Services

VSTS BUG: 4736711 | 3010773
FIX: Power View report plots values incorrectly for line chart in SSRS in SharePoint integrated mode
Reporting Services

VSTS BUG: 4737085 | 3019110
FIX: “Duplicate names are not allowed” error when you add multiple filters to the Power View report in SharePoint 2013
Reporting Services

VSTS BUG: 4741513 | 3028226
FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012 or SSRS 2014
Reporting Services

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

VSTS BUG: 4584520 | 3042544
FIX: Incorrect choice of a nested loops join strategy causes poor query performance in SQL Server 2014
SQL performance

VSTS BUG: 4767726 | 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: 4584498 | 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS data mining models
Analysis Services

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

VSTS BUG: 4584500 | 3025968
FIX: SSRS pages contain unlabeled check boxes in the detailed view
Reporting Services

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

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

VSTS BUG: 4584512 | 3044160
FIX: Performance counters under “ReportServer:Service” object show zero in SSRS 2014
Reporting Services

VSTS BUG: 4737096 | 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 4736597 | 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 or SQL Server 2014
MDS

VSTS BUG: 4745325 | 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: 4745310 | 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server
SQL security

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

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

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

VSTS BUG: 4767492 | 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: 4767707 | 3058512
FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014
Integration Services

VSTS BUG: 4736611 | 3013551
FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
SQL service

VSTS BUG: 4584551 | 3038332
FIX: Data Alerts tables are filled up and never clear old data when you use alerts for SSRS 2012 or SSRS 2014 reports
Reporting Services

VSTS BUG: 4584556 | 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012 or SQL Server 2014
Reporting Services

VSTS BUG: 4745308 | 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: 4745710 | 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: 4745294 | 3029096
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly
Integration Services

VSTS BUG: 4767558 | 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
MDS

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

VSTS BUG: 4745306 | 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: 4744174 | 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: 4584549 | 3034492
FIX: “Call to Excel Services returned an error” error when you refresh the document in the PowerPivot Gallery
Analysis Services

VSTS BUG: 4736696 | 3001713
FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 4736702 | 3003102
FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012 or SSRS 2014
Reporting Services

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

 

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 1

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_SP1_CU1_3067839_12_0_4416_x64
    SQL2014_SP1_ODBC_CU1_3067839_12_0_4416_x64
    2014_SP1_AOrcleDes_CU1_3067839_12_0_4416_x64
    2014_SP1_AOrcleSer_CU1_3067839_12_0_4416_x64
    2014_SP1_AOrcleSer_CU1_3067839_12_0_4416_x86
    2014_SP1_AOrcleDes_CU1_3067839_12_0_4416_x86
    SQL2014_SP1_ODBC_CU1_3067839_12_0_4416_x86
    QLServer2014_SP1_CU1_3067839_12_0_4416_x86

     

Enjoy!