{"id":14011,"date":"2015-09-02T09:40:00","date_gmt":"2015-09-02T16:40:00","guid":{"rendered":""},"modified":"2024-01-22T22:50:17","modified_gmt":"2024-01-23T06:50:17","slug":"sql-server-2016-community-technology-preview-2-3-is-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/","title":{"rendered":"SQL Server 2016 Community Technology Preview 2.3 is available"},"content":{"rendered":"<p>The SQL Server engineering team is pleased to announce the immediate availability of <a title=\"SQL Server 2016\" href=\"\/sqlserver\/2015\/05\/04\/sql-server-2016-public-preview-coming-this-summer\/\">SQL Server 2016<\/a> August monthly public preview release <a title=\"CTP 2.3\" href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">CTP 2.3<\/a>. This 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>To learn more about the release, visit the <a title=\"SQL Server 2016 preview\" href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/default.aspx\">SQL Server 2016 preview page<\/a>. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, <a title=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=398126\" href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=398126\">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. 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>\u00a0and <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 using <a title=\"Microsoft's Connect tool\" href=\"https:\/\/connect.microsoft.com\/SQLServer\">Microsoft\u2019s Connect too<\/a>l. We look forward to hearing from you!<\/p>\n<p>This preview release is packed with new features and improvements&#8230;.<\/p>\n<p><strong>Row Level Security<\/strong> is now supported with <strong>In-memory OLTP<\/strong> tables. Users can now apply row-level security policies to memory-optimized tables. In addition to SCHEMABINDING, predicate functions and inline TVFs should include the compilation hint <span style=\"color: #0000ff;font-family: courier new,courier\">WITH NATIVE_COMPILATION<\/span>. UDFs created with this hint can be used in both native modules and interop queries, and as security predicates on both memory-optimized and disk-based tables. UDFs created without this hint can only be used in interop queries, and as predicates on disk-based tables. The following built-in security functions are supported by In-memory OLTP, intended for use in RLS predicates:<\/p>\n<ul>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">IS_MEMBER<\/span>({<span style=\"color: #ff0000\">\u2018<\/span><span style=\"color: #0000ff\">group<\/span><span style=\"color: #ff0000\">\u2019<\/span> | <span style=\"color: #ff0000\">\u2018<\/span><span style=\"color: #0000ff\">role<\/span><span style=\"color: #ff0000\">\u2019<\/span>})<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">IS_ROLEMEMBER<\/span> (<span style=\"color: #ff0000\">\u2018<\/span><span style=\"color: #0000ff\">role<\/span><span style=\"color: #ff0000\">\u2019<\/span> [, \u2018database_principal\u2019])<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">IS_SRVROLEMEMBER<\/span> (<span style=\"color: #ff0000\">\u2018<\/span><span style=\"color: #0000ff\">role<\/span><span style=\"color: #ff0000\">\u2019<\/span> [, \u2018login\u2019])<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">ORIGINAL_LOGIN<\/span>()<\/span><\/li>\n<li><span style=\"color: #ff00ff;font-family: courier new,courier\">SESSION_USER<\/span><\/li>\n<li><span style=\"color: #ff00ff;font-family: courier new,courier\">CURRENT_USER<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">SUSER_ID<\/span>([\u2018login\u2019])<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">SUSER_SID<\/span>([\u2018login\u2019] [, Param2])<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">SUSER_SNAME<\/span>([server_user_sid])<\/span><\/li>\n<li><span style=\"color: #ff00ff;font-family: courier new,courier\">SYSTEM_USER<\/span><\/li>\n<li><span style=\"color: #ff00ff;font-family: courier new,courier\">SUSER_NAME<\/span><\/li>\n<li><span style=\"color: #0000ff;font-family: courier new,courier\">USER<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">USER_ID<\/span>([\u2018user\u2019])<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">USER_NAME<\/span>([id])<\/span><\/li>\n<li><span style=\"font-family: courier new,courier\"><span style=\"color: #ff00ff\">CONTEXT_INFO<\/span>()<\/span><\/li>\n<\/ul>\n<p>An exciting <strong>Core Engine Scalability<\/strong> improvement is made available in this release &#8211; dynamically partition thread safe memory objects by NUMA node or by CPU. This improvement will enable higher scalability of high concurrency workloads running on NUMA hardware. Thread safe memory objects (of type <strong>CmemThread<\/strong>) will be dynamically promoted to be partitioned by NUMA node or by CPU based on workload characteristics and contention factor. In SQL 2012 and SQL 2014, TF8048 is needed to promote memory objects that are partitioned by node to be partitioned by CPU. This improvement not only eliminated the need for the trace flag, and also dynamically determine partition based on contention.<\/p>\n<p>CTP2.3 includes <strong>In-memory data warehouse (columnStore)<\/strong> performance optimizations, NCCI can now be created on tables with triggers, enabled with CDC\/Change Tracking. For better insight of Column Store, three new fields to the <span style=\"font-family: courier new,courier\"><span style=\"color: #339966\">sys<\/span>.dm_db_column_store_row_group_physical_stats<\/span> dynamic management view:<\/p>\n<table style=\"width: 806px\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"304\">transition_to_compressed_state<\/td>\n<td valign=\"top\" width=\"117\">tinyint<\/td>\n<td valign=\"top\" width=\"385\">\n<p>Operation that caused transition to compressed state<\/p>\n<p>0 =&gt; UNKNOWN_UPGRADED_FROM_PREVIOUS _VERSION<\/p>\n<p>1 =&gt; NOT_APPLICABLE<\/p>\n<p>2 =&gt; INDEX_BUILD<\/p>\n<p>3 =&gt; TUPLE_MOVER<\/p>\n<p>4 =&gt; REORG_NORMAL<\/p>\n<p>5 =&gt; REORG_FORCED<\/p>\n<p>6 =&gt; BULKLOAD<\/p>\n<p>7 =&gt; MERGE<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"304\">transition_to_compressed_state_desc<\/td>\n<td valign=\"top\" width=\"117\">nvarchar(60)<\/td>\n<td valign=\"top\" width=\"385\">\n<p>NOT_APPLICABLE -&gt; It is not applicable for delta store or this compressed rowgroup existed before database upgrade<\/p>\n<p>INDEX_BUILD -&gt; The rowgroup was compressed as part of index create\/rebuild<\/p>\n<p>TUPLE_MOVER =&gt; The rowgroup was compressed as part of background Tuple Mover<\/p>\n<p>REORG_NORMAL =&gt; The closed delta rowgroup was compressed as part of invocation of closed delta rowgroups. One implication is that TM is falling behind<\/p>\n<p>REORG_FORCED =&gt; The open rowgroup was compressed<\/p>\n<p>BULKLOAD -&gt; The rowgroup was compressed as part of bulkload operation<\/p>\n<p>MERGE -&gt; The rowgroup was compressed as part of MERGE operation that compressed one or more compressed rowgroups.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"304\">has_vertipaq_optimization<\/td>\n<td valign=\"top\" width=\"117\">Bit<\/td>\n<td valign=\"top\" width=\"385\">\n<p>Vertipaq optimization is used when rowgroups are compressed into columnar storage to improve compression achieved by rearranging the order of the rows in the row group. This optimization is automatically applied when building column store index or when directly bulk loading data into columnar format or when data transitions from delta store to columnar storage format. However, this optimization is skipped for delta rowgroups when there are one or more NCIs on the column store index to minimize changes needed to maintain mapping index<\/p>\n<p>1 =&gt; Yes<\/p>\n<p>0\u00a0\u00a0\u00a0 =&gt; No<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>SQL Server Analysis Service<\/strong> (SSAS) ships several exciting performance improvements in this release:<\/p>\n<ul>\n<li>DAX query performance improvement, optimizations to the Tabular engine. These optimizations are mostly focused around reducing the \u201cchattiness\u201d between client tools that use DAX and the server (and eventually the storage engine for both VertiPaq and DirectQuery storage modes). In addition to query optimizations, measure executions have been streamlined as well.<\/li>\n<li>DirectQuery enhancements. It now generates simpler queries that will provide better performance.<\/li>\n<li>Now includes support for variables in DAX. Variables can now store the result of an expression as a named variable, which can then be passed as an argument to other measure expressions. Once resultant values have been calculated for a variable expression, those values do not change, even if the variable is referenced in another expression.<\/li>\n<\/ul>\n<p><strong>SQL Server Reporting Services<\/strong> (SSRS) includes a couple of enhancements:<\/p>\n<ul>\n<li>An updated version of Report Builder with a modern theme.<\/li>\n<li>Report rendering for modern browsers built on HTML5 standards.<\/li>\n<\/ul>\n<p><strong>SQL Server Integration Service<\/strong> (SSIS) released oData v4 protocol support, SSIS Error Column support, and advanced logging levels in CTP 2.3. Previous SSIS catalog only provides four kinds of logging level None, Basic, Performance and Verbose. The new advanced logging level remove the inflexibility of previous logging levels:<\/p>\n<ul>\n<li>New mechanism to collect the event context when events are fired<\/li>\n<li>New ssis_logreader role with permission to access all the view related to SSISDB operation logs<\/li>\n<li>New logging level customization to define logs and events collection<\/li>\n<li>Allow the collection of event context such as variable value, task properties and connection string<\/li>\n<li>New RuntimeLineage logging level to collect data for dynamic lineage. This function is provided through lineage library. There is a known issue that this feature doesn\u2019t work upgrading from earlier preview build of SQL2016, the fix is work-in-progress.<\/li>\n<\/ul>\n<p>Continue the momentum, <strong>Master Data Service<\/strong> added three improvements in this release:<\/p>\n<ul>\n<li>Many to many derived hierarchy<\/li>\n<li>Excel Addin Business rule management<\/li>\n<li>Merge conflicts<\/li>\n<\/ul>\n<p><strong>Query Execution<\/strong> with improved diagnostics for memory grant usage in this release. The following new XEvents added to facilitate better diagnostics of memory grant usage and issues. Showplan xml is extended to include memory grant usage per thread and iterator (additions in \u201cRunTimeCountersPerThread\u201d element).<\/p>\n<ol>\n<li>query_memory_grant_blocking<\/li>\n<li>query_memory_grant_resource_semaphores<\/li>\n<li>query_memory_grant_usage (details on ideal vs granted vs used memory)<\/li>\n<\/ol>\n<p><strong>DBCC CHECKDB<\/strong> Improvements in this release include: 1) Persisted computed columns and filtered indexes validation. Persisted computed columns are frequently used. DBCC CHECKDB can take long time to complete with persisted columns. This improvement provides an option to do persisted column validation under EXTENDED_LOGICAL_CHECKS; 2) Performance improvement when validating a table with thousands of partitions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 August monthly public preview release CTP 2.3. This 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.<\/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-14011","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-4-1593580446-456","review-flag-5-1593580452-31","review-flag-6-1593580457-144","review-flag-7-1593580462-294","review-flag-new-1593580247-437","review-flag-publi-1593580761-761"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2016 Community Technology Preview 2.3 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\/09\/02\/sql-server-2016-community-technology-preview-2-3-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.3 is available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 August monthly public preview release CTP 2.3. This 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.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-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-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=\"5 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\/sql-server-2016-community-technology-preview-2-3-is-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-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.3 is available\",\"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\/sql-server-2016-community-technology-preview-2-3-is-available\/\"},\"wordCount\":1146,\"commentCount\":4,\"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\/sql-server-2016-community-technology-preview-2-3-is-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/\",\"name\":\"SQL Server 2016 Community Technology Preview 2.3 is available - 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\/sql-server-2016-community-technology-preview-2-3-is-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-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.3 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.3 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\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Community Technology Preview 2.3 is available - Microsoft SQL Server Blog","og_description":"The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 August monthly public preview release CTP 2.3. This 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.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/","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":"5 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-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.3 is available","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\/sql-server-2016-community-technology-preview-2-3-is-available\/"},"wordCount":1146,"commentCount":4,"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\/sql-server-2016-community-technology-preview-2-3-is-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/","name":"SQL Server 2016 Community Technology Preview 2.3 is available - 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\/sql-server-2016-community-technology-preview-2-3-is-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-is-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/02\/sql-server-2016-community-technology-preview-2-3-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.3 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"]}]}},"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\/14011","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=14011"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14011\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=14011"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=14011"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=14011"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=14011"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=14011"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=14011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}