Wednesday, April 8, 2009

SQL Server 2008 Service Pack 1

SQL Server 2008 Service Pack 1 was just released yesterday (April 7, 2009).

Along with the fixes for known bugs, this Service Pack also adds some new functionality to SQL Server 2008 mainly from the DBA's perspective.

What’s new
Microsoft has added new functionality to SQL Server with this service pack. The main new features are:
  • Slipstreaming: Allows integrating a SQL Server 2008 update (i.e. Service Pack, Hot Fix, etc.) and the original installation set.
  • Ability to uninstall SQL 2008 cumulative updates or service packs from “Programs and Features” in the Control Panel.
  • ClickOnce version of Report Builder 2.0.
For more information on what’s new on SQL Server 2008 Service Pack 1 you can visit the following link:

Bugs Fixed
The list of bugs that are fixed in SQL Server 2008 Service Pack 1 can be found on the following link:

Downloading the Service Pack
You can download the Service Pack from the following link:

Also, you can read the release notes from here.

The SQL Server 2008 SP1 can be used for all the editions of SQL Server 2008.
Check out my latest eBooks on SQL Server:
Administering SQL Server - Ebook Tuning SQL Server - Ebook

Easily secure your SQL Server instances! Try out DBA Security Advisor!
DBA Security Advisor for SQL Server by SQLArtBits
DBA Security Advisor was developed by SQLArtBits. The tool was being carefully developed for an entire year and it contains comprehensive security checks and recommendations based on proven SQL Server security best practices. Feel free to download and use the Community Edition which is free and if you find it useful, you can consider upgrading to the Enterprise Edition!

Artemakis Artemiou [MVP]

Author & Editor

Artemakis Artemiou is a Senior SQL Server Architect, Software Developer and Microsoft Data Platform MVP. He is also an author, regular blogger, president of Cyprus.NET User Group and CY Country leader of INETA-EU. He is also the creator of DBA Security Advisor and In-Memory OLTP Simulator. Artemakis is a frequent guest author of worldwide well-respected online journals where he writes articles focusing on many SQL Server topics.

Reference: The SQL Server and .NET Hub (