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

LOGO__SQLServer2014downloadFew days ago Microsoft released newest package of updates for SQL Server 2014. In this Cumulative Update No 3 (buil number 12.0.2402.0) Microsoft resolved about thirty bugs. Here is the list:

 

VSTS BUG:  2556594 | 2936984
FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server
SQL service

VSTS BUG: 2714497 | 2952444
FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 2578278 | 2954861
FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT
Integration Services

VSTS BUG: 2578282 | 2957768
FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 2578276 | 2957957
FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server MDS Add-in for Excel
Data Quality Services (DQS)

VSTS BUG: 2578288 | 2959342
FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server
Reporting Services

VSTS BUG: 2319134 | 2960924
FIX: Cannot open the memory-optimized table template remotely in SQL Server 2014
Management Tools

VSTS BUG: 2578302 | 2961559
FIX: Incorrect folder when deploying SQL Server 2012 or SQL Server 2014 PowerPivot solutions by using SharePoint 2013 Central Admin
Analysis Services

VSTS BUG: 2578304 | 2963372
FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2823096 | 2963386
FIX: SSRS 2012 or SSRS 2014 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB
Reporting Services

VSTS BUG: 2782748 | 2963668
FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions
SQL service

VSTS BUG: 2578285 | 2963836
FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 2525292 | 2967635
FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS or SQL Server 2014 MDS
DQS

VSTS BUG: 2504388 | 2968418
FIX: "Non-yielding scheduler" error when you insert or update many rows in one transaction in SQL Server 2014
In-Memory OLTP

VSTS BUG: 2906109 | 2968909
FIX:Access violation when you query sys.extended_properties table in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2906113 | 2973561
FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2906095 | 2975322
FIX: Blank value is set to NULL value in a business rule in MDS of SQL Server 2012 or SQL Server 2014
DQS

VSTS BUG: 2906139 | 2975402
FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server
SQL service

VSTS BUG: 2515653 | 2975434
FIX: Error when you complete an SSAS 2014 image after specifying a non-default root directory
Analysis Services

VSTS BUG: 2782757 | 2977312
FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server
SQL service

VSTS BUG: 2906893 | 2978472
FIX: UPDATE or INSERT statement on CCI makes sys.partitions not match actual row count in SQL Server 2014
SQL service

VSTS BUG: 2906137 | 2979121
FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2906141 | 2979587
FIX: Image completion setup fails when you use SysPrep to install localized version of SQL Server
Setup & Install

VSTS BUG: 2789872 | 2981764
FIX: Cannot create indexed view on a clustered columnstore index and BCP on the table fails in SQL Server 2014
SQL service

VSTS BUG: 2796999 | 2984628
FIX: Auto-statistics creation increases the compilation time for natively compiled stored procedure in SQL Server 2014
In-Memory OLTP

VSTS BUG: 2797130 | 2984629
FIX: LCK_M_SCH_M occurs when you access memory-optimized table variables outside natively compiled stored procedures
In-Memory OLTP

VSTS BUG: 2531271 | 2984907
FIX: "The current SQL Server edition is not supported by MDS" error when you browse to the MDS website
DQS

VSTS BUG: 2704551 | 2986081
FIX: An access violation occurs when you use UPDATE STATISTICS on a computed column in SQL Server 2014
SQL performance

VSTS BUG: 2828009 | 2988552
FIX: Update enables SQLDOM to support "service_objective" in the Microsoft Azure SQL Database
SQL service

VSTS BUG: 2718825 | 2989704
FIX: Some columns in sys.column_store_segments view show NULL value when the table has non-dbo schema in SQL Server 2014
SQL service

VSTS BUG: 2895169 | 2989715
FIX: Dimension attribute is lost in Excel PivotTable Field List when you set AttributeHierarchyDisplayFolder to "\" in SSDT-BI
Analysis Services

 

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

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

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 both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages (size for x64bit platform is around 609 MB):

>> SQLServer2014_RTM_CU3_2984923_12_0_2402_x64
>> SQLServer2014_RTM_CU3_2984923_12_0_2402_x86

Enjoy!

[EN] Visual Studio 2013 Update 3RC/RTM is available.

Captura_VS2013up3_02Even I’m not a developer (and probably never will be) but some dev tools are interesting – and sometimes necessary – even for me. Visual Studio is one of them especially for SharePoint and Azure areas. RC (Release Candidate) version of this update has been annouced on July 2nd. One month later – two days ago – RTM (Release To Manufacture) solid version has been published. Of course is not a small update (like some of Cumulative Updates for SQL Server), so let’s lok a little bit closer for this update.

On knowledge base site in description article (KB2933779) You can find more detailed information. Here in my post I just put the points of changes:

Technology improvements

  • CodeLens
  • Debugger
  • Team Foundation Server
  • General
  • HTML and JavaScript development
  • IntelliTrace
  • Notification hubs
  • Azure Mobile Service projects
  • Profiler
  • Release Management
  • Testing Tools
  • Visual Studio IDE
  • Visual C++
  • Web platform and Tools
  • Windows Store and Windows Phone

Fixed issues

  • Debugger
  • General
  • HTML, JavaScript, and TypeScript development
  • Profiler
  • Team Foundation Server
  • Visual C++
  • Visual Studio IDE
  • Web Platform and Tools

Known issues

  • HTML and JavaScript development
  • Profiler
  • Visual C++
  • Visual Studio IDE
  • Web Platform and Tools
  • Windows Store and Windows Phone
  • Release Management
  • Python Tools for Visual Studio
  • SharePoint Apps

Depends if you have Visual Studio 2013 or not You can download different packages for this environment:

Visual Studio 2013 updates are cumulative releases. The following download links always point you to the latest update:

