And another one bites the dust! Wow – what a great group today… soooooo many questions! For those of you that weren’t there – the lecture was 80 minutes and the additional Q&A went on for another 45 minutes. So – as a result, there were *a lot* of additional resources needed. Let me get started with all of those right away.
To prepare for moving to SQL Server 2005 there are a few EXCELLENT resources with which you should start:
Phase 1 – Prepare to Upgrade/Migrate
- Thoroughly Review -> Knowledge Base article: Getting ready for SQL Server 2005
- Thoroughly Review -> SQL Server 2005 Upgrade Handbook
- Browse -> Upgrading to SQL Server 2005 website
- Download and execute: Microsoft SQL Server 2005 Upgrade Advisor
Phase 2 – Database-level Testing
- Copy Database Wizard or
- Backup/Restore or
Phase 3 – Server-level Testing
- Consider upgrade in-place or
- Make sure that you manually migrate all EXTERNAL objects, logins, jobs, error messages, etc.
Phase 4 – Testing/Updating after the upgrade/migration
- Update statistics immediately
- Test application code, database compatibility modes, session settings
- Check for “broken code” in terms of system table changes
- MOST of this should have already been done and assessed in Phase 1 but better to be safe!
And – finally – the other things we talked about and the rest of the links are here:
- Microsoft SQL Server 2005 Service Pack 1 Community Technology Preview
- Best Practices Analyzer Tool for Microsoft SQL Server 2000 v1.0
- SQL Server Best Practices Analyzer overview with Christian Kleinerman – from MSDN TV
- Troubleshooting Performance Problems in SQL Server 2005 – covers some excellent DMV usage scenarios
- Upgrading the Database Engine / New features in SQL Server 2005 – part 1 by Don Vilen (IMPORTANT: the video is labeled incorrectly as part 2 but video 46 is part 1)
- Upgrading the Database Engine / New features in SQL Server 2005 – part 2 by Don Vilen
And – that’s it for this week. See you next Friday when we chat about the new Management Tools and how to effectively use them!
Thanks for listening/watching and asking GREAT questions,