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

LOGO__SQLServer2012SP1Second package with January SQL Server updates are for SQL Server 2012 Service Pack 1. In this Cumulative Update No 14 {build no 11.0.3486.0} SQL Server Product Team resolved just eight bugs and problems. Here is the list of bugs, and three of them are oriented for CPU usage.

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

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

VSTS bug: 3857931 | KB: 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012
Data Quality Services (DQS)

VSTS bug: 3833361 | KB: 3023634
FIX: “Error converting data type nvarchar to numeric” error when you use a business rule in SQL Server 2012 MDS
SQL service

VSTS bug: 3557769 | KB: 3026082
FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012
SQL service

VSTS bug: 3557777 | KB: 3026083
FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012
SQL service

VSTS bug: 3916889 | KB: 3027860
FIX: Error 17066 or 17310 during SQL Server startup
SQL service

VSTS bug: 3972408 | KB: 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012
Reporting Services

 

This update could be applied to applies to

  • Microsoft SQL Server 2012 Service Pack 1
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • 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: step 1 Install the service pack on the passive node, step 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:

    • 2012_SP1_PPExcel_CU14_3023636_11_0_3486_x86 {102 MB}
    • SQLServer2012_SP1_CU14_3023636_11_0_3486_x86 {509 MB}
    • 2012_SP1_RSShrPnt_CU14_3023636_11_0_3486_x64 {44 MB}
    • 2012_SP1_PPExcel_CU14_3023636_11_0_3486_x64 {135 MB}
    • SQLServer2012_SP1_CU14_3023636_11_0_3486_x64 {818 MB}

     

    Enjoy!

    [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!

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

    LOGO__SQLServer2012At the outtage of Azure time Microsoft released two packs wit Cumulative Updates. Both for Microsoft SQL Server 2012 but for different versions. In this post I’ll write about update for SQL Server 2012 with Service Pack 1. In this Cumulative Update No 13 /and still counting?/ {build no 11.0.3482.0} Microsoft fixed about ten bugs and here is the list.

    VSTS BUG: 2369445 | KB: 2793580
    FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server
    Management Tools

    VSTS BUG: 3074321 | KB: 2840657
    FIX: Performance decreases when you stage many records in MDS for SQL Server 2012
    SQL service

    VSTS BUG: 3029598 | KB: 2994082
    FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS
    Data Quality Services (DQS)

    VSTS BUG: 3053494 | KB: 2995352
    FIX: "No catalog entry found for partition ID <ID> in database <Database Name>" error when you use SQL Server 2012
    SQL service

    VSTS BUG: 3127645 | KB: 2997020
    FIX: "An item with the same key has already been added" error when you review a report in SSRS 2012
    Reporting Services

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

    VSTS BUG: 3242852 | KB: 3000494
    FIX: 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: 3153124 | KB: 3005300
    FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012
    SQL service

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

    VSTS BUG: 3443831 | KB: 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

     

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

    • Microsoft SQL Server 2012 Enterprise
    • Microsoft SQL Server 2012 Developer
    • Microsoft SQL Server 2012 Express
    • Microsoft SQL Server 2012 Standard
    • Microsoft SQL Server 2012 Web
    • SQL Server 2012 Reporting Services
    • Microsoft SQL Server 2012 Analysis Services
    • Microsoft SQL Server 2012 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 13

    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:

    >>2012_SP1_DAC_CU13_3002044_11_0_3482_x64
    >>2012_SP1_RSShrPnt_CU13_3002044_11_0_3482_x64
    >>SQLServer2012_SP1_CU13_3002044_11_0_3482_x64
    >>2012_SP1_PPExcel_CU13_3002044_11_0_3482_x64
    >>2012_SP1_PPExcel_CU13_3002044_11_0_3482_x86
    >>2012_SP1_DAC_CU13_3002044_11_0_3482_x86
    >>SQLServer2012_SP1_CU13_3002044_11_0_3482_x86

    Enjoy!