{"id":133,"date":"2015-04-29T15:00:00","date_gmt":"2015-04-29T22:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/"},"modified":"2024-01-22T22:48:37","modified_gmt":"2024-01-23T06:48:37","slug":"sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/","title":{"rendered":"SQL Server 2005 support ends April 2016 – Here\u2019s why that\u2019s a good thing"},"content":{"rendered":"

Now\u2019s the perfect time to deploy Microsoft SQL Server 2014. Sure, it enables faster data processing and performance, but that\u2019s just the beginning. If ensuring business-critical performance, maintaining security and compliance, and optimizing your data infrastructure are important to you, Microsoft has the tools and resources to support your migration from SQL Server 2005.<\/p>\n

With the help of SQL Server 2014, leading hospital Beth Israel Deaconess Medical Center cut its query time from 45 to 10 seconds and can now query decades of historical data on demand with HDInsight. In addition, its IT team can implement new features without rewriting applications.<\/p>\n

Discover the measurable difference SQL Server 2014 has made for other organizations\u2014and can make for you too.<\/p>\n

Read Forrester\u2019s The Total Economic ImpactTM<\/sup> of Microsoft SQL Server,<\/i> a commissioned study conducted by Forrester Consulting on behalf of Microsoft.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Now\u2019s the perfect time to deploy Microsoft SQL Server 2014. Sure, it enables faster data processing and performance, but that\u2019s just the beginning. If ensuring business-critical performance, maintaining security and compliance, and optimizing your data infrastructure are important to you, Microsoft has the tools and resources to support your migration from SQL Server 2005.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-133","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-new-1593580247-437"],"yoast_head":"\nSQL Server 2005 support ends April 2016 - Here\u2019s why that\u2019s a good thing - 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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2005 support ends April 2016 - Here\u2019s why that\u2019s a good thing - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Now\u2019s the perfect time to deploy Microsoft SQL Server 2014. Sure, it enables faster data processing and performance, but that\u2019s just the beginning. If ensuring business-critical performance, maintaining security and compliance, and optimizing your data infrastructure are important to you, Microsoft has the tools and resources to support your migration from SQL Server 2005.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/\" \/>\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=\"2015-04-29T22:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:48:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/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=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2005 support ends April 2016 – Here\u2019s why that\u2019s a good thing\",\"datePublished\":\"2015-04-29T22:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/\"},\"wordCount\":151,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/\",\"name\":\"SQL Server 2005 support ends April 2016 - Here\u2019s why that\u2019s a good thing - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-04-29T22:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2005 support ends April 2016 – Here\u2019s why that\u2019s a good thing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/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 2005 support ends April 2016 - Here\u2019s why that\u2019s a good thing - 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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2005 support ends April 2016 - Here\u2019s why that\u2019s a good thing - Microsoft SQL Server Blog","og_description":"Now\u2019s the perfect time to deploy Microsoft SQL Server 2014. Sure, it enables faster data processing and performance, but that\u2019s just the beginning. If ensuring business-critical performance, maintaining security and compliance, and optimizing your data infrastructure are important to you, Microsoft has the tools and resources to support your migration from SQL Server 2005.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-04-29T22:00:00+00:00","article_modified_time":"2024-01-23T06:48:37+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/cm-edgetun.pages.dev\/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":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2005 support ends April 2016 – Here\u2019s why that\u2019s a good thing","datePublished":"2015-04-29T22:00:00+00:00","dateModified":"2024-01-23T06:48:37+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/"},"wordCount":151,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/","name":"SQL Server 2005 support ends April 2016 - Here\u2019s why that\u2019s a good thing - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-04-29T22:00:00+00:00","dateModified":"2024-01-23T06:48:37+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/29\/sql-server-2005-support-ends-april-2016-heres-why-thats-a-good-thing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2005 support ends April 2016 – Here\u2019s why that\u2019s a good thing"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":0,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=133"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=133"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=133"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=133"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}