{"id":28093,"date":"2017-03-08T18:34:25","date_gmt":"2017-03-08T18:34:25","guid":{"rendered":"http:\/\/greenpages.com\/?p=7050"},"modified":"2017-03-08T18:34:25","modified_gmt":"2017-03-08T18:34:25","slug":"the-end-is-near-for-microsoft-sql-2005","status":"publish","type":"post","link":"https:\/\/icloud.pe\/blog\/the-end-is-near-for-microsoft-sql-2005\/","title":{"rendered":"The End Is Near for Microsoft SQL 2005"},"content":{"rendered":"

It\u2019s an end of a great era some may say\u2026SQL 2005 is going End of Support. It\u2019s like finally selling that old Dodge Durango you had since college, or throwing away that T-shirt with a whole bunch of holes in it.\u00a0It\u2019s a sad day when you finally must say goodbye.\u00a0The year 2005 brought some amazing things such as YouTube, Mr. Brightside by the Killers, and The Chronicles of Narnia movie (WHAT!) What was so special about SQL 2005 was that it took Microsoft five years to come out with it. The previous edition of SQL was 2000 so it took some time to perfect the next installment of this well-known database. Now all that is coming to an end as extended support will no longer be available for SQL 2005 as of April 12, 2016.\u00a0<\/span><\/p>\n

With the End of Support, security updates and hotfixes are no longer available from Microsoft. There\u2019s never been a better time to upgrade and benefit from the performance gains, higher availability, greater scalability, and rich BI capabilities that SQL Server 2014 and 2016 offer.<\/span><\/p>\n

Reasons to Upgrade to 2014 or 2016<\/b><\/span><\/p>\n

Breakthrough in-memory performance:\u00a0SQL 2016 is 13x faster than 2005.\u00a0That\u2019s like challenging Usain Bolt to a game of \u201cbeat you there,” and expecting to win. Not going to happen. SQL 2005 crawls compared to what the current database can provide. Plus, SQL 2016\u2019s additional in-memory OLTP delivers up to 30x more in performance.<\/span><\/p>\n

High Availability:\u00a0<\/b>SQL 2014\/2016 includes HA and disaster recovery with SQL AlwaysOn.<\/span><\/p>\n

Security:\u00a0<\/b>Per the \u201cNational Institute of Standards and Technology,\u201d SQL 2014\/2016 was recognized as being the most compliant database with the least amount of security vulnerabilities for the past 6 years in a row.<\/span><\/p>\n

Scalability:<\/b>\u00a0SQL 2014\/2016 is scalable across computer, networking, and storage with Windows Server 2016 and has virtualization and live migration support.<\/span><\/p>\n

Support:<\/b>\u00a0Since SQL 2005 will not have any support (hence this blog) there will be support if you upgrade to the latest edition. With 2014\/2016 SQL Server, the support includes security patching and maintenance updates, and eliminates the expense of custom support agreements.<\/span><\/p>\n

Another thing to consider is compliance, as it can be problematic for SQL Server 2005 just like it was when Microsoft ended support for Windows 2003. HIPAA and PCI compliance both require up-to-date patch databases, just like they do with the operating system. So, if you\u2019re using SQL Server 2005 for anything related to HIPAA or PCI, you will be out of compliance in April.<\/span><\/p>\n

If you\u2019re looking to migrate from SQL 2005, the licensing has certainly changed over the past several years. SQL 2016 is the latest edition, however with backward compatibility rights, previous editions can be run like SQL 2014 and SQL 2012. SQL is offered in two editions: Standard and Enterprise (https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-editions<\/span><\/a>) and is sold as a Per Server\/Cal or by the Core.\u00a0<\/span><\/p>\n

If you need any assistance migrating from SQL 2005, GreenPages has a team of experts who can help. Talk to your account manager or call us at 800-989-2989 and we\u2019ll set up a time to discuss!<\/span><\/p>\n

If you have any more questions, email us!<\/a><\/p>\n

\n<\/img><\/a> <\/img><\/a> <\/img><\/a> <\/img><\/a>\n<\/div>\n

\"\"\/<\/p>\n","protected":false},"excerpt":{"rendered":"

It’s an end of a great era some may say…SQL 2005 is going End of Support. It’s like finally selling that old Dodge Durango you had since college, or throwing away that T-shirt with a whole bunch of holes in it. It’s a sad day when you finally must say goodbye. The year 2005 brought some amazing… Read more »<\/a><\/p>\n","protected":false},"author":61,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[179,51,181],"tags":[],"class_list":["post-28093","post","type-post","status-publish","format-standard","hentry","category-featured","category-microsoft","category-miscellaneous-it"],"_links":{"self":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/28093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/comments?post=28093"}],"version-history":[{"count":1,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/28093\/revisions"}],"predecessor-version":[{"id":28094,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/28093\/revisions\/28094"}],"wp:attachment":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/media?parent=28093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/categories?post=28093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/tags?post=28093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}