{"id":15613,"date":"2016-04-12T09:00:25","date_gmt":"2016-04-12T16:00:25","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=15613"},"modified":"2024-01-22T22:50:29","modified_gmt":"2024-01-23T06:50:29","slug":"beyond-end-of-support-seeing-value-in-modernization","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/","title":{"rendered":"Beyond end-of-support: Seeing value in modernization"},"content":{"rendered":"

This post was authored by Tiffany Wissner, Senior Director, Product Marketing.<\/em><\/p>\n

Today is the last day of extended support for SQL Server 2005. Starting tomorrow, companies running SQL Server 2005 will no longer receive security updates or hotfixes from Microsoft. We started on this journey eighteen months ago, with our first discussion on the end of support for SQL Server 2005<\/a>, and sharing information about how to upgrade. If you haven\u2019t migrated your SQL Server 2005 databases to a newer version of SQL Server, now is the time to put in place a plan for action.<\/p>\n

While we\u2019d be remiss if we didn\u2019t mention that these customers will now run a much greater risk for business disruptions, increased maintenance costs and security and compliance issues, there is another hidden cost to running an older system that can potentially be much larger over time \u2014 lost opportunity.<\/p>\n

In 2016, the world looks much different than it did in 2005. With our smart mobile devices, much more powerful hardware, intelligent applications and cloud computing, an older database solution can be a limiting factor to an organization\u2019s competitiveness. Modern systems like SQL Server 2014<\/a> or the soon-to-be-released SQL Server 2016<\/a> give organizations the flexibility to deploy on-premises or in the cloud, to manage modern apps and create a host of business scenarios that simply weren\u2019t possible a decade ago.<\/p>\n

\u201cFrom our unique vantage point of successfully running SQL Server modernization programs for diverse customers two things clearly stood out. First of all, modernization comes with better performance and scalability. Secondly modernization drives a culture change. Companies start treating data as an asset and the SQL Server ecosystem helps them to make smarter decisions with actionable insights with an immediate positive business impact, with the integration of Power BI, R Server, Azure Machine Learning and Cortana giving insights that were previously not available.” – Debu Dasgupta, Vice President of Technology and Microsoft Evangelist, Cognizant Technology Solutions<\/a><\/p><\/blockquote>\n

Recognizing this, many companies have already undertaken their upgrades from SQL Server 2005 to more modern platforms. We recently worked with Spiceworks to survey hundreds of these customers to understand where they were in the process, which platforms they were migrating to, obstacles, costs and other factors. The report<\/a> found that the majority of SQL Server 2005 customers are either fully or partly migrated.\u00a0 With data on fellow customers\u2019 upgrade plans and durations, and the benefits these customers achieved through upgrade, it is a great read for companies still considering the move.<\/p>\n

Case in point: Pact Group<\/h3>\n

A SQL Server upgrade can be a powerful business differentiator. Australian packaging manufacturer Pact Group has acquired 44 companies since 2002, and has a five-year plan to continue its aggressive expansion \u2014 averaging four new acquisitions each year.<\/p>\n

To facilitate the plan, Pact has moved its SAP stack, which was running older Oracle and SQL Server databases, into Microsoft Azure, Windows Server 2012 R2 and SQL Server 2014, resulting in several benefits. For one, they\u2019re now working under a consumption-based model hosted on Microsoft Azure, providing massive scalability and enabling them to incorporate acquisitions without the associated cost of provisioning on-premises IT.<\/p>\n

The company\u2019s ability to spin up virtual machines has gone from two weeks to just minutes. Now Pact can respond quickly with near-unlimited capacity when managing a merger, then scale back when it\u2019s complete, paying only for what they use. Further, each of Pact\u2019s main platforms in now mirrored in the cloud, giving them a true disaster recovery solution for the first time. They\u2019ve also reduced database storage needs by 75%, from 10 terabytes to 2.5 terabytes.<\/p>\n

Looking ahead, the company is exploring the platform\u2019s ability to integrate with a variety of sensors, an IoT approach with the potential to create valuable new efficiencies and insights.<\/p>\n

The path forward<\/h3>\n

What Pact has been able to accomplish would not have been feasible if they\u2019d remained on their legacy, on-premises SAP systems powered by older versions of SQL Server, Windows Server and Oracle. By upgrading its systems, the company has literally enabled its own business plan, put itself on the path for continued growth, and opened the door for new possibilities down the road.<\/p>\n

Not every company is a large multinational like Pact, but the benefits of elasticity, agility and connectivity that enables a rich new flow of data are largely the same for organizations of all shapes and sizes. And of course security and compliance are important concerns wherever you do business.<\/p>\n

With all this in mind, Microsoft strongly encourages customers currently using SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 (the latter two will sunset in 2019) to review their technology needs and see how an upgrade to a modern database platform can make a real transformation in your business.<\/p>\n

For a deeper run-down of the benefits of SQL Server 2014, take a look at a blog post<\/a> from Takeshi Numoto, Corporate Vice President of Cloud + Enterprise Marketing from last October.<\/em><\/p>\n

If you\u2019re just getting started, these informational blog posts<\/a> will serve as great resources. You can also visit the SQL Server 2005 upgrade page<\/a> for more information on planning and executing your migration, along with options for your new database strategy. The analyst firm Directions on Microsoft has also issued a paper on planning your data platform upgrade: \u201cMigrating from SQL Server 2005,\u201d available here<\/a>.<\/p>\n

As always, Microsoft and our partners<\/a> are still here to help you complete your migrations. Many of our partners have been helping customers modernize their SQL Server install base, and they say customers are recognizing new value in their updated solutions.<\/p>\n

\u201cWe see the EoS of SQL Server 2005 as a big opportunity for large organizations. Data being the fabric of the digital enterprise, modernization starts with the designing the data layer as appropriate on the cloud or on to the latest on-premises solutions. We are excited about our partnership with Microsoft on SQL Server 2005 modernization program to help large enterprises create a digital data farm migration roadmap.\u201d – Eravi Gopan, Head, Microsoft BU, WIPRO LTD<\/a><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

This post was authored by Tiffany Wissner, Senior Director, Product Marketing. Today is the last day of extended support for SQL Server 2005. Starting tomorrow, companies running SQL Server 2005 will no longer receive security updates or hotfixes from Microsoft. We started on this journey eighteen months ago, with our first discussion on the end<\/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":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-15613","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates","review-flag-1593580410-819","review-flag-1593580419-556","review-flag-2-1593580436-981","review-flag-5-1593580452-31","review-flag-alway-1593580309-407","review-flag-integ-1593580287-179","review-flag-new-1593580247-437","review-flag-partn-1593580278-264"],"yoast_head":"\nBeyond end-of-support: Seeing value in modernization - 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\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Beyond end-of-support: Seeing value in modernization - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post was authored by Tiffany Wissner, Senior Director, Product Marketing. Today is the last day of extended support for SQL Server 2005. Starting tomorrow, companies running SQL Server 2005 will no longer receive security updates or hotfixes from Microsoft. We started on this journey eighteen months ago, with our first discussion on the end\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/\" \/>\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=\"2016-04-12T16:00:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:29+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=\"4 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\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Beyond end-of-support: Seeing value in modernization\",\"datePublished\":\"2016-04-12T16:00:25+00:00\",\"dateModified\":\"2024-01-23T06:50:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/\"},\"wordCount\":998,\"commentCount\":1,\"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\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/\",\"name\":\"Beyond end-of-support: Seeing value in modernization - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2016-04-12T16:00:25+00:00\",\"dateModified\":\"2024-01-23T06:50:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Beyond end-of-support: Seeing value in modernization\"}]},{\"@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":"Beyond end-of-support: Seeing value in modernization - 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\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/","og_locale":"en_US","og_type":"article","og_title":"Beyond end-of-support: Seeing value in modernization - Microsoft SQL Server Blog","og_description":"This post was authored by Tiffany Wissner, Senior Director, Product Marketing. Today is the last day of extended support for SQL Server 2005. Starting tomorrow, companies running SQL Server 2005 will no longer receive security updates or hotfixes from Microsoft. We started on this journey eighteen months ago, with our first discussion on the end","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-04-12T16:00:25+00:00","article_modified_time":"2024-01-23T06:50:29+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":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Beyond end-of-support: Seeing value in modernization","datePublished":"2016-04-12T16:00:25+00:00","dateModified":"2024-01-23T06:50:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/"},"wordCount":998,"commentCount":1,"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\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/","name":"Beyond end-of-support: Seeing value in modernization - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2016-04-12T16:00:25+00:00","dateModified":"2024-01-23T06:50:29+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/04\/12\/beyond-end-of-support-seeing-value-in-modernization\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Beyond end-of-support: Seeing value in modernization"}]},{"@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"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/15613"}],"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=15613"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/15613\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=15613"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=15613"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=15613"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=15613"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=15613"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=15613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}