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

LOGO__SQLServer2012SP2First package for updates which have been released in March is for SQL Server 2012 with Service Pack 2. In this Cumulative Updates No 5 {build no 11.0.5582.0} Microsoft resolved almost thirty bugs. Some fixed errors has been published in Cumulative Update No 6 for SQL Server 2014 {post here} like SOS_CACHESTORE or PowerPivot bugs. Here is the full list of fixed bugs.

 

VSTS BUG:  4034265 | KB: 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission
Reporting Services

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

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

VSTS BUG:  4067256 | KB: 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS 2012 data mining models
Analysis Services

VSTS BUG:  4067259 | KB: 3026082
FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014
SQL service

VSTS BUG:  4067262 | KB: 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:  4067274 | KB: 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG:  3995494 | KB: 3029776
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension
Analysis Services

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

VSTS BUG:  4058285 | KB: 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source
Integration Services

VSTS BUG:  4077857 | KB: 3034492
FIX: “Call to Excel Services returned an error” error when you refresh the document in the PowerPivot Gallery
Analysis Services

VSTS BUG:  4124969 | KB: 3034679
FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING
High Availability

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

VSTS BUG:  4019503 | KB: 3037624
FIX: Complex parallel query does not respond in SQL Server 2012
SQL performance

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

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

VSTS BUG:  4111094 | KB: 3038332
FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports
Reporting Services

VSTS BUG:  4136827 | KB: 3038943
FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups
High Availability

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

VSTS BUG:  4166567 | KB: 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012
Reporting Services

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

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

VSTS BUG:  4203721 | KB: 3042007
FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle
SQL service

VSTS BUG:  4142191 | KB: 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012
Analysis Services

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

VSTS BUG:  4049132 | KB: 3044958
FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails
SQL service

 

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

     – Microsoft SQL Server 2012 Enterprise

     – Microsoft SQL Server 2012 Developer

     – Microsoft SQL Server 2012 Express

     – Microsoft SQL Server 2012 Standard

     – Microsoft SQL Server 2012 Web

     – Microsoft SQL Server 2012 Analysis Services

     – Microsoft SQL Server 2012 Business Intelligence

     – Microsoft SQL Server 2012 for Embedded Systems

     – Microsoft SQL Server 2012 Parallel Data Warehouse

     – SQL Server 2012 Reporting Services

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 5

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_CU5_3037255_11_0_5582_x86

    SQLServer2012_SP2_CU5_3037255_11_0_5582_x64

Enjoy!

[EN] Improvements of SSMS for Azure Database after CU5 – part one

LOGO__SQL-Azure_rgbApplying latest Cumilative Update {build no 12.0.2456.0} for SQL Server 2014 improving your SQL Server Management Studio functionality. In few next posts I will write about some functionality which are interesting for me, and could be interesting for you.

First of few options which are very interesting for me (in the case of some demo on my sessions at conferences) are tasks SELECT and EDIT. Two fix has been delivered for two not bugs, but missing functionality:

VSTS BUG: 3548910 | KB: 3014156 | LINK: http://bit.ly/13MTeU3 
FIX: An update is available that enables "Edit Top 200 Rows" option for tables and views of SQL Azure database
VSTS BUG: 3548922 | KB: 3014166 | LINK: http://bit.ly/1Db8tCG 
FIX: An update is available that enables "Select Top 1000 Rows" option for tables and views of SQL Azure database

Let’s look how it works. Before installing update I got two databases of SQL Server: one is Adventure Works 2012 on Premise, and one is Adventure Works 2012 in Windows Azure. Using SQL Server Management Studio I trying to check my instances (in all cases I will use same table Person.Address):

Screenshot 2014-12-28 10.50.46

Pict. 01 – With AdventureWorks located in on Premise instance tasks: “Select Top 1000 Rows” and “Edit Top 200 Rows” are available by default.

Screenshot 2014-12-28 10.51.24

Pict. 02 – With AdventureWorks located on Windows Azure Server (as cloud database) bots options are not available.

Problem with missing functionality has been solved after installing Cumulative Update 5.

Screenshot 2014-12-28 19.13.49

Pict. 03 – With With AdventureWorks located on Windows Azure Server both tasks: “Select Top 1000 Rows” and “Edit Top 200 Rows” are available.

 

Second of few really great functionality is focused on deployment database for Windows Azure.

VSTS BUG: 3548883 | KB: 3014164 | http://bit.ly/1xeIWbo
FIX: Cannot use new service tiers Basic, Standard and Premium when you deploy to Windows Azure SQL Database in SSMS 2014

