[EN] SQL Server 2008 R2 SP2 Cumulative Update 11 is available

LOGO__SQLServer2008R2SP2Just only one updates package for SQL Server has been released in February. This Cumulative Update no 11 {build number: 10.50.4302.0} is for Microsoft SQL Server 2008 R2 with Service Pack 2. Microsoft resolved twelve errors. Here is the list of fixed bugs :

VSTS BUG: 1790001 | 2829845
FIX: "The provided statistics stream is corrupt" when you run the "UPDATE STATISTICS" statement against a table in SQL Server 2008 R2 or SQL Server 2012
SQL performance

VSTS BUG: 1635573 |2902151
FIX: Change Tracking incorrect current versions in database snapshots in SQL Server 2008 R2
SQL service

VSTS BUG: 1765040 |2912049
FIX: Memory leak occurs when an application that uses SQL Server Native Client tries to connect and close the connection to a SQL Server 2008 R2 instance
SQL connectivity

VSTS BUG: 1993304 |2919611
FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3 or SQL Server 2008 R2 SP2
Setup & Install

VSTS BUG: 1915818 |2920987
FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2
SQL service

VSTS BUG: 1993313 |2921630
FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2
Analysis Services

VSTS BUG: 1806945 |2922799
FIX: Unexpected exception is thrown when you convert writeback partition in SSAS 2008 R2
Analysis Services

VSTS BUG: 1993310 |2923837
FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008 or SQL Server 2008 R2
SQL service

VSTS BUG: 1917681 |2924996
FIX: Issues when you export a report to PDF with Unicode fonts in SQL Server 2008 R2
Reporting Services

VSTS BUG: 1972242 |2926699
FIX: Operating system version information that is returned from SQL Server 2008 R2 is incorrect in Windows 8.1
SQL service

VSTS BUG: 2004937 |2928669
FIX: The reports generated in SSRS 2008 R2 Report Manager are not compliant with Section 508 standards
Reporting Services

VSTS BUG: 1814380 |2929464
FIX: SELECT queries deadlock when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2008 R2
SQL service

 

I f You ever read my posts about cumulative updates, you can see something special: the third, grey line. From this info release Microsoft make “public” one more part of this update -  Fix Area. That’s great, hope it helps all of SQL Folks with implementation of CU.

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

  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 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 11

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

>> x86 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_x86
>> x64 | 2008R2_SP2_RSShrPnt_CU11_2926028_10_50_4302_x64
>> x64 | 2008R2_SP2_MDS_CU11_2926028_10_50_4302_x64
>> x64 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_x64
>> ia64 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_IA64

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!

[EN] SQL Server 2008 SP3 Cumulative Update 15 is available

LOGO__SQLServer2008SP3Few days ago Microsoft published two group of pudates for SQL Server. In this post I’m writing about package for SQL Server 2008 with Service Pack 3. In this Cumulative Updates No 15 {build number: 10.00.5850.00} Microsoft fixed last three updates? Why last three? Go to Glenn Berry’s blog post {LINK}– I totally agree with him. back to CU, here is the list of fixed bugs:

VSTS BUG: 1527664 | 2919611
FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3

VSTS BUG: 1913272 | 2921630
FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008

VSTS BUG: 1769685 | 2923837
FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008

 

This update could be applied for: Microsoft SQL Server Service Pack 3, when used with:

  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Express

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 15

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

  • SQL Server 2008 | SQLServer2008_SP3_CU15_2923520_10_00_5850_x86

  • SQL Server 2008 | x64 | SQLServer2008_SP3_CU15_2923520_10_00_5850_x64

  • SQL Server 2008 | ia64 | SQLServer2008_SP3_CU15_2923520_10_00_5850_IA64

Enjoy!