{"id":86,"date":"2005-07-04T11:31:20","date_gmt":"2005-07-04T10:31:20","guid":{"rendered":"http:\/\/www.craigmurphy.com\/blog\/?p=86"},"modified":"2005-07-04T14:41:02","modified_gmt":"2005-07-04T13:41:02","slug":"teched2005-sql-server-management-tools","status":"publish","type":"post","link":"http:\/\/www.craigmurphy.com\/blog\/?p=86","title":{"rendered":"TechEd 2005 &#8211; SQL Server Management Tools"},"content":{"rendered":"<p><a href=\"http:\/\/www.sqlskills.com\">Kimberly Tripp<\/a>&#8216;s doing an excellent job of showing off the new features in SQL Server 2005, and she&#8217;s making reference to SQL Server 2000 for comparison&#8230;<\/p>\n<p>Well, here&#8217;s my first post from TechEd 2005, Amsterdam&#8230;I didn&#8217;t get much sleep last night, considering I was on the 0550 flight out of Edinburgh wasn&#8217;t a good idea, but, as they say &#8220;we are where we are&#8221;.  And here I am blogging from a break in the session&#8230;<\/p>\n<p>My first key takeaway revolves around upgrading from a SQL Server 2000 database to a SQL Server 2005 database.  It&#8217;s something most of us, as SQL Server users, will have to do at some point (hopefully real soon).  I was pleased to learn that Microsoft have set themselves a [stretch] target of 3 minutes for a 2000 to 2005 in-place upgrade.  Kimberly also went to great lengths to explain the ins-and-outs of moving a database (she demo&#8217;d Northwind, which doesn&#8217;t ship with 2005) using detach and attach.  <\/p>\n<p>Further examples demonstrated the performance gains to be had from a 2005 upgrade, especially with regard to fast file initialisation: Kimberly created a 2gb database without fast file initialisation enabled&#8230;it took 103s.  She then proceeded to create the same database with fast file initialisation enabled&#8230;the result: 12s.  Wow. <\/p>\n<p>One halleluhaj moment is the fact that 2005&#8217;s dialog boxes are now non-modal, i.e. you don&#8217;t need to open Enterprise Manager (or 2005&#8217;s SQL Server Management Studio, SSMS) in order to do more than one thing at a time! <\/p>\n<p>Demos were in a Virtual PC window, with 1GB running XP-32 on an AMD-64&#8230;the VPC was very &#8220;performant&#8221;!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kimberly Tripp&#8217;s doing an excellent job of showing off the new features in SQL Server 2005, and she&#8217;s making reference to SQL Server 2000 for comparison&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-86","post","type-post","status-publish","format-standard","hentry","category-developer-events"],"_links":{"self":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/86","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=86"}],"version-history":[{"count":0,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/86\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}