[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} BIDS Helper version 1.6.5 released

BIDSHelperSmallLogoTwo days ago (January 7th) new version of BIDS (Business Intelligence Development Studio) Helper has been released /and yesterday Jan. 8th files has been updated/. This fantastic feature is an add-in using for Business Intelligence projects with:

  • Visual Studio 2005 and SQL Server 2005
  • Visual Studio 2008 and SQL Server 2008 and SQL Server 2008 R2
  • Visual Studio 2010 and Visual Studio 2012 for SQL Server 2012

When You get file from CodePlex, unzipping, and installing, You will get access for many features:

  • Analysis Services Multidimensional:

Aggregation Manager Calculation Helpers Column Usage Reports Delete Unused Aggregations Delete Unused Indexes Deploy Aggregation Designs Deploy MDX Script Deploy Perspectives Dimension Data Type Discrepancy Check Dimension Health Check Dimension Optimization Report Duplicate Role Many-to-Many Matrix Compression Measure Group Health Check Non-Default Properties Report Parent-Child Dimension Naturalizer Printer Friendly Aggregations Printer Friendly Dimension Usage Roles Report Similar Aggregations Smart Diff Show Extra Properties Sync Descriptions Test Aggregation Performance Tri-State Perspectives Update Estimated Counts Validate Aggregations Visualize Attribute Lattice

  • Analysis Services Tabular:

 Roles Report Smart Diff Tabular Actions Editor Tabular Display Folders Tabular HideMemberIf Tabular Pre-Build Tabular Sync Descriptions Tabular Translations Editor Tabular Annotation Workaround Unused Columns Report 

  • Integration Services:

Batch Property Update Biml Package Generator Create Fixed Width Columns Deploy SSIS Packages Design Warnings dtsConfig File Formatter Expression and Configuration Highlighter Expression List Fix Relative Paths Non-Default Properties Report Pipeline Component Performance Breakdown Reset GUIDs Smart Diff Sort Project Files Sortable Package Properties Report SSIS Performance Visualization Variables Window Extensions

  • Reporting Services:

 Dataset Usage Reports Delete Dataset Cache Files Smart Diff

  • General:

Enable/Disable features Preferences Version Notification

From add-in’s download page You can choose from few versions:

  • BIDSHelper2012Setup(1.6.5.0).exe | application, 1743K, uploaded Tue – 141 downloads
  • BIDSHelper2012_1_6_5_0.zip | application, 2317K, uploaded Tue – 17 downloads
  • BIDSHelper2008Setup(1.6.5.0).exe | application, 1711K, uploaded Tue – 80 downloads
  • BIDSHelper2008_1_6_5_0.zip | application, 2277K, uploaded Tue – 16 downloads
  • BIDSHelper2005Setup(1.6.5.0).exe | application, 1711K, uploaded Tue – 16 downloads
  • BIDSHelper2005_1_6_5_0.zip | application, 2276K, uploaded Tue – 5 downloads

And when You get Your favorite… let’s play.

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

LOGO__SQLServer2008R2v2Two updates pack from December 2013. After two weeks some part of my environment are ready for it. First pack for SQL Server 2008 R2 with SP2. In this Cumulative Update (build 10.50.4297.0) Microsoft fixed about fifteen bugs for many parts of SQL Server environment for SQL Engine, Analysis Services, Reporting Services ans Integration Services. Here is the list:

VSTS BUG: 1258005 | 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 or in SQL Server 2008 R2

VSTS BUG: 1611278 | 2532079
FIX: DML statements do not run on some columns in a table after you enable CDC on some other columns in SQL Server 2008 R2

VSTS BUG: 1590438 | 2671078
FIX: "Attempting to set a non-NULL-able column’s value to NULL" error message when you use a MERGE statement in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1502369 | 2888996
FIX: Data purity corruption in table sys.sysbinobjs on MASTER database when you log on SQL Server 2008 R2 by using SA account and run the DBCC CHECKDB statement

VSTS BUG: 1610543 | 2889492
FIX: You cannot open the SQL Server Analysis Services properties dialog box in Windows 8.1

VSTS BUG: 1519116 | 2891115
FIX: "The search text was not found" error when you search specific formatting numeric values from a report in SSRS 2008 R2

VSTS BUG: 1540252 | 2891489
FIX: The replication Log Reader Agent fails when you enable CDC and Transaction Replication for some columns in SQL Server 2008 R2

VSTS BUG: 1560630 | 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: 1672382 | 2895694
FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012 or in SSAS 2008 R2

VSTS BUG: 1650149 | 2902858
FIX: SSIS package will never stop running when the package contains a Fuzzy Lookup task from BIDS in SQL Server 2008 R2

VSTS BUG: 1659059 | 2904010
FIX: A small number of rows are sampled in SQL Server 2008 R2 when table statistics are updated automatically or together with specified sampling rate

VSTS BUG: 1748108 | 2911026
FIX: Access violation when you query sys.dm_server_memory_dumps in SQL Server 2008 R2

VSTS BUG: 1713989 | 2911385
FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2

VSTS BUG: 1765207 | 2912949
FIX: SSAS crashes when there are more than one threads try to access a SSAS 2008 R2 cube at the same time

VSTS BUG: 1742457 | 2913206
FIX: Cannot pass report parameters to Reports in SharePoint Document Library in SSRS 2008 R2 by using HTML forms

 

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

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

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 10

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

  • SQL Server 2008 R2 | x86 | 2008R2_SP2_SNAC_CU10_2908087_10_50_4297_x86

  • SQL Server 2008 R2 | x86 | SQLServer2008R2_SP2_CU10_2908087_10_50_4297_x86

  • SQL Server 2008 R2 | x64 | 2008R2_SP2_MDS_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | x64 | 2008R2_SP2_SNAC_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | x64 | SQLServer2008R2_SP2_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | x64 | 2008R2_SP2_RSShrPnt_CU10_2908087_10_50_4297_x64

  • SQL Server 2008 R2 | ia64 | SQLServer2008R2_SP2_CU10_2908087_10_50_4297_IA64

  • SQL Server 2008 R2 | ia64 | 2008R2_SP2_SNAC_CU10_2908087_10_50_4297_IA64

Enjoy!