{"id":3171,"date":"2017-10-23T12:54:30","date_gmt":"2017-10-23T12:54:30","guid":{"rendered":"http:\/\/www.gigxp.com\/?p=3171"},"modified":"2020-04-13T07:02:20","modified_gmt":"2020-04-13T07:02:20","slug":"sql-server-2017-editions-features-windows-linux","status":"publish","type":"post","link":"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/","title":{"rendered":"SQL Server 2017 Editions &#038; Supported Features on Windows &#038; Linux"},"content":{"rendered":"<p>Microsoft has released SQL Server 2017 Editions to the public for general availability. Its predecessor, <a href=\"http:\/\/www.gigxp.com\/why-is-sql-server-2016-is-faster-than-ever\/\">SQL Server 2016<\/a> has been widely successful. <a href=\"http:\/\/www.gigxp.com\/sql-server-2016-new-features\/\">SQL Server 2016<\/a> was a significant upgrade from SQL Server 2014, and we expect the same with SQL Server 2017.<\/p>\n<p>Even though SQL Server 2017 is released for both Linux and Windows platforms, the editions remain mostly the same. Check them out!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#SQL_Server_2017_Editions\" title=\"SQL Server 2017 Editions\">SQL Server 2017 Editions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#The_SQL_Server_2017_Standard_is_useful_for_mid-segment_customers_running_medium_workloads\" title=\"The SQL Server 2017 Standard is useful for mid-segment customers, running medium workloads.\">The SQL Server 2017 Standard is useful for mid-segment customers, running medium workloads.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#The_SQL_Server_2017_Edition_is_targeted_at_the_top-tier_segment_where_performance_is_critical\" title=\"The SQL Server 2017 Edition is targeted at the top-tier segment where performance is critical.\">The SQL Server 2017 Edition is targeted at the top-tier segment where performance is critical.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"SQL_Server_2017_Editions\"><\/span>SQL Server 2017 Editions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>All the significant editions remain unchanged, which is a good thing. It maintains an easy upgrade path for customers willing to upgrade to the new version without much confusion. It is particularly true for Software Assurance (SA) customers who typically get a free upgrade to the next major release. So here they are!<\/p>\n<ul>\n<li><strong>Enterprise<\/strong>: Comprehensive, high-end capacities for commanding database and business intelligence essentials.<\/li>\n<li><strong>Standard<\/strong>: Core data management and business intelligence abilities for non-critical workloads with minimal IT support.<\/li>\n<li><strong>Express<\/strong>: Easy to get started, unrestricted to use for ISV redistribution and embedding.<\/li>\n<li><strong>Developer<\/strong>: Free (for MSDN subscribers) version where customers can build, test, and demo apps in non-production environments. All Enterprise Editions are included as usual.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"The_SQL_Server_2017_Standard_is_useful_for_mid-segment_customers_running_medium_workloads\"><\/span>The SQL Server 2017 Standard is useful for mid-segment customers, running medium workloads.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Some of the most notable features are as follows:<\/p>\n<ul>\n<li>End-to-end database security with Always Encrypted<\/li>\n<li>Enhanced in-memory performance<br \/>\nfor all workloads<\/li>\n<li>Basic reporting<\/li>\n<li>Basic analytics<\/li>\n<li>Hybrid scenarios: Stretch Database, backup<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"The_SQL_Server_2017_Edition_is_targeted_at_the_top-tier_segment_where_performance_is_critical\"><\/span>The SQL Server 2017 Edition is targeted at the top-tier segment where performance is critical.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here are some of its features:<\/p>\n<ul>\n<li>Mission critical high availability on both Windows and Linux based servers.<\/li>\n<li>Enhanced in-memory performance for both OLTP and Data warehousing workloads.<\/li>\n<li>Faster performance with &#8216;<strong>Adaptive-Query<\/strong>&#8216; Processing<\/li>\n<li>Unmatched data security<\/li>\n<li>Petabyte-scale data warehousing scalability.<\/li>\n<li>End-to-end mobile BI with rich visualizations available on all major platforms including iOS and Android.<\/li>\n<li>In-database advanced analytics built-in at scale with R and Python<\/li>\n<li>Enhanced hybrid scenarios including<\/li>\n<li>Stretch Database, HA, DR, and backup<\/li>\n<li>Software Assurance (SA) benefits include unlimited virtualization, Machine Learning (ML) Server for Hadoop, and Power BI Report Server<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>SQL Server 2017 Editions for both Linux and Windows is a massive shift for Microsoft. We expect many Enterprise\u00a0customers to jump on the SQL Server bandwagon with this release.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has released SQL Server 2017 Editions to the public for general availability. Its predecessor, SQL Server 2016 has been widely successful. SQL Server 2016 was a significant upgrade from SQL Server 2014, and we expect the same with SQL Server 2017. Even though SQL Server 2017 is released for both Linux and Windows platforms, the editions remain mostly the same. Check them out! SQL Server 2017 Editions All the significant editions remain unchanged, which is a good thing. It maintains an easy upgrade path for customers willing to upgrade to the new version without much confusion. It is particularly [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3172,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server 2017 Editions &amp; Supported Features on Windows &amp; Linux<\/title>\n<meta name=\"description\" content=\"Want to know the new SQL Server 2017 Editions and supported features? With 2017 Edition, comes Linux and docket support. Find them out here.\" \/>\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.gigxp.com\/sql-server-2017-editions-features-windows-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2017 Editions &amp; Supported Features on Windows &amp; Linux\" \/>\n<meta property=\"og:description\" content=\"Want to know the new SQL Server 2017 Editions and supported features? With 2017 Edition, comes Linux and docket support. Find them out here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Gig XP\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/Face-of-it-501680523211743\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-23T12:54:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-13T07:02:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.gigxp.com\/wp-content\/uploads\/2017\/10\/Adobe-Spark-71.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"IG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@faceofit1\" \/>\n<meta name=\"twitter:site\" content=\"@FaceofIT1\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"IG\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/\",\"url\":\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/\",\"name\":\"SQL Server 2017 Editions & Supported Features on Windows & Linux\",\"isPartOf\":{\"@id\":\"https:\/\/www.gigxp.com\/#website\"},\"datePublished\":\"2017-10-23T12:54:30+00:00\",\"dateModified\":\"2020-04-13T07:02:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d\"},\"description\":\"Want to know the new SQL Server 2017 Editions and supported features? With 2017 Edition, comes Linux and docket support. Find them out here.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gigxp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2017 Editions &#038; Supported Features on Windows &#038; Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gigxp.com\/#website\",\"url\":\"https:\/\/www.gigxp.com\/\",\"name\":\"Gig XP\",\"description\":\"The Enterprise Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gigxp.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d\",\"name\":\"IG\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g\",\"caption\":\"IG\"},\"sameAs\":[\"http:\/\/faceofit.com\",\"https:\/\/twitter.com\/faceofit1\"],\"url\":\"https:\/\/www.gigxp.com\/author\/indro13\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2017 Editions & Supported Features on Windows & Linux","description":"Want to know the new SQL Server 2017 Editions and supported features? With 2017 Edition, comes Linux and docket support. Find them out here.","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.gigxp.com\/sql-server-2017-editions-features-windows-linux\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2017 Editions & Supported Features on Windows & Linux","og_description":"Want to know the new SQL Server 2017 Editions and supported features? With 2017 Edition, comes Linux and docket support. Find them out here.","og_url":"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/","og_site_name":"Gig XP","article_publisher":"http:\/\/www.facebook.com\/Face-of-it-501680523211743","article_published_time":"2017-10-23T12:54:30+00:00","article_modified_time":"2020-04-13T07:02:20+00:00","og_image":[{"width":2560,"height":1340,"url":"https:\/\/www.gigxp.com\/wp-content\/uploads\/2017\/10\/Adobe-Spark-71.jpg","type":"image\/jpeg"}],"author":"IG","twitter_card":"summary_large_image","twitter_creator":"@faceofit1","twitter_site":"@FaceofIT1","twitter_misc":{"Written by":"IG","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/","url":"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/","name":"SQL Server 2017 Editions & Supported Features on Windows & Linux","isPartOf":{"@id":"https:\/\/www.gigxp.com\/#website"},"datePublished":"2017-10-23T12:54:30+00:00","dateModified":"2020-04-13T07:02:20+00:00","author":{"@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d"},"description":"Want to know the new SQL Server 2017 Editions and supported features? With 2017 Edition, comes Linux and docket support. Find them out here.","breadcrumb":{"@id":"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.gigxp.com\/sql-server-2017-editions-features-windows-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gigxp.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2017 Editions &#038; Supported Features on Windows &#038; Linux"}]},{"@type":"WebSite","@id":"https:\/\/www.gigxp.com\/#website","url":"https:\/\/www.gigxp.com\/","name":"Gig XP","description":"The Enterprise Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gigxp.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d","name":"IG","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g","caption":"IG"},"sameAs":["http:\/\/faceofit.com","https:\/\/twitter.com\/faceofit1"],"url":"https:\/\/www.gigxp.com\/author\/indro13\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts\/3171"}],"collection":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/comments?post=3171"}],"version-history":[{"count":0,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts\/3171\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/media\/3172"}],"wp:attachment":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/media?parent=3171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/categories?post=3171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/tags?post=3171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}