{"id":24712,"date":"2018-07-12T11:00:55","date_gmt":"2018-07-12T18:00:55","guid":{"rendered":""},"modified":"2024-01-22T22:51:18","modified_gmt":"2024-01-23T06:51:18","slug":"sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/","title":{"rendered":"SQL Server 2008 end of support is the first step to tomorrow\u2019s database"},"content":{"rendered":"<p>Today, Takeshi Numoto blogged about the upcoming <a href=\"https:\/\/aka.ms\/takeshieosblog\">SQL Server 2008 and 2008 R2 end of support<\/a>. If you\u2019ve been thinking about what to do with your SQL Server 2008 and 2008 R2 databases, you\u2019re not alone. These databases reach end of support on July 9, 2019, and many organizations have started planning in earnest for this milestone.<\/p>\n<p>Which brings us to Will, a database admin at that development shop downtown. Bucking the job-hopping trends of today, Will\u2019s been a stalwart for his company, wrangling data for them since the mid-2000s. He remembers leading the installation of SQL Server 2008. Back then, connections were speedy, requests processed swiftly. Security, efficiency, and good clean design existed in abundance\u2014there was a place for every byte and every byte was in its place. App developers loved Will because he made sure their data was right where they needed it, when they needed it. What an idyllic, peaceful time!<\/p>\n<p>A lot has happened in the decade since. Over the years, Will\u2019s information transfer network has grown and evolved\u2014forking and pooling and spidering as it has had to make new, less-efficient references. The schema, once so clear, is now muddied and confusing, obscuring paths for formerly responsive queries. Latency abounds. And lurking in every shadow? The threat of unidentified, potentially insecure, rogue requests for information. Those developers aren\u2019t nearly so happy anymore. Ugh.<\/p>\n<p>Fortunately, hope is not lost for Will. He can restore the organizational marvel that was yesterday\u2019s landscape\u2014and layer on even more improvements. Yes, modernization to <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2017\">SQL Server 2017<\/a> or <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/sql-database\/\">Azure SQL Database<\/a> must be undertaken carefully, with planning and analysis and meticulous list-making. But it\u2019s a journey worth taking.<\/p>\n<p>Plus, Will\u2019s options aren\u2019t limited to a single choice. The new SQL Server runs on numerous hosting environments and operating systems\u2014on-premises or in the cloud, virtual machine or Azure data services, Windows or Linux. As soon as it\u2019s time to reroute those data streams, clear away the puddles, and brighten up the place, we\u2019re here to help.<\/p>\n<h2>End of support is coming soon<\/h2>\n<p>As mentioned, SQL Server 2008 and 2008 R2 reach the end of support on July 9, 2019. We know it can be difficult to upgrade everything before end-of-support deadlines like this. Thus, we\u2019re offering extended security updates for SQL Server 2008 when you rehost your database in Azure Virtual Machines\u2014with no application code changes needed. You\u2019ll gain the critical patches you need to help keep your data safe for three more years after the end-of-support deadline, giving you time to plan and implement your next move. Find out all the details you need in the <a href=\"https:\/\/aka.ms\/takeshieosblog\">end-of-support blog post<\/a>.<\/p>\n<p>All this is to say, the future of data is bright for Will, his data-loving development team, and you.<\/p>\n<h2>Get started today<\/h2>\n<ul>\n<li>Read about the recently announced <a href=\"https:\/\/aka.ms\/takeshieosblog\">end-of-support offer<\/a>.<\/li>\n<li>Watch a <a href=\"https:\/\/info.microsoft.com\/ww-landing-windows-server-2008-sql-server-2008-end-of-support.html\">free webinar<\/a>\u00a0on your end-of-support options.<\/li>\n<li>See what&#8217;s new since 2008 in our <a href=\"http:\/\/download.microsoft.com\/download\/1\/6\/9\/169010E5-9138-4DBD-A33F-EA4B6EE9AB5A\/Growing_SQL_Server_Infographic_EN_US.pdf\">feature comparison infographic<\/a>.<\/li>\n<li>Download\u00a0a <a href=\"https:\/\/www.microsoft.com\/en-US\/sql-server\/sql-server-2017\">free trial<\/a> of SQL Server 2017.<\/li>\n<li>Create a managed cloud database with an <a href=\"https:\/\/azure.microsoft.com\/en-us\/free\/services\/sql-database\/\">Azure free account<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Today, Takeshi Numoto blogged about the upcoming SQL Server 2008 and 2008 R2 end of support. If you\u2019ve been thinking about what to do with your SQL Server 2008 and 2008 R2 databases, you\u2019re not alone.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2391,5227,2406,2415,2418],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-24712","post","type-post","status-publish","format-standard","hentry","product-azure","product-azure-sql-database","product-sql","product-sql-server-2017","product-sql-server-on-azure-vms","product-sql-server-on-linux","content-type-updates","review-flag-9-1593580472-173","review-flag-free-1593619513-128","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2008 end of support is the first step to tomorrow\u2019s database - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2008 end of support is the first step to tomorrow\u2019s database - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Today, Takeshi Numoto blogged about the upcoming SQL Server 2008 and 2008 R2 end of support. If you\u2019ve been thinking about what to do with your SQL Server 2008 and 2008 R2 databases, you\u2019re not alone.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-12T18:00:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2008 end of support is the first step to tomorrow\u2019s database\",\"datePublished\":\"2018-07-12T18:00:55+00:00\",\"dateModified\":\"2024-01-23T06:51:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/\"},\"wordCount\":520,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/\",\"name\":\"SQL Server 2008 end of support is the first step to tomorrow\u2019s database - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2018-07-12T18:00:55+00:00\",\"dateModified\":\"2024-01-23T06:51:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008 end of support is the first step to tomorrow\u2019s database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2008 end of support is the first step to tomorrow\u2019s database - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2008 end of support is the first step to tomorrow\u2019s database - Microsoft SQL Server Blog","og_description":"Today, Takeshi Numoto blogged about the upcoming SQL Server 2008 and 2008 R2 end of support. If you\u2019ve been thinking about what to do with your SQL Server 2008 and 2008 R2 databases, you\u2019re not alone.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-07-12T18:00:55+00:00","article_modified_time":"2024-01-23T06:51:18+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2008 end of support is the first step to tomorrow\u2019s database","datePublished":"2018-07-12T18:00:55+00:00","dateModified":"2024-01-23T06:51:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/"},"wordCount":520,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/","name":"SQL Server 2008 end of support is the first step to tomorrow\u2019s database - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2018-07-12T18:00:55+00:00","dateModified":"2024-01-23T06:51:18+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/12\/sql-server-2008-end-of-support-is-the-first-step-to-tomorrows-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008 end of support is the first step to tomorrow\u2019s database"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24712","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=24712"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24712\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=24712"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24712"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24712"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24712"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24712"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}