{"id":13661,"date":"2015-06-24T10:00:00","date_gmt":"2015-06-24T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/"},"modified":"2024-01-22T22:50:13","modified_gmt":"2024-01-23T06:50:13","slug":"sql-server-2016-community-technology-preview-2-1-is-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/","title":{"rendered":"SQL Server 2016 Community Technology Preview 2.1 is available"},"content":{"rendered":"

Following the release of SQL Server 2016 CTP 2.0<\/a> last month, the SQL Server engineering team is excited to announce the immediate availability of CTP 2.1 release for download<\/a>. The release includes improvements for three new innovations releasing in SQL Server 2016 – Stretch Database, Query Store, Temporal – and Columnstore Index, introduced in SQL Server 2012:<\/p>\n

    \n
  1. \nStretch<\/b> Database, <\/b>which enables transparent stretching of warm and cold OLTP data to Microsoft Azure in a secure manner without requiring any application changes, includes the following fixes:<\/p>\n
      \n
    1. Data migration does not trigger lock escalation in stretched tables, so no timeouts for INSERT or SELECT operations<\/li>\n
    2. Automatic encryption and validation requirement of remote server certification, preventing \u201cman-in-the-middle\u201d security attacks<\/li>\n
    3. Ability to run INSERT statement against updatable views created on top of stretch tables<\/li>\n<\/ol>\n<\/li>\n
    4. \nQuery Store<\/b>, the \u201cflight recorder\u201d which stores historical query plans and their performance characteristics, allowing DBAs to monitor and analyze plans and force a specific query plan on regression, includes:<\/p>\n
        \n
      1. Parse statistics avg_parse_duration, last_parse_duration, avg_parse_cpu_time, last_parse_cpu_time removed from sys.query_store_query view<\/li>\n
      2. The minimally allowed for flush_interval_seconds parameter, 60 seconds, is now verified in ALTER DATABASE statement<\/li>\n
      3. Naming in sys.database_query_store_options and actual parameters in ALTER statements are in alignment with flush_interval_seconds and operation_mode<\/li>\n
      4. Query Store on master and tempdb disabled and error message thrown (“Cannot perform action because Query Store cannot be enabled on system database master (tempdb)”)<\/li>\n
      5. Force_failure_count parameter is now cleared after plan is enforced<\/li>\n<\/ol>\n<\/li>\n
      6. \nTemporal<\/b>, which enables handling and analyzing database records that changes over time, includes:<\/p>\n
          \n
        1. Support for computed columns<\/li>\n
        2. Support for marking one or both period columns with HIDDEN flag, allowing for frictionless migration for existing applications. The following applies to HIDDEN period columns:\n
            \n
          1. \n
              \n
            1. Column is not returned in SELECT * statements<\/li>\n
            2. INSERT statement without column list <\/i>do not expect inputs for HIDDEN columns<\/li>\n
            3. Hidden column must be explicitly included in all queries that directly reference temporal table or other objects that reference temporal table (views, for example)<\/li>\n
            4. BULK INSERT scripts that worked with non-temporal table (prior to adding system-versioning and hidden period columns) will continue to work and hidden columns will be auto-populated<\/li>\n
            5. is_hidden flag is set to 1 in sys.columns view<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

              \n<\/li>\n<\/ol>\n<\/li>\n

            6. \nColumnstore Index <\/b>includes:<\/b><\/p>\n
                \n
              1. Improved seek performance<\/li>\n
              2. Improved scan performance with partitioned tables<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                \u00a0<\/p>\n

                \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

                Following the release of SQL Server 2016 CTP 2.0 last month, the SQL Server engineering team is excited to announce the immediate availability of CTP 2.1 release for download. The release includes improvements for three new innovations releasing in SQL Server 2016 – Stretch Database, Query Store, Temporal – and Columnstore Index, introduced in SQL<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-13661","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates"],"yoast_head":"\nSQL Server 2016 Community Technology Preview 2.1 is available - Microsoft SQL Server Blog<\/title>\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.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 Community Technology Preview 2.1 is available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Following the release of SQL Server 2016 CTP 2.0 last month, the SQL Server engineering team is excited to announce the immediate availability of CTP 2.1 release for download. The release includes improvements for three new innovations releasing in SQL Server 2016 – Stretch Database, Query Store, Temporal – and Columnstore Index, introduced in SQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-24T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2016 Community Technology Preview 2.1 is available\",\"datePublished\":\"2015-06-24T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\"},\"wordCount\":393,\"commentCount\":9,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\",\"name\":\"SQL Server 2016 Community Technology Preview 2.1 is available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-06-24T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 Community Technology Preview 2.1 is available\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2016 Community Technology Preview 2.1 is available - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Community Technology Preview 2.1 is available - Microsoft SQL Server Blog","og_description":"Following the release of SQL Server 2016 CTP 2.0 last month, the SQL Server engineering team is excited to announce the immediate availability of CTP 2.1 release for download. The release includes improvements for three new innovations releasing in SQL Server 2016 – Stretch Database, Query Store, Temporal – and Columnstore Index, introduced in SQL","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-06-24T17:00:00+00:00","article_modified_time":"2024-01-23T06:50:13+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2016 Community Technology Preview 2.1 is available","datePublished":"2015-06-24T17:00:00+00:00","dateModified":"2024-01-23T06:50:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/"},"wordCount":393,"commentCount":9,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/","name":"SQL Server 2016 Community Technology Preview 2.1 is available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-06-24T17:00:00+00:00","dateModified":"2024-01-23T06:50:13+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 Community Technology Preview 2.1 is available"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13661"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=13661"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13661\/revisions"}],"predecessor-version":[{"id":49680,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13661\/revisions\/49680"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=13661"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=13661"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=13661"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=13661"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=13661"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=13661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}