Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

October 2008 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

October 2008 - Posts

SQL Server 2005 Service Pack 3 - public beta for your action

As promised by SQL Server Developmen team about SQL Server 2005 SP3 the public beta is now available for your action and set of tasks for your 2005 environment.

So what this public beta provides, this is a rollup Quick Fix Engineering that will have all the work including from SP2 as well as addresses critical issues reported through the SQL Server community. More tasks important for you is as per the revised servicing strategy this SP3 will not have or no introduction of any new features to SQL Server 2005 version (phew).

Obviously this SP3 will be applicable to following editions:

  • SQL Server 2005 Enterprise Edition
  • Server 2005 Enterprise Evaluation Edition
  • SQL Server 2005 Developer Edition
  • SQL Server 2005 Standard Edition
  • SQL Server 2005 Workgroup Edition

So more and more public participation will get more fixes done with a release by end of this year as per previous notification from Microsoft. From here you can Download SQL Server 2005 SP3  and to know more about What's New in SQL Server 2005 SP3 this is for your action.

 

Cumulative Update Package 1 for SQL Server 2008 - are you ready for testing!

First one in the series of SQL Server 2008 version, here it comes Cumulative Update package 1!

What kind of fixtures are available in this CU1 package? 

Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008.

After you apply this CU1 on SQL 2008 instance the build number should be 10.00.1763.00, this is to help you that whether the application has been applied successfully or not. As a best practice and I prefer/recommend that you must test hotfixes before you deploy them in a production environment. As you may be aware that these hotfixes will not have easy rollback steps such uninstallation and being the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.

KBA956909  link gives list of SQL Server 2008 builds that were released after 2008 version has been RTM'd. As you may be aware that the 2008 version is multi-language, so as the hotfixes and you can apply this CU package which consists all the component packages within one cumulative hotfix package for all the languages. CU package is intelligent enough to identify to install updates only those components are installed on the system, another catch to apply this CU package is you must enable SMO & DMO extended stored procedures before you apply this update package.

In similar to Cumulative Update Package for SQL Server 2005 this 2008 package can only be obtained by contacting Microsoft Customer Service and Support (CSS) and don't forget to test perfectly before applying them to the production server, better be safe than sorry!

As usual it is better to remind you about the Incremental Servicing Model (ISM) about these Cumulative Updates from the SQL Server team and also worth to mention about New naming schema for SQL Server product from this  822499 link.