{"id":2953,"date":"2012-11-09T09:00:00","date_gmt":"2012-11-09T17:00:00","guid":{"rendered":""},"modified":"2024-01-22T22:49:29","modified_gmt":"2024-01-23T06:49:29","slug":"seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/","title":{"rendered":"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse"},"content":{"rendered":"<p><span style=\"font-family:'Segoe UI';font-size:small;\">In the fast evolving new world of Big Data, you are being asked to answer a new set of questions that require immediate responses on data that has changed in volume, variety, complexity and velocity. A modern data platform must be able to answer these new questions without costing IT millions of dollars to deploy complex and time consuming systems.<\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">On November 7, we <\/span><a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2012\/11\/07\/pass-summit-2012-accelerating-business-through-data-insights.aspx\"><span style=\"font-family:'Segoe UI';font-size:small;\">unveiled details<\/span><\/a><span style=\"font-family:'Segoe UI';font-size:small;\"> for SQL Server 2012 Parallel Data Warehouse (PDW), our scale-out Massively Parallel Processing (MPP) data warehouse appliance, which has evolved to fully embrace this new world. SQL Server 2012 PDW is built for big data and will provide a fundamental breakthrough in data processing using familiar tools to do seamless analysis on relational and Hadoop data at the lowest total cost of ownership.<\/span><\/p>\n<ul>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\"><b>Built for Big Data<\/b>: SQL Server 2012 PDW is powered by <b>PolyBase,<\/b> a breakthrough in data processing, thatenables integrated queries across Hadoop and relational data. Without manual intervention, PolyBase Query Processor can accept a standard SQL query and join tables from a relational source with data from a Hadoop source to return a combined result seamlessly to the user. Going a step further, integration with Microsoft\u2019s business intelligence tools allows users to join structured and unstructured data together in familiar tools like Excel to answer questions and make key business decisions quickly.\u00a0\u00a0\u00a0 <\/span><span style=\"font-family:'Segoe UI';font-size:small;\"><\/span>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\"><b>Next-generation Performance at Scale:<\/b> By upgrading the primary storage engine to a new updateable version of xVelocity columnstore, users can gain in-memory performance (<b>up to 50x faster<\/b>) on datasets that linearly scale out from small all the way up to 5 Petabytes of structured data.\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span style=\"font-family:'Segoe UI';font-size:small;\"><\/span>\n<\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>Engineered For Optimal Value<\/b>: In SQL Server 2012 PDW, we optimized the hardware specifications required of an appliance through software innovations to deliver significantly greater cost savings, roughly 2.5x lower cost per TB and value. Through features delivered in Windows Server 2012, SQL Server 2012 PDW has built-in performance, reliability, and scale for storage using economical high density disks. Further, Windows Server 2012 Hyper-V virtualizes and streamlines an entire server rack of control functions down to a few nodes. Finally, xVelocity columnstore provides both compression and the potential to eliminate the rowstore copy to reduce storage usage up to 70%. As a result of these innovations, SQL Server 2012 PDW has a price per terabyte that is significantly lower than all offers in the market today.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">With SQL Server 2008 R2 Parallel Data Warehouse, Microsoft already demonstrated high performance at scale when customers like <\/span><a href=\"http:\/\/www.microsoft.com\/casestudies\/Case_Study_Detail.aspx?CaseStudyID=710000000776\"><span style=\"font-family:'Segoe UI';font-size:small;\">HyVee<\/span><\/a><span style=\"font-family:'Segoe UI';font-size:small;\"> improved their performance 100 times by moving from SQL Server 2008 R2 to SQL Server 2008 R2 Parallel Data Warehouse. SQL Server 2012 Parallel Data Warehouse takes a big leap forward in performance, scale, and the ability to do big data analysis while lowering costs. For the first time, customers of all shapes, sizes and data requirements from the low end to the highest data capacity requirements can get a data warehouse appliance within their reach.<\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">We are very excited about SQL Server 2012 PDW which will be released broadly in the first half of 2013 and invite you to learn more through the following resources:<\/span><\/p>\n<ul>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\">Watch the latest PASS Summit 2012 Keynote or sessions<\/span><a href=\"http:\/\/www.microsoft.com\/sqlserver\"><span style=\"font-family:'Segoe UI';font-size:small;\"> here<\/span><\/a>\n<\/li>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\">Microsoft Official Blog Post on PASS Summit 2012, authored by Ted Kummert <\/span><a href=\"http:\/\/blogs.technet.com\/b\/microsoft_blog\/archive\/2012\/11\/07\/accelerating-insights-in-the-new-world-of-data.aspx\"><span style=\"font-family:'Segoe UI';font-size:small;\">here<\/span><\/a>\n<\/li>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\">Read customer examples of SQL Server 2008 R2 PDW (<\/span><a href=\"http:\/\/www.microsoft.com\/casestudies\/Case_Study_Detail.aspx?CaseStudyID=710000000776\"><span style=\"font-family:'Segoe UI';font-size:small;\">HyVee<\/span><\/a><span style=\"font-family:'Segoe UI';font-size:small;\">)<\/span>\n<\/li>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\">Visit HP\u2019s Enterprise Data Warehouse for SQL Server 2008 R2 Parallel Data Warehouse <\/span><a href=\"http:\/\/h71028.www7.hp.com\/enterprise\/us\/en\/partners\/microsoft-enterprise-data-warehouse-solution.html?jumpid=ex_r2858_us\/en\/large\/tsg\/microsoft_edw\"><span style=\"font-family:'Segoe UI';font-size:small;\">site<\/span><\/a>\n<\/li>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\">Find out more about Dell\u2019s SQL Server 2008 R2 Parallel Data Warehouse <\/span><a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/solutions-technologies\/Appliances\/Dell-pdw.aspx\"><span style=\"font-family:'Segoe UI';font-size:small;\">here<\/span><\/a>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In the fast evolving new world of Big Data, you are being asked to answer a new set of questions that require immediate responses on data that has changed in volume, variety, complexity and velocity.<\/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,2400],"content-type":[2448],"topic":[2451],"coauthors":[2487],"class_list":["post-2953","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2012","content-type-updates","topic-big-data"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse - 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\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"In the fast evolving new world of Big Data, you are being asked to answer a new set of questions that require immediate responses on data that has changed in volume, variety, complexity and velocity.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/\" \/>\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=\"2012-11-09T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:29+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\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse\",\"datePublished\":\"2012-11-09T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/\"},\"wordCount\":570,\"commentCount\":0,\"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\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/\",\"name\":\"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-11-09T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse\"}]},{\"@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":"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse - 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\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse - Microsoft SQL Server Blog","og_description":"In the fast evolving new world of Big Data, you are being asked to answer a new set of questions that require immediate responses on data that has changed in volume, variety, complexity and velocity.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-11-09T17:00:00+00:00","article_modified_time":"2024-01-23T06:49:29+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\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse","datePublished":"2012-11-09T17:00:00+00:00","dateModified":"2024-01-23T06:49:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/"},"wordCount":570,"commentCount":0,"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\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/","name":"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-11-09T17:00:00+00:00","dateModified":"2024-01-23T06:49:29+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/11\/09\/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse"}]},{"@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\/2953","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=2953"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2953\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=2953"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=2953"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=2953"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=2953"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=2953"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=2953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}