{"id":14021,"date":"2015-09-02T09:40:00","date_gmt":"2015-09-02T16:40:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/"},"modified":"2024-01-22T22:50:17","modified_gmt":"2024-01-23T06:50:17","slug":"introducing-sql-server-2016-community-technology-preview-2-3","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/","title":{"rendered":"Introducing: SQL Server 2016 Community Technology Preview 2.3"},"content":{"rendered":"<p>The <a title=\"SQL Server 2016 Community Technology Preview (CTP) 2.3\" href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">SQL Server 2016 Community Technology Preview (CTP) 2.3<\/a> is now available for download!\u00a0This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to <a title=\"SQL Azure Database\" href=\"http:\/\/azure.microsoft.com\/en-us\/marketplace\/partners\/microsoft\/sqlserver2016ctp2evaluationwindowsserver2012r2\/\">SQL Azure Database<\/a> service first, running in production prior to the release build.<\/p>\n<p>In SQL Server 2016 CTP 2.3, part of our new rapid preview model, we made enhancements to several features. You can try them now in your SQL Server 2016 development and test environments.<\/p>\n<p>As part of our new rapid release model, you don\u2019t have to wait several months for responses to feedback or to test new capabilities. This means you can accelerate testing and time to production.\u00a0The frequent updates are also engineered to be of the same quality as major CTPs, so you don\u2019t have to be concerned about build quality. You also have the flexibility to choose which CTPs you will deploy for development and test environments and won\u2019t be forced to upgrade to the most recent preview release.<\/p>\n<p>In SQL Server 2016 CTP 2.3, <a title=\"available for download today\" href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">available for download today<\/a>, you will see enhancements in several key areas:<\/p>\n<ul>\n<li>Row Level Security support for in-memory OLTP tables<\/li>\n<li>A core engine scalability improvement, dynamically partitioning thread safe memory objects by NUMA or CPU, which enables higher scalability<\/li>\n<li>In-memory data warehouse (column store) performance optimizations<\/li>\n<li>Many-to-many derived hierarchies in Master Data Services<\/li>\n<li>Several performance improvements to SQL Server Analysis Services, including DAX query performance<\/li>\n<li>Enhancements to Reporting Services, including an updated Report Builder with a modern theme and report rendering for modern browsers<\/li>\n<\/ul>\n<p>CTP 2.3 also has improvements to the SQL Server Integration Service, Query Execution, and DBCC CHECKDB.<\/p>\n<p>For additional details, please visit the detailed <a title=\"SQL Server 2016 CTP 2.3 Engineering post\" href=\"\/sqlserver\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/\">SQL Server 2016 CTP 2.3 Engineering post<\/a>.<\/p>\n<p><strong>Download SQL Server 2016 CTP 2.3 preview today!<\/strong><\/p>\n<p>As the foundation of our end-to-end data platform, SQL Server 2016 is the biggest leap forward in Microsoft&#8217;s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and both on-premises and in the cloud.<\/p>\n<p>To learn more about the release, visit the <a title=\"SQL Server 2016 preview page\" href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/default.aspx\">SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, <\/a><a title=\"download the preview\" href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">download the preview<\/a> or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.<\/p>\n<p>Have questions? Join the discussion of the new SQL Server 2016 capabilities at <a title=\"MSDN\" href=\"https:\/\/social.msdn.microsoft.com\/Forums\/sqlserver\/en-US\/home?forum=SQLServer2016Preview\">MSDN<\/a> and <a title=\"Stack Overflow\" href=\"http:\/\/stackoverflow.com\/search?q=sql+server+2016\">Stack Overflow<\/a>. If you run into an issue or would like to make a suggestion, you can let us know at <a title=\"Connect\" href=\"https:\/\/connect.microsoft.com\/SQLServer\">Connect<\/a>. We look forward to hearing from you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server 2016 Community Technology Preview (CTP) 2.3 is now available for download!\u00a0This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build. In SQL Server 2016 CTP 2.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-14021","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Introducing: SQL Server 2016 Community Technology Preview 2.3 - 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\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing: SQL Server 2016 Community Technology Preview 2.3 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The SQL Server 2016 Community Technology Preview (CTP) 2.3 is now available for download!\u00a0This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build. In SQL Server 2016 CTP 2.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/\" \/>\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-09-02T16:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:17+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\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Introducing: SQL Server 2016 Community Technology Preview 2.3\",\"datePublished\":\"2015-09-02T16:40:00+00:00\",\"dateModified\":\"2024-01-23T06:50:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/\"},\"wordCount\":430,\"commentCount\":1,\"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\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/\",\"name\":\"Introducing: SQL Server 2016 Community Technology Preview 2.3 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-09-02T16:40:00+00:00\",\"dateModified\":\"2024-01-23T06:50:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing: SQL Server 2016 Community Technology Preview 2.3\"}]},{\"@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":"Introducing: SQL Server 2016 Community Technology Preview 2.3 - 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\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/","og_locale":"en_US","og_type":"article","og_title":"Introducing: SQL Server 2016 Community Technology Preview 2.3 - Microsoft SQL Server Blog","og_description":"The SQL Server 2016 Community Technology Preview (CTP) 2.3 is now available for download!\u00a0This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build. In SQL Server 2016 CTP 2.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-09-02T16:40:00+00:00","article_modified_time":"2024-01-23T06:50:17+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\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Introducing: SQL Server 2016 Community Technology Preview 2.3","datePublished":"2015-09-02T16:40:00+00:00","dateModified":"2024-01-23T06:50:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/"},"wordCount":430,"commentCount":1,"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\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/","name":"Introducing: SQL Server 2016 Community Technology Preview 2.3 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-09-02T16:40:00+00:00","dateModified":"2024-01-23T06:50:17+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/introducing-sql-server-2016-community-technology-preview-2-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Introducing: SQL Server 2016 Community Technology Preview 2.3"}]},{"@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"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14021","targetHints":{"allow":["GET"]}}],"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=14021"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14021\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=14021"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=14021"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=14021"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=14021"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=14021"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=14021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}