{"id":13951,"date":"2015-09-30T09:46:00","date_gmt":"2015-09-30T16:46:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/"},"modified":"2024-01-22T22:50:17","modified_gmt":"2024-01-23T06:50:17","slug":"sql-server-2016-community-technology-preview-2-4-is-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/","title":{"rendered":"SQL Server 2016 Community Technology Preview 2.4 is available"},"content":{"rendered":"

Updated on\u00a010\/12\/15<\/em><\/p>\n

The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 September <\/a>public preview release CTP 2.4<\/a>.\u00a0 This release advances the \u201cCloud First\u201d tenet; the build has already been deployed to SQL Azure Database <\/a>worldwide.<\/p>\n

To learn more about the release, visit the SQL Server 2016 preview page<\/a>.\u00a0 To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview <\/a>or try the preview by using a virtual machine in Microsoft Azure <\/a>and start evaluating the impact these new innovations can have for your business.<\/p>\n

Have questions?\u00a0 Join the discussion of the new SQL Server 2016 capabilities at MSDN<\/a> and\u00a0Stack Overflow<\/a>.\u00a0 If you run into an issue or would like to make a suggestion, you can let us know using Microsoft\u2019s Connect tool<\/a>.\u00a0 We look forward to hearing from you.<\/p>\n

Operational Analytics and In-Memory Data Warehouse<\/strong> improvements in this release include:<\/p>\n

1.\u00a0Frictionless operational analytics. Existing nonclustered columnstore indices (NCCI) are updateable without requiring index rebuild.<\/p>\n

2.\u00a0Parallel Index build of nonclustered columnstore index (NCCI). Starting with CTP 2.4, NCCI can now be built in parallel, leveraging available cores\/logical processors available on the server for significant performance improvement.<\/p>\n

3.\u00a0INSERT operations performance in delta Rowgroup. Prior to CTP2.4, the delta rowgroup data was PAGE compressed, which added overhead for Insert operations. With CTP2.4, the data in delta rowgroup is no longer PAGE compressed.<\/p>\n

4.\u00a0Better query performance with nonclustered columnstore index (NCCI).<\/p>\n

a.\u00a0String predicate pushdown.
\nb.\u00a0Improved query path when processing deleted rows by bypassing delete buffer when possible.<\/p>\n

x86 server deprecation –<\/strong>\u00a0Starting with the CTP 2.4 release, we have removed x86 server from SQL Server 2016 starting with CTP2.4 release, although all the x86 client tools and components are still available. Extensive customer research has shown that the x86 server instance has no adoption in new server deployments, primarily because server hardware have evolved to be x64 only. At setup, if you select the x86 option, you will only be able to install client components.<\/p>\n

\"<\/a><\/p>\n

\u00a0<\/strong><\/p>\n

SQL Server Smart Maintenance Plans<\/strong> for effective database maintenance.<\/p>\n

Multi-TB SQL Server databases have become commonplace; at the same time, the global business economy demands increased database availability, consequently narrowing allowed maintenance windows.\u00a0 Frequently, the traditional plans of maintaining database no longer not fit inside customers\u2019 narrow maintenance windows. Running past the maintenance window can cause poor application performance, which in turn can lead to ever-increasing infrastructure and operational costs for the customer and can negatively affect business efficiency. Smart Maintenance Plan<\/strong> integrates best practices, and can identify optimal strategies on the fly. Changes can be made to existing maintenance plan allow it to scale with the database.<\/p>\n

1. Consistency-checking strategy: based on database and table sizes to distribute the task across different maintenance windows. More options are added to the user controlled consistency-checking tasks UI.<\/p>\n

\"<\/a><\/p>\n

2.\u00a0\u00a0 Index and statistics maintenance strategy: based on index size\/page count, degree of fragmentation, and usage frequency to decide what operations to perform. More options are exposed in Rebuild as well as Reorganize index tasks UI for better usability:<\/p>\n

\"<\/a><\/p>\n

\"<\/a><\/p>\n

Tempdb scalability improvement<\/strong> creates multiple files during setup based on number of cores, this will reduce allocation contention on system pages in tempdb. The improvement also includes optimistic latching of system pages when dropping temp tables. SQL Server 2016 CTP 2.4 setup provides a separate tab for tempdb configuration. You can choose number of tempdb files, and customize initial and auto-growth size for tempdb files.<\/p>\n

\"<\/a><\/p>\n

\u00a0<\/strong><\/p>\n

SQL Server Integration Services (SSIS) improvements<\/strong> in this release include:<\/p>\n

    \n
  1. Complex data feed including Data Streaming destination.<\/li>\n
  2. Balanced data distributor (BDD).<\/li>\n
  3. Excel 2013 source and destination (requires Access runtime 2013).<\/li>\n
  4. AlwaysOn support.<\/li>\n
  5. oData v4 source component in addition to oData v3.<\/li>\n<\/ol>\n

    SQL Server Reporting Services (SSRS) improvements<\/strong> in this release include:<\/p>\n

      \n
    1. Design-time control over layout of report parameters, including the ability to have more than two columns of parameters and to control the position of each parameter within the Parameters pane.<\/li>\n
    2. Export to PowerPoint.<\/li>\n
    3. A new printing feature that works across modern browsers and doesn\u2019t require installing an ActiveX control.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Updated on\u00a010\/12\/15 The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 September public preview release CTP 2.4.\u00a0 This release advances the \u201cCloud First\u201d tenet; the build has already been deployed to SQL Azure Database worldwide. To learn more about the release, visit the SQL Server 2016 preview page.\u00a0<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_force_push":false,"ms_queue_id":"","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-13951","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-new-1593580247-437","review-flag-publi-1593580761-761"],"yoast_head":"\nSQL Server 2016 Community Technology Preview 2.4 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\/30\/sql-server-2016-community-technology-preview-2-4-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.4 is available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Updated on\u00a010\/12\/15 The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 September public preview release CTP 2.4.\u00a0 This release advances the \u201cCloud First\u201d tenet; the build has already been deployed to SQL Azure Database worldwide. To learn more about the release, visit the SQL Server 2016 preview page.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-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-30T16:46: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\/03\/8865.ctp24_1.jpg\" \/>\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\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-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.4 is available\",\"datePublished\":\"2015-09-30T16:46:00+00:00\",\"dateModified\":\"2024-01-23T06:50:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/\"},\"wordCount\":676,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/\",\"name\":\"SQL Server 2016 Community Technology Preview 2.4 is available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg\",\"datePublished\":\"2015-09-30T16:46:00+00:00\",\"dateModified\":\"2024-01-23T06:50:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-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.4 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.4 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\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Community Technology Preview 2.4 is available - Microsoft SQL Server Blog","og_description":"Updated on\u00a010\/12\/15 The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 September public preview release CTP 2.4.\u00a0 This release advances the \u201cCloud First\u201d tenet; the build has already been deployed to SQL Azure Database worldwide. To learn more about the release, visit the SQL Server 2016 preview page.\u00a0","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-09-30T16:46:00+00:00","article_modified_time":"2024-01-23T06:50:17+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg","type":"","width":"","height":""}],"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\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-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.4 is available","datePublished":"2015-09-30T16:46:00+00:00","dateModified":"2024-01-23T06:50:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/"},"wordCount":676,"commentCount":4,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/","name":"SQL Server 2016 Community Technology Preview 2.4 is available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg","datePublished":"2015-09-30T16:46:00+00:00","dateModified":"2024-01-23T06:50:17+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8865.ctp24_1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-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.4 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\/13951","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=13951"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13951\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=13951"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=13951"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=13951"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=13951"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=13951"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=13951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}