{"id":25471,"date":"2018-11-13T09:00:29","date_gmt":"2018-11-13T17:00:29","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25471"},"modified":"2018-11-13T07:51:42","modified_gmt":"2018-11-13T15:51:42","slug":"creating-a-data-hub-for-your-analytics-with-polybase","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/","title":{"rendered":"Creating a data hub for your analytics with PolyBase"},"content":{"rendered":"<p>Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data platform, Microsoft is delivering a modern data platform. We are witnessing a paradigm shift in data management where data in different silos are being brought together to create high-value data sets that are used to drive critical business divisions in industry verticals like retail, banking, healthcare, and more.<\/p>\n<p>SQL Server 2016 introduced a new feature called <strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-guide?view=sql-server-2017\">PolyBase<\/a><\/strong> that enables your SQL Server instance to process Transact-SQL queries that read data from Hadoop. The same query can also join with relational tables in your SQL Server. SQL Server 2019 CTP 2.0 introduces new connectors for PolyBase including SQL Server, Oracle, Teradata, MongoDB, Azure SQL DB, Azure SQL DW, Cosmos DB, and virtually any ODBC-accessible data source.<\/p>\n<p>The arrival of the new connectors enables customers to leverage PolyBase for creating a virtual data hub for a wide variety of data sources within the enterprise. It\u2019s very common to find an enterprise scenario where data from an Oracle database needs to be joined with data from another SQL Server instance for serving a business purpose. Starting with SQL Server 2019, you can leverage PolyBase for creating a source-agnostic solution using external tables. This opens multiple possibilities like building a modern data warehousing solution spanning SQL Server, Oracle, and Teradata.<\/p>\n<p>Let\u2019s consider an example where we have a set of tables in multiple heterogeneous data sources such as Oracle which stores information that needs to be joined with tables in SQL Server. You can create an external table in SQL Server that retrieves data from the Oracle database, making the Oracle data available as a virtual part of the SQL Server database. The screenshot below shows how you can create an <strong>External Table<\/strong> using the <strong>Create External Table Wizard<\/strong> in <strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/what-is?view=sql-server-2017\">Azure Data Studio<\/a><\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25474 size-large aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image-1024x576.jpg\" alt=\"\" width=\"1024\" height=\"576\" \/><\/p>\n<p>The ability to reference an external data source like an Oracle database table in an SQL Server database table opens multiple possibilities:<\/p>\n<ul>\n<li><strong>Unified Security<\/strong> <strong>Model<\/strong> \u2013 Users now have the ability to access external tables in other data sources such as Oracle and implement a common security model for applications to access the data using SQL Server database roles and permissions.<\/li>\n<li><strong>Data Virtualization \u2013 <\/strong>This allows you to virtualize an external entity as a SQL Server table to build a data hub that abstracts the need for the application to know the actual schema, data source location, and protocols required to access different data sources. You can take this concept further by creating SQL Server views for applications to access the external tables which would further abstract and protect the application from any schema and design changes in the external tables in the future date due to a migration or upgrade.<\/li>\n<li><strong>Performance<\/strong> \u2013 This gives you the ability to push computation to Hadoop or other data sources which will improve your query performance. For example, querying Hadoop through an external table creates MapReduce jobs and leverages Hadoop&#8217;s distributed computational resources.<\/li>\n<li><strong>Data Marts <\/strong>\u2013 You can use external tables to create data marts within SQL Server by pulling data into In-Memory OLTP cache tables with Columnstore Indexes for serving high-frequency queries. The cache tables can be refreshed on-demand or on a schedule using a SQL Agent job.\u00a0Using <a href=\"http:\/\/download.microsoft.com\/download\/8\/B\/6\/8B643729-6224-4ECC-8C50-3292B8156F0E\/SQL_Server_2019_Transform-Data_into_Insights_Infographic_EN_US.pdf\"><strong>big data clusters<\/strong><\/a> for SQL Server 2019 public preview provides this capability.<\/li>\n<li><strong>Intelligent Data <\/strong>\u2013 SQL Server <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/what-is-sql-server-machine-learning?view=sql-server-2017\">Machine Learning Services<\/a> can be used for executing R and Python code on SQL Server to train and operationalize machine learning models. The ability to reference an external table in SQL Server with Machine Learning Services allows you to train predictive models over a wider variety and volume of data through the use of data marts for querying the external tables.<\/li>\n<\/ul>\n<p>Leveraging SQL Server\u2019s PolyBase connectors allows you to build a modern data warehouse using SQL Server which spans beyond just the SQL Server database and opens a number of scenarios that weren\u2019t previously possible. Use <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2019#Install\">SQL Server 2019 Public Preview<\/a> to try out our new PolyBase feature for Oracle, Teradata, SQL Server, and MongoDB.<\/p>\n<h3>Learn more<\/h3>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-guide?view=sql-server-ver15\">Overview of SQL Server PolyBase<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-configure-oracle?view=sql-server-ver15\">PolyBase Installation<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-configure-oracle?view=sql-server-ver15\">Configure PolyBase to access external data in Oracle<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data platform, Microsoft is delivering a modern data platform. We are witnessing a<\/p>\n","protected":false},"author":5562,"featured_media":25474,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[2542,2391,2536],"content-type":[2448],"topic":[2451,2466,2469],"coauthors":[2563],"class_list":["post-25471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure-data-studio","product-azure-sql-database","product-sql-server-2019","content-type-updates","topic-big-data","topic-developer","topic-high-performance-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating a data hub for your analytics with PolyBase - 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\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a data hub for your analytics with PolyBase - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data platform, Microsoft is delivering a modern data platform. We are witnessing a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/\" \/>\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=\"2018-11-13T17:00:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T15:51:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Amit Banerjee\" \/>\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=\"Amit Banerjee\" \/>\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\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/amit-banerjee\/\",\"@type\":\"Person\",\"@name\":\"Amit Banerjee\"}],\"headline\":\"Creating a data hub for your analytics with PolyBase\",\"datePublished\":\"2018-11-13T17:00:29+00:00\",\"dateModified\":\"2018-11-13T15:51:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/\"},\"wordCount\":721,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/\",\"name\":\"Creating a data hub for your analytics with PolyBase - 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\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg\",\"datePublished\":\"2018-11-13T17:00:29+00:00\",\"dateModified\":\"2018-11-13T15:51:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg\",\"width\":1920,\"height\":1080,\"caption\":\"a screenshot of a cell phone\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a data hub for your analytics with PolyBase\"}]},{\"@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":"Creating a data hub for your analytics with PolyBase - 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\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/","og_locale":"en_US","og_type":"article","og_title":"Creating a data hub for your analytics with PolyBase - Microsoft SQL Server Blog","og_description":"Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data platform, Microsoft is delivering a modern data platform. We are witnessing a","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-11-13T17:00:29+00:00","article_modified_time":"2018-11-13T15:51:42+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg","type":"image\/jpeg"}],"author":"Amit Banerjee","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Amit Banerjee","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/amit-banerjee\/","@type":"Person","@name":"Amit Banerjee"}],"headline":"Creating a data hub for your analytics with PolyBase","datePublished":"2018-11-13T17:00:29+00:00","dateModified":"2018-11-13T15:51:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/"},"wordCount":721,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/","name":"Creating a data hub for your analytics with PolyBase - 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\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg","datePublished":"2018-11-13T17:00:29+00:00","dateModified":"2018-11-13T15:51:42+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/2091-image.jpg","width":1920,"height":1080,"caption":"a screenshot of a cell phone"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/13\/creating-a-data-hub-for-your-analytics-with-polybase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating a data hub for your analytics with PolyBase"}]},{"@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\/25471"}],"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\/5562"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=25471"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25471\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/25474"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=25471"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=25471"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=25471"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=25471"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=25471"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=25471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}