August 2007 - Posts

Cumulative update package 3 for SQL Server 2005 Service Pack 2

Today (8/20/2007) we shipped the Third Cumulative Update from SQL again On Time


  Public KB Article 


Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.

Cumulative Update 3 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2.

Note This build of the cumulative update package is also known as build 3186.


How to obtain Cumulative Update 3 for SQL Server 2005 Service Pack 2

A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2005 service pack that contains the hotfixes in this cumulative update package.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the cumulative update package. To submit an online request to obtain the cumulative update package, visit the following Microsoft Web site: (

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. To create a separate service request, visit the following Microsoft Web site: (


Itay Braun

PerformancePoint Server LAST CTP announced!

Today, Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch!  To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage.  In addition to this internal announcement, BI analyst and press outreach will start next week announcing CTP4 in the context of the Microsoft BI momentum.  Stay tuned for more information.


Watch for more news as launch date nears.  In the meantime, feel free to drive your prospects to the connect site to download the product and to the PerformancePoint Server launch site to see the product in action!


Also, your prospects and customers can now download a copy of the OLAP report on PerformancePoint Server.  In it, Nigel Pendse recognizes that “PerformancePoint has a scalable architecture” and the product is “already reported to outperform some of the established market-leading products”.



Itay Braun

The DataDude team release again: VSDBPro Power Tools release v1.0 is now available!

The Power Tools contain an impressing first set of new features showing off the ability to continuously innovate and respond to customer demand.

  • Dependency Viewer
  • Refactoring
    • Move Schema
    • Expand Wildcard
    • Fully Quality Name
    • Refactor in to strongly typed DataSet definitions
    • Refactor Command Generator
  • Data Generation
    • Sequential Data Bound Generator
    • Editors for the Data Bound Generator, Sequential Data Bound Generator and RegEx String Generator to make configuration easier
    • The RegEx editor also tries to interpret your CHECK CONSTRAINTs and create a matching RegEx expression that you can use to generate data values that match the constraint definition
    • The RegEx editor can also be used for interactively defining and testing RegEx expressions and evaluate the output visually, which makes it a lot easier to create the right RegEx expression for your value domain.
  • MSBuild Tasks
    • SqlSchemaCompareTask; allows you to compare schemas between two database from the command line using MSBuild.
    • SqlDataCompareTask; allows you to compare the content of tables within two databases from the command line using MSBuild.
  • T-SQL Static Code Analysis
  •  Miscellaneous tools
    • SQL script pre-processor command-line utility, which will expand all SQLCMD includes and variable definitions (sqlspp.exe)
  • Schema Manager API

See for a more detailed explanation.

Download page English - United States

Direct link:



Itay Braun

Upcoming Katmai CTP4 Public Web Chat

Hello All


There is an upcoming Katmai CTP4 Public Web Chat


More details available here



SQL Server 2008 July CTP Live Meeting Schedule

Direct links to the Live Meetings events to be posted soon

Enterprise Scale Reporting Engine



AS Time Series Stability



New Datetime Data Type



Database Mirroring Enhancements



Ordpath For SQL Server





Itay Braun

Top 10 Hidden Gems in SQL Server 2005

I just heard about this very interesting document (it was published in January, though). It defiantly worth looking at

 Top 10 Hidden Gems in SQL Server 2005






This Blog