{"id":3291,"date":"2015-05-31T15:29:57","date_gmt":"2015-05-31T14:29:57","guid":{"rendered":"http:\/\/andreas-wolter.com\/sql-server-2016-ein-sicherheits-und-performance-release\/"},"modified":"2017-10-18T17:18:27","modified_gmt":"2017-10-18T16:18:27","slug":"sql-server-2016-the-security-performance-release","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/sql-server-2016-the-security-performance-release\/","title":{"rendered":"SQL Server 2016 \u2013 the Security &#038; Performance Release"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-d5122d2952265d0da1ede6647c77a589\">\n#top .av-special-heading.av-av_heading-d5122d2952265d0da1ede6647c77a589{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-d5122d2952265d0da1ede6647c77a589 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-d5122d2952265d0da1ede6647c77a589 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-d5122d2952265d0da1ede6647c77a589 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 \u2013 the Security <span class='special_amp'>&amp;<\/span> Performance Release<\/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>The news broke in early May: That\u2019s when Satya Nadella <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2015\/05\/04\/sql-server-2016-public-preview-coming-this-summer.aspx\" target=\"_blank\" rel=\"noopener\">presented <strong>SQL Server 2016<\/strong><\/a> at the <em>Microsoft Ignite<\/em>-Conference in Chicago. I can already say that SQL Server 2016 will be one of the most exciting releases in recent years. And that\u2019s because this time it\u2019s clearly focused on <strong>security<\/strong>. Next to performance features, security features are among the \u201cKey Capabilities\u201d of the upcoming SQL Server. I like to call SQL Server 2016 a \u201cSecurity &#038; Performance-Release.\u201d<!--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-0d50daf166180322098fcfe74bf1254a\">\n.avia-image-container.av-av_image-0d50daf166180322098fcfe74bf1254a img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-0d50daf166180322098fcfe74bf1254a .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-0d50daf166180322098fcfe74bf1254a 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-3272 avia-img-lazy-loading-not-3272 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016.png\" alt='' title='1505_SQL2016_Key_Innovations_SQL_Server_2016'  height=\"771\" width=\"1375\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016.png 1375w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016-600x336.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016-300x168.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016-768x431.png 768w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016-1030x578.png 1030w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016-705x395.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Key_Innovations_SQL_Server_2016-450x252.png 450w\" sizes=\"(max-width: 1375px) 100vw, 1375px\" \/><\/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>Its <strong>key features<\/strong> are:<\/p>\n<p><strong>Always Encrypted<\/strong><\/p>\n<p>With this feature it is finally possible to offer encrypted data where SQL Server itself does not have access to the data in unencrypted form and where the database administrator is incapable of decrypting the data. The key is held within the very application where the encryption and decryption takes place. Up to now encryption\/decryption was only possible if users developed solutions on their own.<\/p>\n<p><strong>Stretch Database<\/strong><\/p>\n<p><em>Stretched Tables<\/em> offer the option to store data in a given table both On-Premise and in the Cloud. Similar to partitioning, part of the data will be swapped to Microsoft Azure, transparently to the application, and only accessed when necessary. Here it might be advisable to avoid causing index-scans to the cloud with badly designed queries.<\/p>\n<p>To protect the data, <em>Stretched Tables<\/em> also work together with <em>Always Encrypted<\/em>. It remains to be seen, how this feature affects the inhibition to give data to the cloud. Microsoft itself surely has no interest to make access to its systems simple for intelligence, and <em>Always Encrypted <\/em>should be a clear signal.<\/p>\n<p><strong>Real-time Operational Analytics &#038; In-Memory OLTP<\/strong><\/p>\n<p>Under this feature lies the marriage of the two \u201eperformance-killer\u201c features <em>Columnstore Indexes<\/em> \u2013 for OLAP-Scenarios \u2013 and <em>Memory Optimized Tables <\/em>for <em>In-Memory OLTP<\/em>. This enables for fast analytical queries on the fresh OLTP data in <em>In-Memory<\/em>. In my eyes this feature is the ultimate killer, since indexes on the tables have to be synchronous and not, like at some other vendors of In-Memory databases, only receive the data after a certain delay. <a href=\"https:\/\/twitter.com\/sarpedonquality\/status\/530057795970678784\" target=\"_blank\" rel=\"noopener\">At PASS Summit 2014 this features was already biefly<\/a><u> presented<\/u>, but only now it is official and has a name.<\/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-60d0c9ff98816a5618c3fb47e41a60c3\">\n.avia-image-container.av-av_image-60d0c9ff98816a5618c3fb47e41a60c3 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-60d0c9ff98816a5618c3fb47e41a60c3 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-60d0c9ff98816a5618c3fb47e41a60c3 av-styling- avia-align-center  avia-builder-el-4  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-3274 avia-img-lazy-loading-not-3274 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL_2016_Rowstore_Table_ColumStore_Index_HotData_In-Memory_OLTP_Index.png\" alt='' title='1505_SQL_2016_Rowstore_Table_ColumStore_Index_HotData_In-Memory_OLTP_Index'  height=\"186\" width=\"307\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL_2016_Rowstore_Table_ColumStore_Index_HotData_In-Memory_OLTP_Index.png 307w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL_2016_Rowstore_Table_ColumStore_Index_HotData_In-Memory_OLTP_Index-300x182.png 300w\" sizes=\"(max-width: 307px) 100vw, 307px\" \/><\/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>Those were the highlights, but the list of further new features is still long and highly potential. I am trying to list the most important ones:<\/p>\n<p><strong>Improvements to Columnstore Indexes<\/strong><\/p>\n<ul>\n<li>Single-threaded queries can use batch mode<\/li>\n<li>AlwaysOn readable secondary support updateable columnstore indexes<\/li>\n<li>Columnstore indexes possible on memory-optimized table \u2013 only works in InterOP mode<\/li>\n<li>Filtered Nonclustered Columnstore Indexes<\/li>\n<li>Support for primary and foreign keys<\/li>\n<\/ul>\n<p><strong>Improvements for In-Memory OLTP<\/strong><\/p>\n<ul>\n<li>ALTER and ALTER Procedure Operations\n<ul>\n<li>i.e. to change the bucket counts of hash indexes<\/li>\n<\/ul>\n<\/li>\n<li>Multithreaded Writes and Merge-process<\/li>\n<li>parallel plans<\/li>\n<li>foreign keys on In-Memory tables<\/li>\n<li>many more improvements in terms of T-SQL Support<\/li>\n<\/ul>\n<p><strong>And further new Security-Features:<\/strong><\/p>\n<p><strong>Dynamic Data Masking<\/strong><\/p>\n<p>Based on Policies allow to define that depending on the user certain data is only shown masked.<\/p>\n<p><strong>Row-Level Security<\/strong><\/p>\n<p>Row-Level Security (RLS) is, to be exact, a feature to greatly simplify the development of row-based access-control, and move from the application into the database. In the current implementation it is still quite easy, to get via <em>Side-Channel Attacks <\/em>to the data. Therefore, as always when designing for security, one has to have an eye on all parts of the application.<\/p>\n<p>Why a truly secure row-based access control is far from trivial, one can find out among others in this blog-post of me:<\/p>\n<ul>\n<li><a href=\"https:\/\/andreas-wolter.com\/en\/sql-server-row-and-cell-level-security-disclosure-vulnerability\/\">SQL Server Row- and Cell-Level Security \u2013 Disclosure vulnerability <\/a><\/li>\n<\/ul>\n<p><strong>Further features in different areas:<\/strong><\/p>\n<p><strong>PolyBase<\/strong><\/p>\n<p>Querying of relational and non-relational data in Hadoop-Clusters with T-SQL via so-called <strong><em>External Tables<\/em>.<\/strong><\/p>\n<p><strong>Query Store<\/strong><\/p>\n<p>This feature has been presented several times at different conferences by Conor Cunningham. Now it is finally coming into the product. Once activated, it automatically captures queries together with their plans and runtime statistics, thus allowing for later review of them. Added to that one can easily re-use an identified query plan.<\/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-14e231cf4f847f6c5b9f809f0b9b8d44\">\n.avia-image-container.av-av_image-14e231cf4f847f6c5b9f809f0b9b8d44 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-14e231cf4f847f6c5b9f809f0b9b8d44 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-14e231cf4f847f6c5b9f809f0b9b8d44 av-styling- avia-align-center  avia-builder-el-6  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-3277 avia-img-lazy-loading-not-3277 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Query_Store_Report.png\" alt='' title='1505_SQL2016_Query_Store_Report'  height=\"569\" width=\"987\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Query_Store_Report.png 987w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Query_Store_Report-600x346.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Query_Store_Report-300x173.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Query_Store_Report-768x443.png 768w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Query_Store_Report-705x406.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Query_Store_Report-450x259.png 450w\" sizes=\"(max-width: 987px) 100vw, 987px\" \/><\/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><strong>Live Query Statistics<\/strong><\/p>\n<p>In SQL Server 2016 query plans \u201ecome to live\u201c. This is illustrated best with a picture\/video:<\/p>\n<p><a href=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/SQL_Server_2016_Live_Query_Statistics.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3278\" src=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/SQL_Server_2016_Live_Query_Statistics.gif\" alt=\"\" width=\"880\" height=\"280\" \/><\/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><strong>Temporal Tables<\/strong><\/p>\n<p>With Temporal Tables data is automatically versioned and available for later querying based on time-span of validity. Similar to how one often designs oneself manually for Slowly Changing Dimensions\/SCDs in Datawarehouses.<\/p>\n<p><a href=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Menue_External_SystemVersioned_Table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3280\" src=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Menue_External_SystemVersioned_Table.png\" alt=\"\" width=\"474\" height=\"137\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Menue_External_SystemVersioned_Table.png 474w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Menue_External_SystemVersioned_Table-300x87.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_Menue_External_SystemVersioned_Table-450x130.png 450w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/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><strong>Trace Flag 4199<\/strong>, which is relevant for all SQL Server Installations since SQL Server 2005 SP3 CU 6, since it enables certain fixes of the query processor is supposedly mainly unnecessary for SQL Server 2016. Let\u2019s wait for details for a final judgement.<\/p>\n<p><strong>Multiple Tempdb Data Files<\/strong><\/p>\n<p>Already at Setup one has to specify how many TempDB data files will be created. By default the number of cores with a maximum of 8 will be used. BY that that also less experienced administrators will become aware of <em>Latch-Contention<\/em> in Tempdb, and an important Best Practice is applied by default.<\/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-4f7d0311de887c83cfa7eead6fe5e4fe\">\n.avia-image-container.av-av_image-4f7d0311de887c83cfa7eead6fe5e4fe img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-4f7d0311de887c83cfa7eead6fe5e4fe .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-4f7d0311de887c83cfa7eead6fe5e4fe av-styling- avia-align-center  avia-builder-el-10  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-3283 avia-img-lazy-loading-not-3283 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL206_Setup_Tempdb_Files.png\" alt='' title='1505_SQL206_Setup_Tempdb_Files'  height=\"362\" width=\"666\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL206_Setup_Tempdb_Files.png 666w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL206_Setup_Tempdb_Files-600x326.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL206_Setup_Tempdb_Files-300x163.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL206_Setup_Tempdb_Files-450x245.png 450w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/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><strong>High Availability<\/strong><\/p>\n<ul>\n<li>3 synchronous replicas<\/li>\n<li>Support for <em>Group Managed Service Accounts<\/em> for AlwaysOn Failover Cluster<\/li>\n<li>AlwaysOn Availability Groups support Distributed Transactions and DTC on <strong>Windows Server 2016<\/strong><\/li>\n<li>AlwaysOn Availability Group Failover on Database Offline<\/li>\n<li>ReadOnly Replicas can be addressed in Round-Robin-manner<\/li>\n<\/ul>\n<p><strong>T-SQL<\/strong><\/p>\n<ul>\n<li>Formatting of Query Resultsets as JSON \u2013 similar to XML. And maybe it will stay niched in a similar manner. Here one should think of the, expensive CPU-licences compared to an Applikation-Server<\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-6c532adafba27490bfbf305fb0859d34\">\n.avia-image-container.av-av_image-6c532adafba27490bfbf305fb0859d34 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-6c532adafba27490bfbf305fb0859d34 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-6c532adafba27490bfbf305fb0859d34 av-styling- avia-align-center  avia-builder-el-12  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-3285 avia-img-lazy-loading-not-3285 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_JSON_Query_Result.png\" alt='' title='1505_SQL2016_JSON_Query_Result'  height=\"304\" width=\"763\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_JSON_Query_Result.png 763w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_JSON_Query_Result-600x239.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_JSON_Query_Result-300x120.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_JSON_Query_Result-705x281.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_JSON_Query_Result-450x179.png 450w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/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\" ><ul>\n<li>TRUNCATE TABLE on partition Level<\/li>\n<li>ALTER COLUMN and many more DDL-commands can now happen online<\/li>\n<li>New Query Hints MIN_GRANT_PERCENT and MAX_GRANT_PERCENT<\/li>\n<li>Transparent Data Encryption supports Intel <em>AES-NI <\/em>Hardware Acceleration Instruction Sets<\/li>\n<li>With the purchase of <em>Revolution Analytics<\/em> the programming language <strong><em>R<\/em><\/strong> shall be integrated into SQL Server 2016, to start special analytical queries directly from within the database \u2013 also see my 2<sup>nd<\/sup> comment on JSON for that<\/li>\n<\/ul>\n<p><strong>Analysis Services<\/strong><\/p>\n<ul>\n<li>Parallel Processing for multiple Table Partitions in Tabular Models<\/li>\n<li>New DAX Functions<\/li>\n<\/ul>\n<p><strong>Integration Services<\/strong><\/p>\n<ul>\n<li>AlwaysOn-support for SSIS-DB<\/li>\n<li>Incremental Deployment of packages<\/li>\n<\/ul>\n<p><strong>Reporting Services<\/strong><\/p>\n<p>Reporting Services will finally get CSS-Stylesheets \u2013 for that we waited a long long time. (With that finally my often used <a href=\"http:\/\/www.insidesql.org\/blogs\/andreaswolter\/2011\/03\/standardizing-and-centralizing-report-design-part-1-the-possibilities\" target=\"_blank\" rel=\"noopener\">Technique with SQL-Tables<\/a> will become obsolete) Also the Report parameters will be improved and support Hierarchies and get Autocomplete.<\/p>\n<p>Further:<\/p>\n<ul>\n<li>High DPI (Dots Per Inch) Scaling and devices for better resolution of report elements<\/li>\n<li>Various minor improvements for subscriptions<\/li>\n<\/ul>\n<p><strong>Master Data Services<\/strong><\/p>\n<p>In essence: Performance improvements through data compression and a new Super User-concept<\/p>\n<p><strong>Further:<\/strong><\/p>\n<ul>\n<li><strong>\u201eOngoing preview updates\u201c <\/strong>\u2013 behind this term lies the possibility, to receive new functionalities online without new installations after the installation of CTP2<\/li>\n<li><strong>Azure SQL Data Warehouse <\/strong>The Analytics Platform System (APS), formerly Parallel Datawarehouse (PDW) is now available via Azure! &#8211; <a href=\"http:\/\/azure.microsoft.com\/en-us\/campaigns\/sql-data-warehouse\/\" target=\"_blank\" rel=\"noopener\">azure.microsoft.com\/en-us\/campaigns\/sql-data-warehouse\/<\/a><\/li>\n<li>With the <a href=\"https:\/\/blogs.microsoft.com\/blog\/2015\/04\/14\/microsoft-acquires-mobile-business-intelligence-leader-datazen\/\" target=\"_blank\" rel=\"noopener\">aquisition of DataZen <\/a>it will be possible to serve reports which are optimized for mobile devices<\/li>\n<\/ul>\n<p><strong>SQL Server 2016 CTP2<\/strong><\/p>\n<p>The CTP2 of the upcoming SQL Server, which already contains many of the features I introduced here, is available for download since May 27<sup>th<\/sup> here:<\/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><a href=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_CTP2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3286\" src=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_CTP2.png\" alt=\"\" width=\"490\" height=\"324\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_CTP2.png 490w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_CTP2-300x198.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/1505_SQL2016_CTP2-450x298.png 450w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/default.aspx\" target=\"_blank\" rel=\"noopener\">www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/default.aspx<\/a><\/p>\n<p><strong>Further Readings: <\/strong><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn876712%28v=sql.130%29.aspx\" target=\"_blank\" rel=\"noopener\"><strong>SQL Server 2016 Release Notes<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb510411%28v=sql.130%29.aspx\" target=\"_blank\" rel=\"noopener\"><strong>What&#8217;s New in Database Engine<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb522628%28v=sql.130%29.aspx\" target=\"_blank\" rel=\"noopener\"><strong>What&#8217;s New in Analysis Services<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb522534%28v=sql.130%29.aspx\" target=\"_blank\" rel=\"noopener\"><strong>What&#8217;s New in Integration Services<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms170438%28v=sql.130%29.aspx\" target=\"_blank\" rel=\"noopener\"><strong>What&#8217;s New in Reporting Services<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ff929136%28v=sql.130%29.aspx\" target=\"_blank\" rel=\"noopener\"><strong>What&#8217;s New in Master Data Services<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/www.nikoport.com\/2015\/05\/27\/columnstore-indexes-part-54-thoughts-on-upcoming-improvements-in-sql-server-2016\/\" target=\"_blank\" rel=\"noopener\"><strong>Columnstore Indexes \u2013 part 54 (\u201cThoughts on upcoming improvements in SQL Server 2016\u2033)<\/strong><\/a><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>I am personally very excited about this upcoming release and hope you are looking forward to it, too.<\/p>\n<p>Andreas<\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-15  el_after_av_textblock  el_before_av_one_full '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\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-16  el_after_av_hr  el_before_av_social_share  first flex_column_div av-zero-column-padding  '     ><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='av-social-sharing-box av-av_social_share-8644d330ffb238fff0cfa858c5295467 av-social-sharing-box-default  avia-builder-el-18  el_after_av_one_full  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-the-security-performance-release\/&#038;t=SQL%20Server%202016%20%E2%80%93%20the%20Security%20%26%20Performance%20Release\" 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%20%E2%80%93%20the%20Security%20%26%20Performance%20Release&#038;url=https:\/\/andreas-wolter.com\/en\/?p=3291\" 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%20%E2%80%93%20the%20Security%20%26%20Performance%20Release&#038;url=https:\/\/andreas-wolter.com\/en\/sql-server-2016-the-security-performance-release\/\" 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-19  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":"The news broke in early May: That\u2019s when Satya Nadella presented SQL Server 2016 at the Microsoft Ignite-Conference in Chicago. I can already say that SQL Server 2016 will be one of the most exciting releases in recent years. And that\u2019s because this time it\u2019s clearly focused on security. Next to performance features, security features [&hellip;]","protected":false},"author":4,"featured_media":3684,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,46,57,45],"tags":[25,27,202,96],"class_list":["post-3291","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-columnstore-index","category-in-memory-oltpxtp-htap","category-security-en","category-sql-server-2016","tag-in-memory-en","tag-security-en","tag-sql-server-2016-en-2","tag-sql-server-2016-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/3291","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=3291"}],"version-history":[{"count":5,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/3291\/revisions"}],"predecessor-version":[{"id":3296,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/3291\/revisions\/3296"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/3684"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=3291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=3291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=3291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}