{"id":5563,"date":"2018-11-19T03:09:19","date_gmt":"2018-11-19T03:09:19","guid":{"rendered":"https:\/\/dbtut.com\/?p=5563"},"modified":"2018-12-06T08:35:44","modified_gmt":"2018-12-06T08:35:44","slug":"which-sql-server-version-i-need-to-use","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/","title":{"rendered":"Which SQL Server Version I Need to Use"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>This is probably one of the trickiest question that as DBA I get, and trust me, it happens very often and the funny thing is, most of the users are coming with an answer, <strong>the newest version<\/strong>!<\/p>\n<p>This is very common considering that lately Microsoft is releasing newer versions of SQL Server in short periods and we always believe that what is new is better, but this may not the right approach.<\/p>\n<p><strong>The very first question that I ask is<\/strong>, what of the new features of the latest version of SQL Server will your application use? Most of the time they don\u2019t know.<\/p>\n<p><strong>Second question is<\/strong>, Enterprise or Standard, we as a DBA probably prefer Enterprise because of the features it has for maintenance tasks, scalability among others, however making this choice is very important in terms of licensing because we know that costs are one of the top elements for this decision.<\/p>\n<p><strong>Third question is related with application<\/strong>, even when we are following the proper testing of the applications and their new features, by that I mean test in DEV, then QA, Pre Prod and finally Production, I always ask if they have a compatibility matrix between the application and the desired SQL Server version, having this document in place will save time and will minimize surprises during the implementation that may incur in rolling back what was done.<\/p>\n<p>Our duty as a DBA is to guide our users to a good decision, and this can be achieved by <strong>understanding what they need<\/strong>, not giving what they want. I\u2019ve found cases in where SQL Server Express fits exactly what the user needs, without having to incur in high amounts of money for a contract or license.<\/p>\n<p>&nbsp;<\/p>\n<h3>Conclusion:<\/h3>\n<p>Newest is not necessarily the best, understanding is the key and will always be the best approach. SQL Server Standard Edition may work perfectly in some cases, and don\u2019t get me wrong, Standard edition is a great product, it has very good features such as multi-instancing (2005+), Delayed Durability (SQL 2014+) among others and will also provide money savings.<\/p>\n<p>Keep up with the great work DBA folks, new exciting things will always happen to us!<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: right;\"><span style=\"font-size: 18pt;\"><em>Julio Arroyo R.<\/em><\/span><br \/>\nOracle and SQL Server Certified<br \/>\nCosta Rica<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5563\" class=\"pvc_stats all  \" data-element-id=\"5563\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; This is probably one of the trickiest question that as DBA I get, and trust me, it happens very often and the funny thing is, most of the users are coming with an answer, the newest version! This is very common considering that lately Microsoft is releasing newer versions of SQL Server in short &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5563\" class=\"pvc_stats all  \" data-element-id=\"5563\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":456,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5563","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Which SQL Server Version I Need to Use - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Which SQL Server Version I Need to Use\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Which SQL Server Version I Need to Use - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Which SQL Server Version I Need to Use\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-19T03:09:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-06T08:35:44+00:00\" \/>\n<meta name=\"author\" content=\"Julio Arroyo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julio Arroyo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/\"},\"author\":{\"name\":\"Julio Arroyo\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/939024c990e475f210aae5340ae040e0\"},\"headline\":\"Which SQL Server Version I Need to Use\",\"datePublished\":\"2018-11-19T03:09:19+00:00\",\"dateModified\":\"2018-12-06T08:35:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/\"},\"wordCount\":385,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/\",\"name\":\"Which SQL Server Version I Need to Use - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-11-19T03:09:19+00:00\",\"dateModified\":\"2018-12-06T08:35:44+00:00\",\"description\":\"Which SQL Server Version I Need to Use\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Which SQL Server Version I Need to Use\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/939024c990e475f210aae5340ae040e0\",\"name\":\"Julio Arroyo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d4654121c17161f1767ab1e9a26765feafebfe4fdaee7a542c7fa6c8ccfd060?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d4654121c17161f1767ab1e9a26765feafebfe4fdaee7a542c7fa6c8ccfd060?s=96&d=mm&r=g\",\"caption\":\"Julio Arroyo\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/julioarroyo\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Which SQL Server Version I Need to Use - Database Tutorials","description":"Which SQL Server Version I Need to Use","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:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/","og_locale":"en_US","og_type":"article","og_title":"Which SQL Server Version I Need to Use - Database Tutorials","og_description":"Which SQL Server Version I Need to Use","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-19T03:09:19+00:00","article_modified_time":"2018-12-06T08:35:44+00:00","author":"Julio Arroyo","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julio Arroyo","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/"},"author":{"name":"Julio Arroyo","@id":"https:\/\/dbtut.com\/#\/schema\/person\/939024c990e475f210aae5340ae040e0"},"headline":"Which SQL Server Version I Need to Use","datePublished":"2018-11-19T03:09:19+00:00","dateModified":"2018-12-06T08:35:44+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/"},"wordCount":385,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/","name":"Which SQL Server Version I Need to Use - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-11-19T03:09:19+00:00","dateModified":"2018-12-06T08:35:44+00:00","description":"Which SQL Server Version I Need to Use","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/19\/which-sql-server-version-i-need-to-use\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Which SQL Server Version I Need to Use"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/939024c990e475f210aae5340ae040e0","name":"Julio Arroyo","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d4654121c17161f1767ab1e9a26765feafebfe4fdaee7a542c7fa6c8ccfd060?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d4654121c17161f1767ab1e9a26765feafebfe4fdaee7a542c7fa6c8ccfd060?s=96&d=mm&r=g","caption":"Julio Arroyo"},"url":"https:\/\/dbtut.com\/index.php\/author\/julioarroyo\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/456"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=5563"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5563\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=5563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=5563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=5563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}