{"id":2378,"date":"2016-06-01T17:37:34","date_gmt":"2016-06-01T16:37:34","guid":{"rendered":"http:\/\/andreas-wolter.com\/sql-server-2016-allgemeine-verfuegbarkeit-und-feature-support\/"},"modified":"2017-10-18T10:50:47","modified_gmt":"2017-10-18T09:50:47","slug":"sql-server-2016-general-availability-and-feature-support","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/sql-server-2016-general-availability-and-feature-support\/","title":{"rendered":"SQL Server 2016 general availability and Feature-Support"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-4d8c009e4b5dbd9641714d1a55684b1f\">\n#top .av-special-heading.av-av_heading-4d8c009e4b5dbd9641714d1a55684b1f{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-4d8c009e4b5dbd9641714d1a55684b1f .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-4d8c009e4b5dbd9641714d1a55684b1f .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-4d8c009e4b5dbd9641714d1a55684b1f av-special-heading-h3 blockquote modern-quote  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >SQL Server 2016 general availability and Feature-Support <\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/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>Finally: The new SQL Server 2016, in my eyes the best release since many, if not ever, is generally available. (See <a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/06\/01\/sql-server-2016-is-generally-available-today\/\" target=\"_blank\" rel=\"noopener\">Blog article by Joseph Sirosh, Corporate Vice President, Data Group, Microsoft<\/a>)<\/p>\n<p>The <strong>Built-Number<\/strong> is <strong>12.0.1601.5<\/strong>.<!--more--><\/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-66caf0db60a7d4ab7c8e0da2baadca38\">\n.avia-image-container.av-av_image-66caf0db60a7d4ab7c8e0da2baadca38 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-66caf0db60a7d4ab7c8e0da2baadca38 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-66caf0db60a7d4ab7c8e0da2baadca38 av-styling- avia-align-center  avia-builder-el-2  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-2373 avia-img-lazy-loading-not-2373 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1606_SQL-Server-2016-RTM-Built.png\" alt='' title='1606_SQL-Server-2016-RTM-Built'  height=\"93\" width=\"800\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1606_SQL-Server-2016-RTM-Built.png 800w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1606_SQL-Server-2016-RTM-Built-600x70.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1606_SQL-Server-2016-RTM-Built-300x35.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1606_SQL-Server-2016-RTM-Built-768x89.png 768w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1606_SQL-Server-2016-RTM-Built-705x82.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1606_SQL-Server-2016-RTM-Built-450x52.png 450w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/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>One can download the respective version (Enterprise, Standard, Web, Developer, Express \u2013 the Business Intelligence Edition ceases to exist) at MSDN. The Developer Edition is even free of charge by now (<a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/03\/31\/microsoft-sql-server-developer-edition-is-now-free\/\" target=\"_blank\" rel=\"noopener\">Blog-Article on that<\/a>).<\/p>\n<p><strong>Download-Link:<\/strong><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/subscriptions\/downloads\/#searchTerm=&#038;ProductFamilyId=650&#038;Languages=en\" target=\"_blank\" rel=\"noopener\">https:\/\/msdn.microsoft.com\/en-us\/subscriptions\/downloads\/#searchTerm=&#038;ProductFamilyId=650&#038;Languages=en<\/a><\/p>\n<p>I wrote about the new <strong>Database-Engine-Features<\/strong> before here: <a href=\"http:\/\/www.insidesql.org\/blogs\/andreaswolter\/2015\/05\/sql-server-2016-the-security-and-performance-release\" target=\"_blank\" rel=\"noopener\"><strong>SQL Server 2016 \u2013 the Security &#038; Performance Release<\/strong><\/a><\/p>\n<p>Here a look at the <strong>Features Supported by the Editions of SQL Server 2016:<\/strong><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/cc645993.aspx\" target=\"_blank\" rel=\"noopener\">msdn.microsoft.com\/en-us\/library\/cc645993.aspx<\/a><\/p>\n<p>I want to highlight that the rumors about the support of Availability Groups in Standard Edition have been proven true and so-called \u201e<strong>Basic Availability Groups<\/strong>\u201c with support of 2 nodes and one replica per AG \u2013 similar to Database Mirroring \u2013 can be used there.<\/p>\n<p>In the Security area \u201e<strong>Row-level Security<\/strong>\u201c and also \u201e<strong>Data Masking<\/strong>\u201c made it into Standard Edition, but \u201e<strong>Always Encrypted<\/strong>\u201c did not \u2013 this feature is only available in Enterprise-Edition.<\/p>\n<p>The much-praised \u201e<strong>Query Store<\/strong>\u201c is available in all Editions(!) <em>(\u201cThank you, Connor\u201d)<\/em>,as are \u201e<strong>Temporal Tables<\/strong>\u201c, and <strong>JSON<\/strong>. \u201e<strong>R<\/strong>\u201c is available only as a \u201eBasic-variation\u201c generally available, \u201e<strong>Stretch Database<\/strong>\u201c on the other hand in all in Editions.<\/p>\n<p>\u201e<strong>In-Memory OLTP<\/strong>\u201c and \u201e<strong>Operational Analytics<\/strong>\u201c unfortunately remain reserved for Enterprise-Edition.<\/p>\n<p>It should be pointed out that from the BI components the <strong>Analysis Services Tabular-Mode<\/strong> is now available in Standard Edition as well. This is very helpful as this type makes a lot of sense especially in small Projects.<\/p>\n<p>You can find the official Page on SQL Server 2016 with further information and links to Whitepapers here: <a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server\/\" target=\"_blank\" rel=\"noopener\">www.microsoft.com\/en-us\/server-cloud\/products\/sql-server\/<\/a><\/p>\n<\/div><\/section>\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>Enjoy the next generation of Microsofts Data Platform Flagship: SQL Server 2016<\/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-general-availability-and-feature-support\/&#038;t=SQL%20Server%202016%20general%20availability%20and%20Feature-Support\" 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%20general%20availability%20and%20Feature-Support&#038;url=https:\/\/andreas-wolter.com\/en\/?p=2378\" 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%20general%20availability%20and%20Feature-Support&#038;url=https:\/\/andreas-wolter.com\/en\/sql-server-2016-general-availability-and-feature-support\/\" 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":"Finally: The new SQL Server 2016, in my eyes the best release since many, if not ever, is generally available. (See Blog article by Joseph Sirosh, Corporate Vice President, Data Group, Microsoft) The Built-Number is 12.0.1601.5.","protected":false},"author":4,"featured_media":2405,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[96],"class_list":["post-2378","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server-2016","tag-sql-server-2016-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2378","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=2378"}],"version-history":[{"count":6,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2378\/revisions"}],"predecessor-version":[{"id":2472,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2378\/revisions\/2472"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/2405"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=2378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=2378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=2378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}