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
- Detach/Attach
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,
kt
5 thoughts on “TechNet Webcast Series for the ITPro – Part 4 of 11”
Kim, I’m really enjoying these presentations. Good refresher from PASS and now the ability to really go into detail on these new features. I was wondering if the PPT files are available for download. I looked at the MS site, but that seems to only give the ability to look at the video. While that’s useful, it’s also several hundred MB and not something I can easily download. Do you have any ideas on where we can get just the slides?
Thanks for your help.
-Peter Schott
Hey there Peter – Actually, if you "register" for the event, then Microsoft will send you an email within 24 hours…this email will have the ppt or at least a link to the ppt. I’m pretty sure there’s a reason for why they separate these two events but I do know that that’s how it works!
Hope it helps,
kt