Again let’s look how it works. For this case I use three instances: one with SQL Server 2012 (engine version 11.xx) one with SQL Server 2014 (engine version 12.xx) and one Windows Azure instance. And I use two newly created databases:

  • TestDeploy11 located on SQL Server 2012 instance, compability mode with SQL Server 2012 (110), collation: Chinese_Traditional_Pinyin_100_CI_AS
  • TestDeploy12 located on SQL Server 2014 instance, compability mode with SQL Server 2014 (120), collation: Latin1_General_100_CI_AS

Part one (before updating) >> deploying new database from SQL Server Management Studio 2012 to Windows Azure.

Screenshot 2014-12-31 17.21.35

Pict. 04 – steps: Right Click>Task>Deploy Database to SQL Azure {I starting from SHINGEN instance which is SQL Server 2014 instance}

Screenshot 2014-12-31 17.21.52

Pict. 05 – Welcome screen (we can switch off this screen)

Screenshot 2014-12-31 17.22.07

Pict. 06 – After connecting to Windows Azure SQL Server (where I keep my azure databases) we can choose Web version with size 1 and 5 GB

Screenshot 2014-12-31 17.22.18

Pict. 07 – Or Business Edition with size: 10, 20, 30, 40, 50, 100, 150 GB

Screenshot 2014-12-31 17.22.33

Pict. 08 – On next screen we see short summary of planned deploy

Screenshot 2014-12-31 17.22.49

Pict. 09 – And here we have expected error about Operation Failed. Expected because I tried deploy databese with compability factor 120, even I use SSMS for SQL Server 2012. So, we cannot deploy SQL Server 2014 database from Management Studio 2012 to Windows Azure.

Screenshot 2014-12-31 17.23.03

Pict. 10 – Still on the same Management Studio now I tried to deploy SQL Server 2012 database to Windows Azure {I now working with MIFUNE instance which is SQL Server 2012 instance}

Screenshot 2014-12-31 17.23.21

Pict. 11 – I can choose from the same options for Web Edition and 1 & 5 GB size

Screenshot 2014-12-31 17.23.32

Pict. 12 – And of course Business Edition and 10, 20, 30, 40, 50, 100, 150 GB size

Screenshot 2014-12-31 17.23.43

Pict. 13 – You can see small difference with picture number eight, different name of database

Screenshot 2014-12-31 17.23.56

Pict. 14 – And after clicking on NEXT button deploying started

Screenshot 2014-12-31 17.24.50

Pict. 15 – And finally I have status Operation Completed and my new database is now deployed to Windows Azure.

 

Part Two (after updating) >> deploying new database from SQL Server Management Studio 2014 to Windows Azure.

Screenshot 2014-12-31 17.41.55

Pict. 16 – steps: Right Click>Task>Deploy Database to SQL Azure {I starting from MIFUNE instance which is SQL Server 2012 instance}

Screenshot 2014-12-31 17.42.28

Pict. 17 – I can choose from the same options for Web Edition and 1 & 5 GB size, but here editions are upgraded and Web Edition has status Retired

Screenshot 2014-12-31 17.42.39

Pict. 18 – And of course Business Edition and 10, 20, 30, 40, 50, 100, 150 GB size, and same as above Business Edition has status Retired

Screenshot 2014-12-31 17.43.11

Pict. 19 – And after clicking on NEXT button deploying started (with small change to avoid error: Target Database: TestDeploy11v2)

Screenshot 2014-12-31 17.45.04

Pict. 20 – And finally I have status Operation Completed  and my new database is now deployed to Windows Azure. Now I have two newly deployed databases on my Windows Azure server

Screenshot 2014-12-31 17.48.04

Pict. 21 – Same steps like on pisture number sixteen, and if you have ‘Eagle Eye’ you see that here and on picture sixteen we deploying for Windows Azure SQL Database instead of SQL Azure Database (which happened on SQL Server Management Studio 2012) {I now working with SHINGEN instance which is SQL Server 2014 instance}

Screenshot 2014-12-31 17.48.15

Pict. 22 – Almost the same welcome screen (we can switch off this screen)

Screenshot 2014-12-31 17.48.36

Pict. 23 – Now pure changes starting. First option: Basic Edition with size 1 & 2 GB, with Default Service Objective (Service Tier & Performance Level)

Screenshot 2014-12-31 17.48.55

Pict. 24 – Second option: Standard Edition with 1, 2, 5, 10, 20, 30, 40, 50, 100, 150, 200, 250 GB size