If you do not have Visual Studio 2013 (original release version) and run one of these downloads, both Visual Studio 2013 and Update 3 are installed.

 

Visual Studio 2013 Update 3 – Multi-language DVD5 ISO image which is available under link is about 4GB size – but you will need 10 GB free space for this installation. And this update could be applied to:

  • Microsoft Visual Studio Ultimate 2013
  • Microsoft Visual Studio Professional 2013
  • Microsoft Visual Studio Premium 2013
  • Microsoft Visual Studio Express 2013 for Web
  • Microsoft Visual Studio Express 2013 for Windows
  • Microsoft Visual Studio Express 2013 for Windows Desktop

Enjoy!

 

Post Scriptum:

And here is the full list how Visual Studio 2013 Update 3 affected my system:

Captura_VS2013up3_03

Captura_VS2013up3_04

Captura_VS2013up3_05

Captura_VS2013up3_06

Captura_VS2013up3_07

Captura_VS2013up3_08

Captura_VS2013up3_09

[EN] SQL Server 2012 SP2 1st Cumulative Update is available!

LOGO__SQLServer2012SP2The second update package is also for SQL Server 2012 but this time for SQL Server 2012 with newest Service Pack 2. This Cumulative Update 1 (buil number 11.0.5532.0) contains all hotfixes in the initial release of SQL Server 2012 SP2 as well as all hotfixes in SQL Server 2012 SP1 CU#10. About forty five bugs has been fixed in this update. Here is the list:

 

VSTS BUG: 2578289 | 2881285
FIX: You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014
Integration Services

VSTS BUG: 2525262 | 2928300
FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server
SQL performance

VSTS BUG: 2525267 | 2932559
FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2594745 | 2933103
FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server
SQL performance

VSTS BUG: 2594747 | 2936154
FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server
Management Tools

VSTS BUG: 2556592 | 2936984
FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server
SQL service

VSTS BUG: 2525271 | 2938192
FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 2525280 | 2950209
FIX: Access violation when the start offset is larger than the string length in Substring function in SQL Server
SQL service

VSTS BUG: 2525283 | 2952101
FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server
SQL performance

VSTS BUG: 2594735 | 2953354
FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server
SQL service

VSTS BUG: 2578277 | 2954861
FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT 2012
Integration Services

VSTS BUG: 2578296 | 2956619
FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system
Integration Services

VSTS BUG: 2100367 | 2950189
FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server
SQL service

VSTS BUG: 2578281 | 2957768
FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012
Reporting Services

VSTS BUG: 2578275 | 2957957
FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server 2012 MDS Add-in for Excel
Data Quality Services (DQS)

VSTS BUG: 2525287 | 2958012
FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012
SQL service

VSTS BUG: 2525285 | 2958062
FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2578287 | 2959342
FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012
Reporting Services

VSTS BUG: 2525278 | 2960237
FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server
DQS

VSTS BUG: 2578299 | 2960310
FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server
SQL service

VSTS BUG: 2525300 | 2960735
FIX: Windows Update for SQL Server 2012 or SQL Server 2014 image does not work in Microsoft Azure Virtual Machine gallery
Setup & Install

VSTS BUG: 2525293 | 2960989
FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 package
DQS

VSTS BUG: 2525289 | 2961254
FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2
Analysis Services

VSTS BUG: 2525296 | 2961525
FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms application
Reporting Services

VSTS BUG: 2578301 | 2961559
FIX: Incorrect folder when deploying SQL Server 2012 PowerPivot solutions by using SharePoint 2013 Central Admin
Analysis Services

VSTS BUG: 2525298 | 2962650
FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2578273 | 2963138
FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012
SQL service

VSTS BUG: 2578303 | 2963372
FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012
Analysis Services

VSTS BUG: 2594749 | 2963373
FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012
Analysis Services

VSTS BUG: 2578279 | 2963377
FIX: Exception and access violation occurs when you run an MDX calculation in SSAS 2012
Analysis Services

VSTS BUG: 2578284 | 2963836
FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012
Reporting Services

VSTS BUG: 2512105 | 2965035
FIX: SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2
Analysis Services

VSTS BUG: 2525264 | 2967634
FIX: SSIS 2012 or SSIS 2014 XML validator only outputs "TRUE" or "FALSE" when you perform XML validation
Integration Services

VSTS BUG: 2525291 | 2967635
FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS
DQS

VSTS BUG: 2516114 | 2969023
FIX: The objects or tasks move to corner when you move or resize them in an SSIS 2012 package
Integration Services

VSTS BUG: 2701948 | 2969896
FIX: Data corruption occurs in clustered index when you run online index rebuild in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 2775472 | 2974948
FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012
Management Tools

VSTS BUG: 2665730 | 2975402
FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server 2012
SQL service

VSTS BUG: 2682780 | 2976172
FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSAS 2012
Analysis Services

VSTS BUG: 2676516 | 2976861
FIX: The time is longer and longer to perform process full on an SSAS 2012 tabular model database
Analysis Services

VSTS BUG: 2436389 | 2979587
FIX: Image completion setup fails when you use SysPrep to install localized version of SQL Server 2012
Setup & Install

VSTS BUG: 2739737 | 2980208
FIX: Permissions cannot be propagated to Subscriber in transaction replication when the Distributor is SQL Server 2012
SQL service

VSTS BUG: 2792700| 2982019
FIX: Error when you restart the Merge Agent after you upgrade the Publisher to SQL Server 2012 SP2
SQL service

VSTS BUG: 2817693 | 2982843
FIX: Longer latency for SQL Server 2012 database when you use Service Broker, database mirroring, and AlawysOn
High Availability

 

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

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • 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 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 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_CU1_2976982_11_0_5532_x64
>> SQLServer2012_SP2_CU1_2976982_11_0_5532_x86

Enjoy!