{"id":13711,"date":"2015-07-28T13:00:00","date_gmt":"2015-07-28T20:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/"},"modified":"2024-01-22T22:50:14","modified_gmt":"2024-01-23T06:50:14","slug":"sql-server-2016-community-technology-preview-2-2-is-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/","title":{"rendered":"SQL Server 2016 Community Technology Preview 2.2 is available"},"content":{"rendered":"<p>The SQL Server engineering team is committed to <a title=\"SQL Server 2016\" href=\"\/sqlserver\/2015\/05\/04\/sql-server-2016-public-preview-coming-this-summer\/\">SQL Server 2016<\/a> monthly public preview release rhythm. Following <a title=\"CTP 2.1 June 2015 release\" href=\"\/sqlserver\/2015\/06\/24\/sql-server-2016-community-technology-preview-2-1-is-available\/\">CTP 2.1 release<\/a> last month, we are excited to announce the immediate availability of SQL Server 2016 CTP 2.2 release for <a title=\"SQL Server 2016 CTP 2.2\" href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">download<\/a>. This incremental release includes new capabilities for query store, stretch database, core engine, temporal, MDS, reporting services and engine scalability improvements. Learn about these improvements below.<\/p>\n<p>The <strong>Stretch Database<\/strong> enables you dynamically stretch the cold transactional data to Azure SQL so your operational data is always at hand, no matter the size, and you can benefit from the low cost of using Azure. Improvements in this release include:<\/p>\n<ul>\n<li>\n<strong>Row Level Security<\/strong> (RLS) enabled<\/li>\n<li>\n<strong>Stretch Database Advisor <\/strong>now available to analyze existing database tables, discovering and evaluating candidates for stretch by adjustable table size thresholds<\/p>\n<ul>\n<li>Bundled with SQL Server 2016 Upgrade Advisor Preview 1, Stretch Database Advisor is available for download\u00a0<a title=\"SQL Server 2016 Upgrade Advisor Preview 1\" href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=48119\">here<\/a> or through the Web Platform Installer<\/li>\n<\/ul>\n<p style=\"padding:0;margin:0;\">\n<\/li>\n<\/ul>\n<p>First released in SQL 2008 R2, the <strong>Master Data Services (MDS)<\/strong> is the SQL Server solution for master data management. We are making significant investments in SQL 2016 to advance strategic capabilities in the data management space. Improvements in this release include:<\/p>\n<ul>\n<li>\n<strong>Sync entity between models\u00a0<\/strong>allow you to setup sync relationship to sync entity from another model. Steps:<\/p>\n<ol>\n<li>Go to Admin, Sync Entity page<\/li>\n<li>Click Add<\/li>\n<li>Choose target model, version and entity, source model, version and entity<\/li>\n<li>Choose sync type to be on-demand or auto sync<\/li>\n<li>Click Save<\/li>\n<\/ol>\n<\/li>\n<li>\n<strong>SCD Type-2 support <\/strong>enables creation of SCD type-2 subscription view for Member transaction log type entities. Steps:<\/p>\n<ol>\n<li>Go to Admin, Entity page<\/li>\n<li>Choose transaction log type<\/li>\n<li>If transaction log type is Member, go to Integration, Create Views page<\/li>\n<li>Create a view of SCD Type-2 then\u00a0History View can be chosen from format type<\/li>\n<\/ol>\n<\/li>\n<li>\n<strong>Compound Keys index support<\/strong> includes custom attributes to improve the performance or enforce constraints. NOTE: In this release <strong>Entity Based Staging <\/strong>batches need to start by calling stored procedures directly instead of using the web UI. Steps:<\/p>\n<ol>\n<li>Go to Admin, Entity page<\/li>\n<li>Click Add on Customer Indexes<\/li>\n<li>Choose the columns and click Save to create the index<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p>The query \u201cflight recorder,\u201d <strong>Query Store<\/strong>,\u00a0captures current and historical query plans and execution metrics, enabling you to easily monitor and troubleshoot query performance issues. Query Store has been made available since the first SQL 2016 community technical preview. Improvements in this release include:<\/p>\n<ul>\n<li>Automatically switch to READ_ONLY mode when the reaches the defined max size limit and store collecting new query plans and run time stats. You will be able to detect that by looking at readonly_reason from sys.database_query_store_options. Value 65536 indicates when Query Store has reached the defined size limit.<\/li>\n<li>Query Store UI enhancements and bug fixes<\/li>\n<li>No force plan recompiles after MAX_PLANS_PER_QUERY is hit. The max_plans_per_query value can be examined from sys.database_query_store_options. NOTE: Force plan recompile could have potential performance overhead.<\/li>\n<\/ul>\n<p><strong>Temporal<\/strong> enables handling and analyzing database records that changes over time. Improvements in this release include:<\/p>\n<ul>\n<li>Full support column with ROWVERSION (TIMESTAMP) to support UPDATE operation on ROWVERSION column in temporal table<\/li>\n<li>COLUMNPROPERTY exposes \u2018ishidden\u2019 property <br \/><span style=\"font-family:courier new,courier;\"><span style=\"color:#0000ff;\">select<\/span> <span style=\"color:#ff00ff;\">columnproperty<\/span> (<span style=\"color:#ff00ff;\">object_id<\/span> (<span style=\"color:#ff0000;\">&#8216;dbo.sample_table&#8217;<\/span>), <span style=\"color:#ff0000;\">&#8216;SysStartTime&#8217;<\/span>, <span style=\"color:#ff0000;\">&#8216;ishidden&#8217;<\/span>)<\/span>\n<\/li>\n<li>Several improvements in <strong>SQL Server Management Studio<\/strong>:\n<ul>\n<li>Syntax highlighting for temporal keywords<\/li>\n<li>Transact-SQL client side validations<\/li>\n<li>Script table as DROP TO includes DROP script for history table<\/li>\n<li>SSMS surfaces IsHidden information in column Properties dialog<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Query Execution<\/strong> provides improved diagnostics for memory grant usage. The following new XEvents were added to facilitate better diagnostics. Showplan xml is extended to include memory grant usage per thread and iterator (additions in \u201cRunTimeCountersPerThread\u201d element).<\/p>\n<ul>\n<li><strong>query_memory_grant_blocking<\/strong><\/li>\n<li><strong>query_memory_grant_resource_semaphores<\/strong><\/li>\n<li><strong>query_memory_grant_usage (details on ideal vs granted vs used memory)<\/strong><\/li>\n<\/ul>\n<p><strong>Core Engine Scalability<\/strong> improvements 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.<\/p>\n<ul>\n<li>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 partitioned by node, to be partitioned by CPU. This improvement not only eliminated the need for the trace flag, but also dynamically determined partition based on contention.<\/li>\n<\/ul>\n<p><strong>DBCC CHECKDB<\/strong> improvements in this release include:<\/p>\n<ul>\n<li>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.<\/li>\n<li>Performance improvements when validating a table with thousands of partitions.<\/li>\n<\/ul>\n<p><strong>Reporting Services<\/strong> added treemap and subburst charts. Report authors can now create two additional chart types:<\/p>\n<ul>\n<li>Treemap<\/li>\n<li>Subburst charts<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server engineering team is committed to SQL Server 2016 monthly public preview release rhythm. Following CTP 2.1 release last month, we are excited to announce the immediate availability of SQL Server 2016 CTP 2.2 release for download.<\/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":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-13711","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-alway-1593580309-407","review-flag-bundl-1593580251-992","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.2 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\/07\/28\/sql-server-2016-community-technology-preview-2-2-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.2 is available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The SQL Server engineering team is committed to SQL Server 2016 monthly public preview release rhythm. Following CTP 2.1 release last month, we are excited to announce the immediate availability of SQL Server 2016 CTP 2.2 release for download.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-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-07-28T20:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:14+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=\"3 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\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-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.2 is available\",\"datePublished\":\"2015-07-28T20:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/\"},\"wordCount\":798,\"commentCount\":8,\"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\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/\",\"name\":\"SQL Server 2016 Community Technology Preview 2.2 is available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-07-28T20:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-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.2 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.2 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\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Community Technology Preview 2.2 is available - Microsoft SQL Server Blog","og_description":"The SQL Server engineering team is committed to SQL Server 2016 monthly public preview release rhythm. Following CTP 2.1 release last month, we are excited to announce the immediate availability of SQL Server 2016 CTP 2.2 release for download.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-07-28T20:00:00+00:00","article_modified_time":"2024-01-23T06:50:14+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":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-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.2 is available","datePublished":"2015-07-28T20:00:00+00:00","dateModified":"2024-01-23T06:50:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/"},"wordCount":798,"commentCount":8,"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\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/","name":"SQL Server 2016 Community Technology Preview 2.2 is available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-07-28T20:00:00+00:00","dateModified":"2024-01-23T06:50:14+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-is-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/28\/sql-server-2016-community-technology-preview-2-2-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.2 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\/13711","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=13711"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13711\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=13711"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=13711"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=13711"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=13711"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=13711"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=13711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}