Screenshot 2014-12-31 17.49.01

Pict. 25 – Still second option but with three Service Objective levels: S0, S1, S2

Screenshot 2014-12-31 17.49.10

Pict. 26 – Third option: Premium Edition with 1, 2, 5, 10, 20, 30, 40, 50, 100, 150, 200, 250, 300, 400, 500 GB size

Screenshot 2014-12-31 17.49.15

Pict. 27 – and of course still third option but with three Service Objective levels: P1, P2, P3

Screenshot 2014-12-31 17.49.32

Pict. 28 – Summary with specification same like before

Screenshot 2014-12-31 17.51.34

Pict. 29 – And final result status Operation Completed and my new database is now deployed to Windows Azure. Now I have three newly deployed databases on my Windows Azure server.

 

Part Three >> finally three new deployed databases, I tried to deploy four databases but one was failed because of non-compability expected error.

Screenshot 2014-12-31 17.51.52

Pict. 30 – All three deployed databases are now on my Windows Azure server

image image image

Pict. 31 – Interesting point is at the end, because all my freshly deployed databases have compability level 100 (instead of 110 and 120 as  original “on premise” databases). But this is not subject of this post.

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

LOGO__SQLServer2014Just before holiday period (as someone called x-mass) Microsoft released new updates packages for newest SQL Server 2014. In this Cumulative Update No 5 {build no 12.0.2456.0} SQL Server Product Team resolved over fifty bugs and problems. Here is the list of bugs, which some of them are very interesting. In this update very interesting for me are funcionalities which have been added for Azure collaboration (such as ‘Edit Top 200 Rows’ and ‘Select Top 1000 Rows’) and support for ReST file system for local disk.

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

VSTS BUG: 3720664 | KB: 2981424
FIX: Exception when you select more than one hierarchy from parent/child dimension in SSAS 2012 or in SSAS 2014
Analysis Services

VSTS BUG: 3260592 | KB: 2986423
FIX: It takes a long time to add new columns to a table when the row size exceeds the maximum allowed size
SQL service

VSTS BUG: 3260606 | KB: 2992069
FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 or SSAS 2014 processing
Analysis Services

VSTS BUG: 3720670 | KB: 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: 3720671 | KB: 2996729
FIX: "Non-yielding Scheduler" condition occurs when you run a complex query in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 3720672 | KB: 2997392
FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012 or 2014
SQL service

VSTS BUG: 3720635 | KB: 2998870
FIX: "The record ID is incorrect" error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 3720680 | KB: 3002071
FIX: "System objects not be updated" when you use AlwaysOn Availability Groups in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 3720682 | KB: 3002883
FIX: Error occurs when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3720683 | KB: 3004355
FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3427718 | KB: 3004548
FIX: Add Azure Replica wizard cannot enumerate Azure Virtual Network in SQL Server 2014
High Availability

VSTS BUG: 3720647 | KB: 3005300
FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3720685 | KB: 3006648
FIX: Data corruption in a target table when you use a SQL Server destination in SSIS 2012 or SSIS 2014
SQL service

VSTS BUG: 3560727 | KB: 3007050
FIX: RTDATA_LIST waits when you run natively stored procedures that encounter expected failures in SQL Server 2014
In-Memory OLTP

VSTS BUG: 3720649 | KB: 3008000
FIX: Error when you use Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012 or SSMS 2014
Integration Services

VSTS BUG: 3720695 | KB: 3009576
FIX: Cannot restore database by using the full backup and differential backup files that contain defunct files
SQL service

VSTS BUG: 3720696 | KB: 3009883
FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012 or 2014
SQL performance

VSTS BUG: 3720681 | KB: 3011807
FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012 or in SQL Server 2014
SQL service

VSTS BUG: 3343225 | KB: 3012182
FIX: Log_Send_Rate column cannot reflect the rate accurately in SQL Server 2012 or in SQL Server 2014
SQL service

VSTS BUG: 3720668 | KB: 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
SQL service

VSTS BUG: 3556632 | KB: 3013861
FIX: Upgrade wizard appears again when you reopen the SSIS 2014 solution with upgraded SSIS packages
Integration Services

VSTS BUG: 3548910 | KB: 3014156
FIX: An update is available that enables "Edit Top 200 Rows" option for tables and views of SQL Azure database
SQL service

VSTS BUG: 3548883 | KB: 3014164
FIX: Cannot use new service tiers Basic, Standard and Premium when you deploy to Windows Azure SQL Database in SSMS 2014
SQL service

