{"id":2382,"date":"2019-04-12T16:15:36","date_gmt":"2019-04-12T16:15:36","guid":{"rendered":"https:\/\/www.crossjoin.pt\/?p=2382"},"modified":"2019-04-12T16:15:36","modified_gmt":"2019-04-12T16:15:36","slug":"sql-server-2008-r2-end-of-lifecycle-support","status":"publish","type":"post","link":"https:\/\/crossjoin.com\/pt\/sql-server-2008-r2-end-of-lifecycle-support\/","title":{"rendered":"SQL Server 2008\/R2 End of Lifecycle Support"},"content":{"rendered":"<p>[vc_row type=&#8221;in_container&#8221; full_screen_row_position=&#8221;middle&#8221; scene_position=&#8221;center&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; overlay_strength=&#8221;0.3&#8243;][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; width=&#8221;1\/1&#8243; tablet_text_alignment=&#8221;default&#8221; phone_text_alignment=&#8221;default&#8221;]<hr class=\"no_line\" style=\"margin: 0 auto 0px auto\"\/>\n[vc_column_text]<\/p>\n<h6><span style=\"color: #ff0000;\"><span style=\"color: #999999;\">by<\/span> Andr\u00e9 Batista\u00a0<\/span><span style=\"color: #999999;\">\/<\/span> <span style=\"color: #999999;\">Microsoft Delivery Manager (I.M.S.)<\/span><\/h6>\n<p><span style=\"font-weight: 400;\">As you have probably heard SQL Server 2008 and SQL Server 2008 R2 will go out of extended support by Microsoft in July 2019. You should start preparing a plan in order to migrate all your SQL Servers with these versions to new ones, like SQL Server 2016 or SQL Server 2017. However, SQL Server 2019 is just around the corner and you may also wait for it to get released.\u00a0<\/span><span style=\"font-weight: 400;\">Some of our customers, still run and maintain SQL Server 2008\\R2. and here are the main reasons for that:<\/span><\/p>\n<p><b>SQL Server 2008 is stable<\/b><span style=\"font-weight: 400;\"> &#8211; As one old man said&#8230; &#8221; if it&#8217;s good and running, please do not touch or change anything&#8221;&#8230;<\/span><\/p>\n<p><b>Cost of upgrades\\complexity<\/b><span style=\"font-weight: 400;\"> &#8211; On some applications and infrastructure it can be a problem to migrate to new versions, and the effort you need to do it is not enough to just migrate your application.<\/span><\/p>\n<p><b>Legacy and application compatibility<\/b><span style=\"font-weight: 400;\"> &#8211; For the most part, when you are maintaining legacy software, you need not only to upgrade your databases, but also upgrade your Operating System and some other layers like Service Brokers or specific Middleware.<\/span><\/p>\n<p><b>Lack of skills<\/b><span style=\"font-weight: 400;\"> &#8211; Some business lack in-house knowledge and don&#8217;t even try to find a solution since &#8230; everything is working!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Main risks if you still choose to be on an unsupported version:<\/span><\/p>\n<p><b>Compliance<\/b><span style=\"font-weight: 400;\"> &#8211; Nowadays, more companies focus on industry standards and regulations regarding security. With the GDPR and PCI DSS in place, the organization requires to be running and use supported platforms. Non-compliance organizations may have legal or financial problems in the business.<\/span><\/p>\n<p><b>Security <\/b><span style=\"font-weight: 400;\">&#8211; Once SQL Server 2008 and SQL Server 2008 R2 move out of extended support, they will no longer receive security updates. This is pretty bad since you will be exposed to cyber attacks or even ransomware exploits.<\/span><\/p>\n<p><b>Unable to use new features<\/b><span style=\"font-weight: 400;\"> &#8211; Like the security updates, Microsoft will no longer release any kind of new feature releases or fix problems identified on the database engine, or on any other component of the Data Platform.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We at Crossjoin Solutions can help you achieve a smooth database migration, making sure that your application still works after the upgrade or even set up a temporary High Availability infrastructure in order to ensure the minimum downtime for your customers.<\/span>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row type=&#8221;in_container&#8221; full_screen_row_position=&#8221;middle&#8221; scene_position=&#8221;center&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; overlay_strength=&#8221;0.3&#8243;][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; width=&#8221;1\/1&#8243; tablet_text_alignment=&#8221;default&#8221; phone_text_alignment=&#8221;default&#8221;][vc_column_text] by Andr\u00e9 Batista\u00a0\/ Microsoft Delivery Manager (I.M.S.) As you have probably heard<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":2,"featured_media":2387,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"rs_blank_template":"","rs_page_bg_color":"","slide_template_v7":"","footnotes":""},"categories":[74,53],"tags":[58],"class_list":["post-2382","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-crossjoin","tag-crossjoin"],"acf":[],"_links":{"self":[{"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/posts\/2382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/comments?post=2382"}],"version-history":[{"count":0,"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/posts\/2382\/revisions"}],"wp:attachment":[{"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/media?parent=2382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/categories?post=2382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crossjoin.com\/pt\/wp-json\/wp\/v2\/tags?post=2382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}