TechNet Webcast Series for the ITPro – Part 4 of 11

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



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:



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

  1. 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

  2. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.