{"id":1082,"date":"2008-02-15T00:38:30","date_gmt":"2008-02-15T00:38:30","guid":{"rendered":"\/blogs\/paul\/post\/SQL-Server-2008-JumpStart.aspx"},"modified":"2017-04-13T09:52:01","modified_gmt":"2017-04-13T16:52:01","slug":"sql-server-2008-jumpstart","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/","title":{"rendered":"SQL Server 2008 JumpStart"},"content":{"rendered":"<p><FONT face=Verdana size=2><br \/>\n<P>Phew &#8211; last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs\/IT-Pros to about 130 Microsoft SQL Server experts and MVPs (like Kalen Delaney, Adam Machanic and&nbsp;Ron Talmage). This was the (95% complete) Beta delivery of a course we&#8217;ve been developing for the last six months for Microsoft that they&#8217;ll use to train their SQL experts around the world on the new release. It&#8217;s been very interesting watching the features develop through the CTPs (especially since I left the fold last August) &#8211; and making demos work on pre-release builds of the CTPs.<\/P><br \/>\n<P>Teaching the course&nbsp;was a *blast* &#8211; the thing I love about teaching a really geeky crowd is the plethora of great questions and opportunities for going deep with explanations. Our team actually wrote and delivered the concurrently presented Developer and BI tracks as well. As you can see from the list below (and this is just the features a DBA needs to use\/know about), SQL Server 2008 isn&#8217;t a dot release of Yukon at all, as some people have suggested. Over the three days we covered:<\/P><br \/>\n<UL><br \/>\n<LI>Database Mirroring (D)<br \/>\n<LI>Backup Compression<br \/>\n<LI>Peer-to-Peer Replication (D)<br \/>\n<LI>Transparent Data Encryption (D)<br \/>\n<LI>Extensible (Off-Box) Key Management<br \/>\n<LI>All Actions Audited (D)<br \/>\n<LI>Policy-Based Management<br \/>\n<LI>Resource Governor (D)<br \/>\n<LI>Extended Events (D)<br \/>\n<LI>Spatial Indexes<br \/>\n<LI>Integrated Full-Text Search<br \/>\n<LI>Sparse Columns (D)<br \/>\n<LI>Filtered Indexes<br \/>\n<LI>Change Tracking<br \/>\n<LI>Change Data Capture (D)<br \/>\n<LI>FILESTREAM (D)<br \/>\n<LI>Performance Data Collection<br \/>\n<LI>Query Optimizer Enhancements<br \/>\n<LI>Data Compression (D)<br \/>\n<LI>Service Broker<br \/>\n<LI>Partition-Level Lock Escalation (D)<\/LI><\/UL><br \/>\n<P>The features marked with a (D) are ones I demo&#8217;d during the course (Kimberly demo&#8217;d a bunch of the others &#8211; especially the tools features). Some of the demos were challenging to make work in time as we only got a pre-CTP6 build mid-January just before we headed off to China.<\/P><br \/>\n<P>So why am I posting this? Well, a bunch of these features are in CTP-6, which should be just around the corner, and I have some easy-to-understand demos of them that I&#8217;ll be posting here over the next month or so. Also, if this course sounds interesting, Kimberly and I will be teaching it in various configurations over the next year &#8211; starting with SQL Connections in April, a soon-to-be-announced class in Iceland in March, and the ITPro portion of <a href=\"http:\/\/ignite.microsoft.com\">TechEd<\/a> in June.<\/P><br \/>\n<P>Watch this space starting next week (today&#8217;s the last day of&nbsp;six straight weeks of teaching for us so this weekend&#8217;s a break :-))<\/P><\/FONT><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Phew &#8211; last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs\/IT-Pros to about 130 Microsoft SQL Server experts and MVPs (like Kalen Delaney, Adam Machanic and&nbsp;Ron Talmage). This was the (95% complete) Beta delivery of a course we&#8217;ve been developing for the last six months for Microsoft [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13,21,25,27,32,37,39,41,57,65,70,75,76,86],"tags":[],"class_list":["post-1082","post","type-post","status-publish","format-standard","hentry","category-auditing","category-backuprestore","category-change-data-capture","category-compression","category-conferences","category-database-mirroring","category-encryption","category-extended-events","category-filestream","category-locking","category-partitioning","category-policy-based-management","category-replication","category-resource-governor","category-sql-server-2008"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server 2008 JumpStart - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2008 JumpStart - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Phew &#8211; last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs\/IT-Pros to about 130 Microsoft SQL Server experts and MVPs (like Kalen Delaney, Adam Machanic and&nbsp;Ron Talmage). This was the (95% complete) Beta delivery of a course we&#8217;ve been developing for the last six months for Microsoft [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2008-02-15T00:38:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:52:01+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/\",\"name\":\"SQL Server 2008 JumpStart - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2008-02-15T00:38:30+00:00\",\"dateModified\":\"2017-04-13T16:52:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008 JumpStart\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2008 JumpStart - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2008 JumpStart - Paul S. Randal","og_description":"Phew &#8211; last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs\/IT-Pros to about 130 Microsoft SQL Server experts and MVPs (like Kalen Delaney, Adam Machanic and&nbsp;Ron Talmage). This was the (95% complete) Beta delivery of a course we&#8217;ve been developing for the last six months for Microsoft [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/","og_site_name":"Paul S. Randal","article_published_time":"2008-02-15T00:38:30+00:00","article_modified_time":"2017-04-13T16:52:01+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/","name":"SQL Server 2008 JumpStart - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2008-02-15T00:38:30+00:00","dateModified":"2017-04-13T16:52:01+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-jumpstart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008 JumpStart"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=1082"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1082\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=1082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=1082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=1082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}