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

[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 SP3 Cumulative Update 14 is available

LOGO__SQL_ServerTwo updates pack has been published one day ago. First pack is for SQL Server 2008 SP3. In this Cumulative Update No 14 (build number: 10.00.5848.00 / 210 MB in zipped file for x64 env.) Microsoft fixed six submitted bugs. Here is the list:

VSTS BUG: 1517718 | 2591461
FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 1480650 | 2884888
FIX: Unable to click OK or Cancel in the query designer in BIDS 2008 or in SQL Server 2008 Report Builder

VSTS BUG: 1494726 | 2887465
FIX: You receive an incorrect result when you run a query that uses some ranking functions in SQL Server 2008

VSTS BUG: 1516349 | 2889492
FIX: You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1

VSTS BUG: 1560626 | 2892741
FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008

VSTS BUG: 1596875 | 2901479
FIX: You experience query failure when you run MDX queries in SSAS 2008

 

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

  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 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 14

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 | x86 | SQLServer2008_SP3_CU14_2893410_10_00_5848_x86

  • SQL Server 2008 | x64 | SQLServer2008_SP3_CU14_2893410_10_00_5848_x64

  • SQL Server 2008 | ia64 | SQLServer2008_SP3_CU14_2893410_10_00_5848_IA64

Enjoy!