Skip to content

SQL 2008 SP1

April 23, 2009

I had a chance to take a look yesterday at Service Pack 1 for SQL Server 2008. It looks like Microsoft finally got three things right with this release:

  1. It can be uninstalled. If you install it and then find that there are unexpected problems with your production system post-install, it can be backed out again without reinstalling SQL Server from scratch. Unfortunately, this may not be as much of an issue as it once was, as…
  2. … plenty of bug fixes, but almost no functionality changes. In other words, far less of a chance that it’s going to break something. Of course, that doesn’t mean it still shouldn’t be tested on a development, QA, or virtual environment first before rolling it to production, but we should be a little more confident than “cross the fingers and hope” that the production rollout won’t be keeping us up for the next two nights fixing problems.
  3. Finally, it can be slipstreamed into the install media. For those of you with stable environments, this may not be such a big deal, but for DBAs that are forever installing SQL here, there, and everywhere, it’s a great time-saver as there is still only one install get through, and not two or three.

Many DBAs and companies generally wait for the first service pack of anything that has a Microsoft stamp on it before upgrading, so it’ll be interesting to see, now that 2008 SP1 is out, whether the wheels start rolling on the 2008 bandwagon.


Comments are closed.

%d bloggers like this: