{"id":16085,"date":"2016-06-09T09:30:47","date_gmt":"2016-06-09T16:30:47","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=16085"},"modified":"2024-01-22T22:50:31","modified_gmt":"2024-01-23T06:50:31","slug":"wideworldimporters-the-new-sql-server-sample-database","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/","title":{"rendered":"WideWorldImporters: The new SQL Server sample database"},"content":{"rendered":"<p><em>This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server.<\/em><\/p>\n<p>A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade.<\/p>\n<p><strong><strong><strong>Wide World Importers<\/strong><\/strong><\/strong> is the new sample for SQL Server. It illustrates how the rich SQL Server feature set can be used in a realistic database. It does not attempt to use every single SQL Server feature, as that would not be realistic. It also showcases the key SQL Server 2016 capabilities and performance enhancements.<\/p>\n<p><strong><strong><strong><strong><strong><strong><strong>Latest release of the sample<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong>: <a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=800630\">wide-world-importers-release<\/a><\/p>\n<p><strong>Documentation for the sample<\/strong>: <a href=\"https:\/\/msdn.microsoft.com\/library\/mt734199(v=sql.1).aspx\">wide-world-importers-documentation<\/a><\/p>\n<p>The sample is structured as follows:<\/p>\n<ul>\n<li><strong>WideWorldImporters<\/strong> is the main database for transaction processing (OLTP \u2013 OnLine Transaction Processing) and operational analytics (HTAP \u2013 Hybrid Transactional\/Analytics Processing). Here are some examples of the use of SQL Server capabilities with this database:\n<ul>\n<li>Real-time operational analytics of sales data is enabled through the use of <a href=\"https:\/\/msdn.microsoft.com\/library\/dn817827.aspx\">nonclustered columnstore indexes<\/a>.<\/li>\n<li>Archive tables can be <a href=\"https:\/\/msdn.microsoft.com\/library\/dn935011.aspx\">stretched to Azure<\/a> for long-term retention, reducing storage cost and improving manageability.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/dn817826.aspx\">Query Store<\/a> is used to keep track of query performance.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/dn935015.aspx\">Temporal tables<\/a> are used to conveniently keep track of the history of reference data, as well as some of the main entities.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/dn921897.aspx\">JSON <\/a>is used to enable AJAX calls to some of the key tables, and also to extend the relational schema to record such things as application settings and user preferences.<\/li>\n<li>Advanced security features like <a href=\"https:\/\/msdn.microsoft.com\/library\/mt163865.aspx\">Always Encrypted<\/a>, <a href=\"https:\/\/msdn.microsoft.com\/library\/dn765131.aspx\">Row-Level Security<\/a> and <a href=\"https:\/\/msdn.microsoft.com\/library\/mt130841.aspx\">Dynamic Data Masking<\/a> are used to secure data.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/dn133186.aspx\">In-Memory OLTP<\/a> is used to optimize the performance of <a href=\"https:\/\/blogs.msdn.microsoft.com\/sqlserverstorageengine\/2016\/03\/21\/improving-temp-table-and-table-variable-performance-using-memory-optimization\/\">table-valued parameters (TVPs)<\/a> and to optimize ingestion of sensor data.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/gg492088.aspx\">Clustered columnstore indexes<\/a> are used to reduce the storage footprint of large tables with insert-only workload.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/ms190787.aspx\">Partitioning<\/a> is used to improve the manageability of large tables.<\/li>\n<li>For more detail, see <a href=\"https:\/\/msdn.microsoft.com\/library\/mt734203(v=sql.1).aspx\">WideWorldImporters use of SQL Server features and capabilities<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li><strong>WideWorldImportersDW<\/strong> is the main database for data warehousing and analytics (OLAP \u2013 OnLine Analytics Processing). The data in this database is derived from the transactional database WideWorldImporters, but it uses a schema that is specifically optimized for analytics. Here are some examples of the use of SQL Server capabilities with this database:\n<ul>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/gg492088.aspx\">Clustered columnstore indexes<\/a> are used to reduce the storage footprint and improve query performance for the fact tables.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/mt143171.aspx\">PolyBase<\/a> is used to correlate data in the local database with a public data set in Azure Blog storage.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/dn133186.aspx\">In-Memory OLTP<\/a> is used to improve the performance of the ETL process.<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/library\/ms190787.aspx\">Partitioning<\/a> is used to improve manageability of the fact tables, which can grow very large in a data warehouse.<\/li>\n<li>For more detail, see <a href=\"https:\/\/msdn.microsoft.com\/library\/mt734216(v=sql.1).aspx\">WideWorldImportersDW use of SQL Server features and capabilities<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>A <a href=\"https:\/\/msdn.microsoft.com\/library\/ms141026.aspx\">SQL Server Integration Services (SSIS)<\/a> package, <strong>Daily ETL.ispac<\/strong>, is used to move data from the OLTP database WideWorldImporters to the OLAP database WideWorldImportersDW. The package is designed to use bulk T-SQL statements wherever possible to enhance performance. For details about the ETL workflow, see the <a href=\"https:\/\/msdn.microsoft.com\/library\/mt734218(v=sql.1).aspx\">WideWorldImportersDW ETL workflow<\/a>.<\/li>\n<\/ul>\n<p>The sample also includes a number of scripts that can be used to explore some of the features used in the sample database. In addition, the sample includes two workload drivers, which are small applications that simulate a workload running against the database.<\/p>\n<p>The databases contain sample sales and purchases data starting January 1st, 2013, until May 31st, 2016. The sample includes procedures to generate more sample data, so you can always bring the sample up to the current date. For details, see <a href=\"https:\/\/msdn.microsoft.com\/library\/mt734211(v=sql.1).aspx\">WideWorldImporters data generation<\/a>.<\/p>\n<p>The data size is limited to keep the download size reasonable. If you desire a sample database with a larger data size, use the source scripts to create a new sample database, and tweak the parameters in step 6 to increase the data size.<\/p>\n<p><strong>Get started<\/strong><\/p>\n<ol>\n<li>Download and install a free trial of <a href=\"https:\/\/www.microsoft.com\/evalcenter\/evaluate-sql-server-2016\">SQL Server 2016<\/a> or configure a test environment using an <a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/virtual-machines-windows-portal-sql-server-provision\/\">Azure SQL VM<\/a>.\n<ul>\n<li>The <a href=\"https:\/\/myprodscussu1.app.vssubscriptions.visualstudio.com\/Downloads?q=SQL%20Server%20Developer\">Developer Edition<\/a> is free if you sign up for the free Visual Studio Dev Essentials program.<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sql-server-samples\/releases\/tag\/wide-world-importers-v1.0\">Download the sample<\/a> and review the <a href=\"https:\/\/msdn.microsoft.com\/library\/mt734199(v=sql.1).aspx\">sample documentation<\/a>.<\/li>\n<\/ol>\n<p>Send any feedback on the sample to: <a href=\"mailto:sqlserversamples@microsoft.com\">sqlserversamples@microsoft.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server. A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2424],"topic":[],"coauthors":[2487],"class_list":["post-16085","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-best-practices","review-flag-1593580427-503","review-flag-6-1593580457-144","review-flag-alway-1593580309-407","review-flag-free-1593619513-128","review-flag-new-1593580247-437","review-flag-vm-1593580806-223"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>WideWorldImporters: The new SQL Server sample database - 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\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WideWorldImporters: The new SQL Server sample database - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server. A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/\" \/>\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=\"2016-06-09T16:30:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:31+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\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"WideWorldImporters: The new SQL Server sample database\",\"datePublished\":\"2016-06-09T16:30:47+00:00\",\"dateModified\":\"2024-01-23T06:50:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/\"},\"wordCount\":689,\"commentCount\":1,\"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\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/\",\"name\":\"WideWorldImporters: The new SQL Server sample database - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2016-06-09T16:30:47+00:00\",\"dateModified\":\"2024-01-23T06:50:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WideWorldImporters: The new SQL Server sample database\"}]},{\"@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":"WideWorldImporters: The new SQL Server sample database - 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\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/","og_locale":"en_US","og_type":"article","og_title":"WideWorldImporters: The new SQL Server sample database - Microsoft SQL Server Blog","og_description":"This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server. A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-06-09T16:30:47+00:00","article_modified_time":"2024-01-23T06:50:31+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\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"WideWorldImporters: The new SQL Server sample database","datePublished":"2016-06-09T16:30:47+00:00","dateModified":"2024-01-23T06:50:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/"},"wordCount":689,"commentCount":1,"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\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/","name":"WideWorldImporters: The new SQL Server sample database - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2016-06-09T16:30:47+00:00","dateModified":"2024-01-23T06:50:31+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/09\/wideworldimporters-the-new-sql-server-sample-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"WideWorldImporters: The new SQL Server sample database"}]},{"@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\/16085","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=16085"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/16085\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=16085"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=16085"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=16085"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=16085"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=16085"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=16085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}