Testing a SQL Server environment before an upgrade

Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.

Does Upgrading to SQL Server 2008 Fit Your Business?

While SQL Server 2008 offers several new benefits for organizations, the trick is figuring out if those performance and availability advantages are truly worth the upgrade.

Upgrade Strategies for SQL Server 2008

If you make the decision to upgrade to 2008, there are a number of tools that make the process easier, but you still need to understand what things you should consider. We have a new article from Arshad Ali to help you understand the process and what you should consider.

Side by Side

Post SQL Server 2008 Upgrade - SQL School Video

After you complete an upgrade to SQL Server 2008, Brian Knight goes over some things you might want to do first.

Just Keep Going and Going and Going

The upgrade treadmill might hit you in ways that you didn't expect.

SQL Server 2008 Upgrade Technical Reference Guide

This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.

Is It Worth Upgrading to SQL Server 2008

New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.

Restoring a database during SQL Server upgrade

Part 2 in this upgrade series lists the steps to point application traffic at a transition server while the primary cluster is rebuilt to Windows Server 2003 and SQL Server 2005.

SQL Server 2005 In-Place Upgrade Versions