THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at since 2006, focusing on manageability, performance, and new features, and also blogs at and; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

SQL Server 2008 Service Pack 1 : CTP is available!

Yes, you read that right; for those of you waiting to try SQL Server 2008 until SP1 is available, we are one step closer.  You can download the CTP from the following URL:

The CTP will bring your instance to build # 10.00.2520.

Thumbs up on finally adding slipstream capability and the ability to uninstall the service pack without uninstalling the instance.

Thumbs down on creating a CHM help file that is mostly legalese and requires a self-extracting exe wrapper to extract one file.

There is also an Express version available:

You can read more about the release at the Release Services blog:

Published Tuesday, February 24, 2009 10:20 AM by AaronBertrand



Aaron Bertrand said:

Of course, it is always annoying when we have to restart a machine or stop a service to service software.

February 26, 2009 2:39 PM

Chris Wood said:


Sounds good being able to slipstream and great to be able to uninstall but I would like to know about changing collation after the install. We can have some unusual collations here so we tend to check the collation when the Gold(RTM) version is installed so that if we have to change collation we just rebuild at that time. I am unsure if SQL2005 onwards can change the collation of an SQL instance that is beyond RTM without having to reapply the SP's, hotfixes etc afterwards. Do you know if you create an SP1 instance wheter you can change the collation without having to re-apply SP1 at the end?



February 26, 2009 5:43 PM

AaronBertrand said:

No idea Chris, in all of my environments we are set up with default collation.  I had one SQL 2000 instance a few years ago that was a non-standard collation (CP439 if I remember right) and it was a royal pain to deal with.

February 28, 2009 12:49 PM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog



Privacy Statement