Running The SQL Server 2005 Upgrade Advisor - Video Series Video Category: Installing, Deploying, and Upgrading SQL Server 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:

Performance Tip: If your stored procedures use temporary tables or table variables create these as the first line(s) of code in your stored procedure. This helps minimize/prevent recompiles which allows SQL Server to cache the procedure's execution plan for maximum reuse Helpful Keyboard Shortcuts: "ALT" + "F4" closes the application or, if no applications are open, prompts you to shutdown/log off SQL Server 2000 Service Pack 3 Additions/Changes: A new Transact-SQL function "fn_get_sql" was introduced to help DBAs diagnose problematic processes