{"id":4676,"date":"2019-02-26T01:54:36","date_gmt":"2019-02-26T06:54:36","guid":{"rendered":"https:\/\/tsisupport.com\/?p=4676"},"modified":"2021-08-09T05:54:05","modified_gmt":"2021-08-09T09:54:05","slug":"databases-need-upgrades-too-what-the-impending-sql-eol-means-to-you","status":"publish","type":"post","link":"https:\/\/tsisupport.com\/tsistaging\/?p=4676","title":{"rendered":"SQL Best Practices: What the Impending SQL 2008 End of Life Means For You"},"content":{"rendered":"<p>By now, you&#8217;re undoubtedly aware that Microsoft will stop supporting their Windows 7 operating system on January 14, 2020. Much has been written about the need to upgrade to something more updated before that time, as you not only run the risk of compatibility issues with your critical applications and systems, but inaction will also expose your business to a wide range of security threats that you would do well to avoid at all costs. While upgrading from Windows 7 before 2020 is certainly important, it&#8217;s not the only &#8220;end of life&#8221; situation that you have to concern yourself with as Microsoft also recently announced that SQL Server 2008 would also be hitting its &#8220;end of life&#8221; date for extended support on July 8, 2019. At TSI, we&#8217;ve been working with SQL databases for years and based on that experience, we think that this may very well be the next &#8220;ticking time bomb&#8221; for your business in a number of critical ways that are absolutely worth a closer look.<\/p>\n<p><span style=\"color: #800000;\"><strong>The Dangers of SQL EOL: What You Need to Know<\/strong><\/span><\/p>\n<p>The major problem with running an outdated and unsupported version of SQL has to do with the fact that you&#8217;re exposing your business to a wide range of different security issues during an era where, even if you&#8217;ve purchased extended support, nobody is actively providing critical system updates to your database in a way that will protect you from the countless new vulnerabilities discovered every day. Unfortunately, you\u2019re only as good as your last update and getting hit with some type of attack or other disaster that takes your entire organization offline becomes far more likely than not.<\/p>\n<p>Unfortunately, most organizations who stay with an outdated version of SQL do so because they&#8217;re running a critical line of business application that requires this soon to be EOL version of SQL. Not only does it harm your overall productivity, but it again puts you in danger of becoming the victim of an attack during a time where you cannot afford it.<\/p>\n<p>But even going beyond that, and to reiterate the importance of basic \u2018IT hygiene\u2019, the situation with SQL would be fairly troublesome even without EOL quickly approaching. According to Ntirety&#8217;s recent &#8220;Disruptive Epidemic Report,&#8221; 90% of Microsoft SQL databases already fail disaster recovery reviews, 88% fail configuration reviews, and 40% fail security reviews. Most alarmingly however is that, another 39% fail database backup reviews &#8211; all of which pointing to a situation that needs to be addressed as quickly as possible.<\/p>\n<p><span style=\"color: #800000;\"><strong>What You Can Do About It<\/strong><\/span><\/p>\n<p>First, you need to upgrade SQL to a version that will continue to offer you the support you can depend on moving forward and thankfully, you can get a Microsoft Technology preview of SQL Server 2016 right now.<\/p>\n<p>But once that upgrade is complete, and in order to minimize any future, unanticipated expenditures, you&#8217;ll also need to change the way you&#8217;re thinking about your network infrastructure \u2013 notably in regard to SQL- and its relationship to the ongoing health of your business. Consider bringing in qualified third-party vendors to make sure that everything &#8220;under the hood&#8221; of your business is operating in accordance with all industry best practices or compliance requirements and that you\u2019re prepared well in advance to any significant changes such as the EOL of SQL 2008<\/p>\n<p>In addition to this, also try to establish processes to proactively keep your databases current and make both patching and security the priorities the situation demands them to be. If your own staff is consistently falling behind on your database patching cycles, you will again become unnecessarily susceptible to cyber threats that an otherwise rigid patching cycle would ultimately fix; unfortunately, today\u2019s reality dictates that you\u2019re only as secure as your latest security update.<\/p>\n<p>Last but not least, follow all change management procedures, including properly testing applications before putting them into production. Tips like these won&#8217;t just improve your chances of getting through SQL&#8217;s upcoming &#8220;end of life&#8221; unscathed &#8211; they&#8217;ll also make sure that you come out in an even stronger position on the other side of this process.<\/p>\n<p><span style=\"color: #800000;\"><strong>The Collaborative Approach to IT is Your Most Important Asset of All<\/strong><\/span><\/p>\n<p>In the end, the impending &#8220;end of life&#8221; status for SQL serves as yet another reminder of not just the importance of basic IT resources forecasting, and basic \u2018IT hygiene\u2019 but also working collaboratively with your IT team as much as possible. As small business owners ourselves, there&#8217;s nothing we hate more than surprises, which is why we always go out of our way to minimize them as much as possible, mitigating any impact stemming from IT on your business as well.<\/p>\n<div style=\"padding-top: 10px; padding-bottom: 20px;\"><div class=\"fl-builder-content fl-builder-content-8692 fl-builder-template fl-builder-row-template fl-builder-global-templates-locked\" data-post-id=\"8692\"><div class=\"fl-row fl-row-full-width fl-row-bg-color fl-node-5ecf3c25b8953 fl-row-default-height fl-row-align-center BlogCTA\" data-node=\"5ecf3c25b8953\">\n\t<div class=\"fl-row-content-wrap\">\n\t\t\t\t\t\t\t\t<div class=\"fl-row-content fl-row-fixed-width fl-node-content\">\n\t\t\n<div class=\"fl-col-group fl-node-5ecf3c25b98b3 fl-col-group-equal-height fl-col-group-align-center fl-col-group-custom-width fl-col-group-responsive-reversed\" data-node=\"5ecf3c25b98b3\">\n\t\t\t<div class=\"fl-col fl-node-5ecf3c25b9d26 fl-col-bg-color fl-col-small-custom-width\" data-node=\"5ecf3c25b9d26\">\n\t<div class=\"fl-col-content fl-node-content\"><div class=\"fl-module fl-module-heading fl-node-5ecf3ca3f20c0\" data-node=\"5ecf3ca3f20c0\">\n\t<div class=\"fl-module-content fl-node-content\">\n\t\t<h2 class=\"fl-heading\">\n\t\t<span class=\"fl-heading-text\">Want to Make Sure that SQL's Upcoming EOL Doesn't Catch You off Guard?<\/span>\n\t<\/h2>\n\t<\/div>\n<\/div>\n<div class=\"fl-module fl-module-rich-text fl-node-5ecf3cd2e4782\" data-node=\"5ecf3cd2e4782\">\n\t<div class=\"fl-module-content fl-node-content\">\n\t\t<div class=\"fl-rich-text\">\n\t<p>Feel free to give us a call or click the button below to schedule your free, no obligation call. It'll give us a chance to help you put together the right plan so that we can address this and other important issues as the strategic IT partner you've been looking for.<\/p>\n<\/div>\n\t<\/div>\n<\/div>\n<div class=\"fl-module fl-module-button fl-node-5ecf3ce3079f5\" data-node=\"5ecf3ce3079f5\">\n\t<div class=\"fl-module-content fl-node-content\">\n\t\t<div class=\"fl-button-wrap fl-button-width-auto fl-button-left\">\n\t\t\t<a href=\"https:\/\/tsisupport.com\/tsistaging\/contact\/\"  target=\"_self\"  class=\"fl-button\" >\n\t\t\t\t\t\t\t<span class=\"fl-button-text\">Get in touch with tsi<\/span>\n\t\t\t\t\t<\/a>\n<\/div>\n\t<\/div>\n<\/div>\n<\/div>\n<\/div>\n\t\t\t<div class=\"fl-col fl-node-5ecf3c8493959 fl-col-bg-color fl-col-small fl-col-small-custom-width\" data-node=\"5ecf3c8493959\">\n\t<div class=\"fl-col-content fl-node-content\"><div class=\"fl-module fl-module-photo fl-node-5ecf3d26ac5e3\" data-node=\"5ecf3d26ac5e3\">\n\t<div class=\"fl-module-content fl-node-content\">\n\t\t<div role=\"figure\" class=\"fl-photo fl-photo-align-right\" itemscope itemtype=\"https:\/\/schema.org\/ImageObject\">\n\t<div class=\"fl-photo-content fl-photo-img-png\">\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" class=\"fl-photo-img wp-image-8691 size-full\" src=\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/SQL-file-icon.png\" alt=\"SQL-file-icon\" height=\"510\" width=\"384\" title=\"SQL-file-icon\"  itemprop=\"image\" srcset=\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/SQL-file-icon.png 384w, https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/SQL-file-icon-226x300.png 226w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t<\/div>\n<\/div>\n<\/div>\n<\/div>\n\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n<\/div><div class=\"uabb-js-breakpoint\" style=\"display: none;\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>By now, you&#8217;re undoubtedly aware that Microsoft will stop supporting their Windows 7 operating system on January 14, 2020. Much has been written about the need to upgrade to something more updated before that time, as you not only run the risk of compatibility issues with your critical applications and systems, but inaction will also&hellip;<\/p>\n","protected":false},"author":7,"featured_media":8690,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[20],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Best Practices | SQL 2008 End of Life | TSI<\/title>\n<meta name=\"description\" content=\"Learn what the SQL 2008 end of life process means for your business. Discover how you can keep your data secure by updating your SQL.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Best Practices | SQL 2008 End of Life | TSI\" \/>\n<meta property=\"og:description\" content=\"Learn what the SQL 2008 end of life process means for your business. Discover how you can keep your data secure by updating your SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tsisupport.com\/tsistaging\/?p=4676\" \/>\n<meta property=\"og:site_name\" content=\"TSI Support\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-26T06:54:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-09T09:54:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1140\" \/>\n\t<meta property=\"og:image:height\" content=\"380\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeremy Louise\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeremy Louise\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=4676\",\"url\":\"https:\/\/tsisupport.com\/tsistaging\/?p=4676\",\"name\":\"SQL Best Practices | SQL 2008 End of Life | TSI\",\"isPartOf\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=4676#primaryimage\"},\"image\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=4676#primaryimage\"},\"thumbnailUrl\":\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg\",\"datePublished\":\"2019-02-26T06:54:36+00:00\",\"dateModified\":\"2021-08-09T09:54:05+00:00\",\"author\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/48ad37aeeae9afb7d52479029f14f926\"},\"description\":\"Learn what the SQL 2008 end of life process means for your business. Discover how you can keep your data secure by updating your SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=4676#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/tsisupport.com\/tsistaging\/?p=4676\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=4676#primaryimage\",\"url\":\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg\",\"contentUrl\":\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg\",\"width\":1140,\"height\":380},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=4676#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/tsisupport.com\/tsistaging\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Best Practices: What the Impending SQL 2008 End of Life Means For You\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#website\",\"url\":\"https:\/\/tsisupport.com\/tsistaging\/\",\"name\":\"TSI Support\",\"description\":\"TSI - Technical Support International\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/tsisupport.com\/tsistaging\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/48ad37aeeae9afb7d52479029f14f926\",\"name\":\"Jeremy Louise\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a1c4b01ee6c09554d8f086ff657b1a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e2a1c4b01ee6c09554d8f086ff657b1a?s=96&d=mm&r=g\",\"caption\":\"Jeremy Louise\"},\"url\":\"https:\/\/tsisupport.com\/tsistaging\/?author=7\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Best Practices | SQL 2008 End of Life | TSI","description":"Learn what the SQL 2008 end of life process means for your business. Discover how you can keep your data secure by updating your SQL.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"SQL Best Practices | SQL 2008 End of Life | TSI","og_description":"Learn what the SQL 2008 end of life process means for your business. Discover how you can keep your data secure by updating your SQL.","og_url":"https:\/\/tsisupport.com\/tsistaging\/?p=4676","og_site_name":"TSI Support","article_published_time":"2019-02-26T06:54:36+00:00","article_modified_time":"2021-08-09T09:54:05+00:00","og_image":[{"width":1140,"height":380,"url":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg","type":"image\/jpeg"}],"author":"Jeremy Louise","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jeremy Louise","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/tsisupport.com\/tsistaging\/?p=4676","url":"https:\/\/tsisupport.com\/tsistaging\/?p=4676","name":"SQL Best Practices | SQL 2008 End of Life | TSI","isPartOf":{"@id":"https:\/\/tsisupport.com\/tsistaging\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tsisupport.com\/tsistaging\/?p=4676#primaryimage"},"image":{"@id":"https:\/\/tsisupport.com\/tsistaging\/?p=4676#primaryimage"},"thumbnailUrl":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg","datePublished":"2019-02-26T06:54:36+00:00","dateModified":"2021-08-09T09:54:05+00:00","author":{"@id":"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/48ad37aeeae9afb7d52479029f14f926"},"description":"Learn what the SQL 2008 end of life process means for your business. Discover how you can keep your data secure by updating your SQL.","breadcrumb":{"@id":"https:\/\/tsisupport.com\/tsistaging\/?p=4676#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tsisupport.com\/tsistaging\/?p=4676"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tsisupport.com\/tsistaging\/?p=4676#primaryimage","url":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg","contentUrl":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2019\/02\/databases-1140x380-1.jpg","width":1140,"height":380},{"@type":"BreadcrumbList","@id":"https:\/\/tsisupport.com\/tsistaging\/?p=4676#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tsisupport.com\/tsistaging\/"},{"@type":"ListItem","position":2,"name":"SQL Best Practices: What the Impending SQL 2008 End of Life Means For You"}]},{"@type":"WebSite","@id":"https:\/\/tsisupport.com\/tsistaging\/#website","url":"https:\/\/tsisupport.com\/tsistaging\/","name":"TSI Support","description":"TSI - Technical Support International","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tsisupport.com\/tsistaging\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/48ad37aeeae9afb7d52479029f14f926","name":"Jeremy Louise","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e2a1c4b01ee6c09554d8f086ff657b1a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e2a1c4b01ee6c09554d8f086ff657b1a?s=96&d=mm&r=g","caption":"Jeremy Louise"},"url":"https:\/\/tsisupport.com\/tsistaging\/?author=7"}]}},"_links":{"self":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/posts\/4676"}],"collection":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4676"}],"version-history":[{"count":0,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/posts\/4676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/media\/8690"}],"wp:attachment":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}