Running The SQL Server 2005 Upgrade Advisor - Video Series Video Category: Installing, Deploying, and Upgrading to SQL Server 2005 Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 The SQL Server 2005 Upgrade Advisor is a helpful tool designed to identify potential problems when upgrading your database/server/application to SQL Server 2005. This video series talks about using the Upgrade Advisor against SQL Server 2000 and SQL Server 7.0 in an attempt to understand what changes must be made in our SQL Server 7.0 and 2000 databases before upgrading them to SQL Server 2005.

Videos in this Series:

Title Skill Length Download Part 1 - An Overview of the Options Available for Upgrading and Migrating   300 8 mins. Download Part 2 - Installing the SQL Server Upgrade Advisor from the CD and Upgrading Fro...   200 5 mins. Download Part 3 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a...   200 30 mins. Download Part 4 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a...   200 11 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Book You Should Probably Own: Christopher Date's "An Introduction to Database Systems" Disk defragmenters can make your system run faster by reorganizing your files according to usage statistics and by keeping files contiguous. Disk defragmentation programs search out the parts of files that are scattered around the hard drive and attempt to put the files into a contiguous block. After SQL Server 2000 you should not be using @@IDENTITY in your code. Microsoft replaced @@IDENTITY with SCOPE_IDENTITY() in SQL Server 2000