{"id":649,"date":"2006-04-01T01:58:15","date_gmt":"2006-04-01T01:58:15","guid":{"rendered":"\/blogs\/kimberly\/post\/TechNet-Webcast-Series-for-the-ITPro-Part-4-of-11.aspx"},"modified":"2013-01-02T07:05:49","modified_gmt":"2013-01-02T15:05:49","slug":"technet-webcast-series-for-the-itpro-part-4-of-11","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/technet-webcast-series-for-the-itpro-part-4-of-11\/","title":{"rendered":"TechNet Webcast Series for the ITPro &#8211; Part 4 of 11"},"content":{"rendered":"<p><P>And another one bites the dust! Wow &#8211; what a great group today&#8230; soooooo many questions! For those of you that weren&#8217;t there &#8211; the lecture was&nbsp;80 minutes and the additional Q&amp;A went on for another 45 minutes. So &#8211; as a result, there were *a lot* of additional resources needed. Let me get started with all of those right away.<\/P><br \/>\n<P>To prepare for moving to SQL Server 2005 there are a few EXCELLENT resources with which you should start:<\/P><br \/>\n<P><STRONG>Phase 1 &#8211; Prepare to Upgrade\/Migrate<\/STRONG><\/P><br \/>\n<UL><br \/>\n<LI>Thoroughly Review -&gt; Knowledge Base article: <a href=\"http:\/\/support.microsoft.com\/kb\/906773\/en-us\" class=\"broken_link\">Getting ready for SQL Server 2005<\/a><br \/>\n<LI>Thoroughly Review -&gt; <a href=\"http:\/\/technet.microsoft.com\/library\/Cc966519\">SQL Server 2005 Upgrade Handbook<\/a><br \/>\n<LI>Browse -&gt; <a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/default.aspx\">Upgrading to SQL Server 2005<\/a> website<br \/>\n<LI>Download and execute: <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/default.aspx\" class=\"broken_link\">Microsoft SQL Server 2005 Upgrade Advisor<\/a><\/LI><\/UL><br \/>\n<P><STRONG>Phase 2 &#8211; Database-level Testing<\/STRONG><\/P><br \/>\n<UL><br \/>\n<LI>Copy Database Wizard <EM>or<\/EM><br \/>\n<LI>Backup\/Restore <EM>or<\/EM><br \/>\n<LI>Detach\/Attach<\/LI><\/UL><br \/>\n<P><STRONG>Phase 3 &#8211; Server-level Testing<\/STRONG><\/P><br \/>\n<UL><br \/>\n<LI>Consider upgrade in-place <EM>or<\/EM><br \/>\n<LI>Make sure that you manually migrate all EXTERNAL objects, logins, jobs, error messages, etc.<\/LI><\/UL><br \/>\n<P><STRONG>Phase 4 &#8211; Testing\/Updating after the upgrade\/migration<\/STRONG><\/P><br \/>\n<UL><br \/>\n<LI>Update statistics immediately<br \/>\n<LI>Test application code, database compatibility modes, session settings<br \/>\n<LI>Check for &#8220;broken code&#8221; in terms of system table changes<br \/>\n<LI>MOST of this should have already been done and assessed in Phase 1 <EM>but <\/EM><STRONG>better to be safe!<\/STRONG><\/LI><\/UL><br \/>\n<P>And &#8211; finally &#8211; the other things we talked about and the rest of the links are here:<\/P><br \/>\n<UL><br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/default.aspx\">Microsoft SQL Server 2005 Service Pack 1 Community Technology Preview<\/a><br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=15691\" class=\"broken_link\">Best Practices Analyzer Tool for Microsoft SQL Server 2000 v1.0<\/a><br \/>\n<LI><a href=\"http:\/\/msdn.microsoft.com\/en-us\/cc311642.aspx?xml=episodes\/en\/20040610sqlserverck\/manifest.xml\">SQL Server Best Practices Analyzer overview with Christian Kleinerman<\/a> &#8211; from MSDN TV<br \/>\n<LI><a href=\"http:\/\/technet.microsoft.com\/library\/Cc966540\">Troubleshooting Performance Problems in SQL Server 2005<\/a>&nbsp;&#8211; covers some excellent DMV usage scenarios<br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\/library\/errorpages\/smarterror.aspx?aspxerrorpath=http%3a%2f%2fwww.microsoft.com%2femea%2fitsshowtime%2fsessionh.aspx%3fvideoid%3d46\" class=\"broken_link\">Upgrading the Database Engine \/ New features in SQL Server 2005 &#8211; part 1<\/a>&nbsp;by Don Vilen<STRONG>&nbsp;<\/STRONG>(<STRONG>IMPORTANT<\/STRONG>: the video is labeled incorrectly as part 2 but video 46 is part&nbsp;1)<STRONG>&nbsp;<\/STRONG><br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\/library\/errorpages\/smarterror.aspx?aspxerrorpath=http%3a%2f%2fwww.microsoft.com%2femea%2fitsshowtime%2fsessionh.aspx%3fvideoid%3d47\" class=\"broken_link\">Upgrading the Database Engine \/ New features in SQL Server 2005 &#8211; part 2<\/a>&nbsp;by Don Vilen<\/LI><\/UL><br \/>\n<P>And &#8211; that&#8217;s it for this week. See you next Friday when we chat about the new Management Tools and how to effectively use them!<\/P><br \/>\n<P>Thanks for listening\/watching and asking GREAT questions,<BR>kt<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>And another one bites the dust! Wow &#8211; what a great group today&#8230; soooooo many questions! For those of you that weren&#8217;t there &#8211; the lecture was&nbsp;80 minutes and the additional Q&amp;A went on for another 45 minutes. So &#8211; as a result, there were *a lot* of additional resources needed. Let me get started [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,58,65,74,78],"tags":[],"class_list":["post-649","post","type-post","status-publish","format-standard","hentry","category-events","category-resources","category-sql-server-2005","category-technet-webcasts","category-tips"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=649"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/649\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}