VSTS BUG: 3548922 | KB: 3014166
FIX: An update is available that enables "Select Top 1000 Rows" option for tables and views of SQL Azure database
SQL service

VSTS BUG: 3557908 | KB: 3014193
FIX: The view indexes are not visible in the Object Explorer in SSMS 2014
Management Tools

VSTS BUG: 3565098 | KB: 3014359
FIX: Out-of-range error occurs when you use SQL Server Managed Backup to Windows Azure
SQL service

VSTS BUG: 3424685 | KB: 3014825
FIX: "No exceptions should be raised by this code" error when you run parallel query in SQL Server 2014
SQL performance

VSTS BUG: 3709035 | KB: 3014867
FIX: "Remote hardening failure" exception cannot be caught and a potential data loss when you use SQL Server 2014
High Availability

VSTS BUG: 3446846 | KB: 3016334
FIX: Error when you upgrade a SQL Server 2012 SP2 instance with MDS to SQL Server 2014
DQS

VSTS BUG: 3428568 | KB: 3016518
FIX: "You do not have permission…" error when you run a report that connects to a .BISM file in PowerPivot gallery
Analysis Services

VSTS BUG: 3306406 | KB: 3017266
FIX: "Requested value ReFS was not found" error when you install SQL Server 2014 on a local drive that is ReFS formatted
Setup & Install

VSTS BUG: 3527886 | KB: 3020112
FIX: Non-yielding error occurs when you execute DML statements in SQL Server 2014
SQL service

VSTS BUG: 3551049 | KB: 3020113
FIX: Error 35377 occurs when you try to access clustered columnstore indexes in SQL Server 2014
SQL service

VSTS BUG: 3654616 | KB: 3020116
FIX: "Non-yielding scheduler" error and AlwaysOn Availability Group transitions to RESOLVING state not Failover
High Availability

VSTS BUG: 3548637
Federations feature will be discontinued with Web and Business service tiers. The Federations related Transact-SQL code examples in SSMS are updated with comments on being discontinued.
SQL service

VSTS BUG: 3548892
The Property Page shortcut menu item for databases (right-click on a database node and select Properties) on Azure databases is enabled.
SQL service

VSTS BUG: 3548904
Table Designer is now be used when creating tables on the latest version of Azure SQL Database.
SQL service

VSTS BUG: 3548910
The Edit Top N rows shortcut menu option is enabled (right-click on Table and selectEdit Top N Rows) for opening the Visual Database Tools with N rows populated.
SQL service

VSTS BUG: 3548922
The Select Top N rows shortcut menu option (right-click a table or a view and selectSelect Top N Rows) is enabled for generating a script that will select the top N rows from a table or a view.
SQL service

VSTS BUG: 3548929
The Property shortcut menu option for tables (right-click Table node and selectProperties) on Azure databases is enabled.
SQL service

VSTS BUG: 3708148
The following nodes to Object Explorer for features are added in the latest version of Azure SQL Database:

  • Storage (under Database node)
  • Assemblies (Database node -> Programmability)
  • Rules (Database node -> Programmability)
  • Defaults (Database node -> Programmability)
  • Plan Guides (Database node -> Programmability)
  • Sequences (Database node -> Programmability)
  • Aggregate Functions (Database node -> Functions)
  • Application Roles (Database node -> Security -> Roles)
  • User-defined Object Types (CLR Types) (Database node -> Programmability -> Types)
  • XML Schema Collections (Database node -> Programmability -> Types)

SQL service

VSTS BUG: 3708389
The Column and Index subfolders under the Table and View nodes are added.
SQL service

VSTS BUG: 3708718
The Modify and Execute Stored Procedure shortcut menu options (right-click a stored procedure) when it is connected to the latest version of Azure SQL Database are enabled.
SQL service

VSTS BUG: 3708719
The Modify shortcut menu option for Functions (right-click a function) when connected to the latest version of Azure SQL Database is enabled.
SQL service

VSTS BUG: 3750221
Both the Federation and Management nodes from Object Explorer when connected to the latest version of Azure SQL Database are removed. When they are connected to an Azure v. Current server only the management node is removed (Federations are still valid on Azure v.Current).
SQL service

VSTS BUG: 3782631
The Memory Optimization Advisor shortcut menu option for tables on all Azure databases is removed.
SQL service

 

This update could be applied to applies to

  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Express
  • 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 5

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:

  1. Install the service pack on the passive node.
  2. 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_CU5_3011055_12_0_2456_x64 (623 MB)
  • SQLServer2014_RTM_CU5_3011055_12_0_2456_x86 (376 MB)

Enjoy!