{"id":1959,"date":"2016-11-16T10:02:48","date_gmt":"2016-11-16T09:02:48","guid":{"rendered":"http:\/\/andreas-wolter.com\/?p=1959\/"},"modified":"2017-10-17T18:33:16","modified_gmt":"2017-10-17T17:33:16","slug":"sql-server-2016-sp1-removes-feature-limits","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/sql-server-2016-sp1-removes-feature-limits\/","title":{"rendered":"SQL Server 2016 SP1 removes the editions\u2019 programming feature limits!"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-17962a2ddf4584fba26f2d856d8d845a\">\n#top .av-special-heading.av-av_heading-17962a2ddf4584fba26f2d856d8d845a{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-17962a2ddf4584fba26f2d856d8d845a .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-17962a2ddf4584fba26f2d856d8d845a .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-17962a2ddf4584fba26f2d856d8d845a av-special-heading-h3 blockquote modern-quote  avia-builder-el-0  el_before_av_hr  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >SQL Server 2016 SP1 removes the editions\u2019 programming feature limits! <\/h3><div class='av-subheading av-subheading_below'><p>Everything from Always Encrypted to XTP\/In-memory for everybody!<\/p>\n<\/div><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-1  el_after_av_heading  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>These are just sublime news, there is no other way to put it:<\/p>\n<p>With the <strong>Service Pack 1 for SQL Server 2016<\/strong> released today, <strong>Microsoft puts an end to the <u>programming-technical differences<\/u> between the editions<\/strong> (LocalDB, Express, Standard, Web, Enterprise)!<\/p>\n<p>As of today, EVERYONE who is already working on SQL Server 2016 can create In-Memory optimized tables, partition tables, use Columnstore Indexes and so forth.<!--more--><\/p>\n<p>And as if that weren\u2019t enough, the SP1 itself also includes many more valuable features such as \u201cDatabase Clones,\u201d \u201cCREATE OR ALTER\u201d syntax, many new diagnosis improvements (Showplan, XEvents, DMVs, Errorlog) and more (<a href=\"https:\/\/blogs.msdn.microsoft.com\/sqlreleaseservices\/sql-server-2016-service-pack-1-sp1-released\/\" target=\"_blank\" rel=\"noopener\">read more<\/a>).<\/p>\n<p>Wow, just wow\u2026 the possibilities thus offered to customers are unbelievable. Gone are the days when you had to make sure not to deploy any Enterprise features such as Compression or Database level auditing on standard editions. Finally, there is the option to accelerate even small systems, which are still extremely latency-critical, with memory objects (assembly-line scenarios).<\/p>\n<p><strong>The <\/strong><a href=\"http:\/\/www.insidesql.org\/blogs\/andreaswolter\/2016\/07\/the-sql-server-2016-in-memory-evolution-from-row-store-to-columnstore-to-in-memory-operational-analytics\" target=\"_blank\" rel=\"noopener\"><strong>In-Memory Revolution<\/strong><\/a><strong> is now available to everybody!<\/strong><\/p>\n<p>Before you ask how, then, the editions will differ:<\/p>\n<p>What will remain in place is that the larger editions simply support more hardware. The limits of 16 Cores and 128 GB RAM for the standard edition and even less for Express will remain the same. That is and remains key.<\/p>\n<p>But I definitely need to think of a new line: In the past, I always used to say: \u201cIn order to decide whether a feature is Enterprise it suffices to know if it\u2019s \u2018cool\u2019 (e.g. Database Snapshot) or \u2018quick\u2019 (e.g. Columnstore).\u201d<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-1be93a4fda356b78fca274bb274bd2d3\">\n.avia-image-container.av-av_image-1be93a4fda356b78fca274bb274bd2d3 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-1be93a4fda356b78fca274bb274bd2d3 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-1be93a4fda356b78fca274bb274bd2d3 av-styling- avia-align-center  avia-builder-el-3  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-1960 avia-img-lazy-loading-not-1960 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/08\/1611_SQLServer2016_Servicepack1_Programmability_Features_Comparison.png\" alt='' title='1611_SQLServer2016_Servicepack1_Programmability_Features_Comparison'  height=\"450\" width=\"753\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/08\/1611_SQLServer2016_Servicepack1_Programmability_Features_Comparison.png 753w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/08\/1611_SQLServer2016_Servicepack1_Programmability_Features_Comparison-600x359.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/08\/1611_SQLServer2016_Servicepack1_Programmability_Features_Comparison-300x179.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/08\/1611_SQLServer2016_Servicepack1_Programmability_Features_Comparison-705x421.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/08\/1611_SQLServer2016_Servicepack1_Programmability_Features_Comparison-450x269.png 450w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>As of today, the following applies: it is the size that makes the difference.<\/p>\n<p>But before someone gets me wrong: <strong>There are definitely still features that remain exclusive to the Enterprise edition<\/strong>. The emphasis was on the programming features. Mere HA features such as multiple secondaries, and certain security features such as TDE, remain exclusive to the Enterprise edition. Some of it also remains limited in technical terms. For Change Data Capture, for example, you do not have an SQL agent in the Express edition. And of course, a Columnstore Index hardly makes sense if a table does not even contain 1 million rows.<\/p>\n<p>But that shouldn\u2019t cut down on the joy.<\/p>\n<p>Here, you can <strong>download the<\/strong> <strong>Microsoft\u00ae SQL Server\u00ae 2016 Service Pack 1 (SP1):<\/strong><\/p>\n<p><a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=54276\" target=\"_blank\" rel=\"noopener\">www.microsoft.com\/en-us\/download\/details.aspx?id=54276<\/a><\/p>\n<p>And here some more links about the changes with Service Pack 1:<\/p>\n<p><a href=\"https:\/\/blogs.msdn.microsoft.com\/sqlrsteamblog\/2016\/11\/16\/whats-new-in-sql-server-2016-sp1-for-reporting-services\/\" target=\"_blank\" rel=\"noopener\"><strong>What\u2019s new in SQL Server 2016 SP1 for Reporting Services<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-editions\" target=\"_blank\" rel=\"noopener\"><strong>SQL Server 2016 SP1 editions<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.linkedin.com\/pulse\/microsoft-changes-feature-support-between-editions-sql-victor-isakov\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft Changes Feature Support Between Editions in SQL Server 2016 Service Pack 1<\/strong><\/a> (Article by my good fellow Victor Isakov, MCM and MCA from Australia with nice background details)<\/p>\n<p>Have fun with the SP1 and trying the newly available Features.<\/p>\n<p>And if you now feel like reading isn\u2019t enough but you would like to acquire in-depth knowledge or finally upgrade to the current SQL Server Version, you are in good hands with <a href=\"http:\/\/www.sarpedonqualitylab.com\/\" target=\"_blank\" rel=\"noopener\">Sarpedon Quality Lab<\/a>\u00ae.<\/p>\n<p>Andreas Wolter<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-97c650ae075063b375f558a776c570f8\">\n#top .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n.flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n.responsive #top #wrap_all .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-97c650ae075063b375f558a776c570f8 av_one_full  avia-builder-el-5  el_after_av_textblock  el_before_av_hr  first flex_column_div av-zero-column-padding  column-top-margin'     ><section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><div><\/div>\n<div><\/div>\n<\/div><\/section><\/div>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-7  el_after_av_one_full  el_before_av_social_share '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-social-sharing-box av-av_social_share-8644d330ffb238fff0cfa858c5295467 av-social-sharing-box-default  avia-builder-el-8  el_after_av_hr  el_before_av_hr  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Share<\/h5><ul class=\"av-share-box-list noLightbox\"><li class='av-share-link av-social-link-facebook' ><a target=\"_blank\" aria-label=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https:\/\/andreas-wolter.com\/en\/sql-server-2016-sp1-removes-feature-limits\/&#038;t=SQL%20Server%202016%20SP1%20removes%20the%20editions%E2%80%99%20programming%20feature%20limits%21\" aria-hidden=\"false\" data-av_icon=\"\ue8f3\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Facebook\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-twitter' ><a target=\"_blank\" aria-label=\"Share on Twitter\" href=\"https:\/\/twitter.com\/share?text=SQL%20Server%202016%20SP1%20removes%20the%20editions%E2%80%99%20programming%20feature%20limits%21&#038;url=https:\/\/andreas-wolter.com\/en\/?p=1959\" aria-hidden=\"false\" data-av_icon=\"\ue8f1\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Twitter\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Twitter<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin' ><a target=\"_blank\" aria-label=\"Share on LinkedIn\" href=\"https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=SQL%20Server%202016%20SP1%20removes%20the%20editions%E2%80%99%20programming%20feature%20limits%21&#038;url=https:\/\/andreas-wolter.com\/en\/sql-server-2016-sp1-removes-feature-limits\/\" aria-hidden=\"false\" data-av_icon=\"\ue8fc\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on LinkedIn\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on LinkedIn<\/span><\/a><\/li><\/ul><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-4474f20d2389e2e5ecf918a02da5132e\">\n#top .hr.hr-invisible.av-av_hr-4474f20d2389e2e5ecf918a02da5132e{\nheight:50px;\n}\n<\/style>\n<div  class='hr av-av_hr-4474f20d2389e2e5ecf918a02da5132e hr-invisible  avia-builder-el-9  el_after_av_social_share  el_before_av_comments_list '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-buildercomment av-av_comments_list-88ce68e426f11248fa394058a3de040f  av-blog-meta-author-disabled av-blog-meta-html-info-disabled'><\/div>","protected":false},"excerpt":{"rendered":"These are just sublime news, there is no other way to put it: With the Service Pack 1 for SQL Server 2016 released today, Microsoft puts an end to the programming-technical differences between the editions (LocalDB, Express, Standard, Web, Enterprise)! As of today, EVERYONE who is already working on SQL Server 2016 can create In-Memory [&hellip;]","protected":false},"author":4,"featured_media":2187,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,46,45],"tags":[75,96],"class_list":["post-1959","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-columnstore-index","category-in-memory-oltpxtp-htap","category-sql-server-2016","tag-service-pack","tag-sql-server-2016-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/1959","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=1959"}],"version-history":[{"count":9,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/1959\/revisions"}],"predecessor-version":[{"id":3672,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/1959\/revisions\/3672"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/2187"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=1959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=1959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=1959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}