SQL 2008 SP1 Available

Microsoft released for production Service Pack 1 for SQL Server 2008.  It’s recommended that you read the release notes first.  And I’d strongly recommend testing!

Here’s a tip on the testing.  Usually you’re using production systems and have expensive hardware.  Why not perform a P2V conversion (e.g. VMM 2008 and Hyper-V) for the purpose of testing?  You can take a snapshot of the new VM and then apply the service pack.  Your application teams can test the final VM build.  If you need to retest then apply the snapshot to revert to the initial pre-SP state.  It’s a cheap way to do this without impacting production systems.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.