{"id":5783,"date":"2009-05-13T15:01:00","date_gmt":"2009-05-13T22:01:00","guid":{"rendered":""},"modified":"2024-01-22T22:51:55","modified_gmt":"2024-01-23T06:51:55","slug":"master-data-services-whats-the-big-deal","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/","title":{"rendered":"Master Data Services \u2013 What\u2019s the big deal?"},"content":{"rendered":"<p>Hi Kirk Haselden here.<\/p>\n<table style=\"width: 472px\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"151\"><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" style=\"border-width: 0px\" title=\"Kirk Haselden casual\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg\" alt=\"Kirk Haselden casual\" width=\"132\" height=\"178\" border=\"0\" \/><\/a><\/td>\n<td valign=\"top\" width=\"319\">I\u2019m the product unit manager for Master Data Services. I\u2019m responsible for the master data management strategy, team and product delivery at Microsoft. I manage the day to day aspects of the team, drive execution and overall product development. I have written two technical references for SAMS press on Integration Services, numerous technical articles and have 25 patents or patents pending. My team is a collection of talented developers, testers and program managers in Redmond and Denver.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>In June of 2007, Microsoft acquired a master data management software vendor known as Stratature. Since that time, the master data management team has been quietly working away turning the core capabilities of the Stratature product into a Microsoft product. We\u2019ve kept all the important features of the product and added some critical capabilities such as a fully featured and capable Windows Communication Foundation web service. We\u2019ve optimized the code and database. We\u2019ve done the security work that all Microsoft products must do to ship. We\u2019ve also added a few other capabilities that customers have requested. As was announced at TechEd Monday, we\u2019re now getting ready to ship the product as Master Data Services in the SQL Server 2008 R2 release.\u00a0 Let me explain what Master Data Services (MDS) is and why it\u2019s critical in today\u2019s enterprise.<\/p>\n<p>As corporate information ecosystems become more complex, so goes the management of company lists. Master lists are used, accessed, managed, changed and unfortunately corrupted in myriad ways throughout the company in various divisions and in various locations. For example, customer data may be used in the front office for direct contact with customers or in the back office in marketing, billing and other business processes. ERP and CRM systems do a great job of providing the functionality around how you use say, the product master or customer master. That\u2019s what they were designed to do. However, they don\u2019t do a great job of actually managing the forces that impact the master data itself. Four of the most important of those forces are decay, conflict, corruption and inconsistency.<\/p>\n<ul>\n<li><strong>Decay<\/strong> is when the world changes around the data. The data was accurate at one time, but then the world changed but the data wasn\u2019t updated to reflect that change. The classic example is when a customer moves.<\/li>\n<li><strong>Conflict<\/strong> is when duplicate data is introduced into the system. The data may exactly duplicate or differ substantially from established and validated data. In either case, it is usually although not always undesirable. A good example is when two identical parts <span lang=\"EN\" style=\"font-size: 11pt;font-family: 'Calibri','sans-serif'\">manufactured in different locations have different part numbers.<\/span><\/li>\n<li><strong>Corruption<\/strong> is when established, accurate and validated data is changed in some way that invalidated it. For example, if the price of an PVC elbow joint is misquoted as $550 instead of $5.50, it won\u2019t sell much.<\/li>\n<li><strong>Inconsistency<\/strong> is when the data is formed in unpredictable, erratic or incompatible ways. For example, a company may have a different naming convention for their product codes depending on the division or country where the product is generated.\u00a0 Not using the same canonical address format is another typical example.<\/li>\n<\/ul>\n<p>Traditional applications manage master data and these forces insufficiently. What is needed to solve these problems is an application that focuses on managing these forces with a set of tools that is specifically designed to ensure that the master data remains authoritative, is available in a secure way across the enterprise and is integrated with the applications that use it. Often the term \u201cOne source of the truth\u201d is used to describe what master data management applications deliver. I prefer the term \u201cauthoritative source of master data\u201d. Having one source isn\u2019t always desirable nor is it always realistic. Master data isn\u2019t truth. It\u2019s simply data that represents the world at a given time slice. The trick and it\u2019s a difficult one, is to keep the master data authoritative. Authoritative data is reliable, represents the state of the world at the time it\u2019s referenced and is delivered in a secure, integrated and performant way.<\/p>\n<p>Why now? Why has master data management emerged as one of the top 2 or 3 initiatives on the average CIO\u2019s mind? The answer lies somewhere in the perfect storm of economic downturn, corporate information ecosystem complexity, strict governmental regulations such as HIPAA and Sarbanes Oxley, services oriented architectures, and the recognition that solving the problem through custom solutions is extremely difficult. Investing in master data management solutions, especially in today\u2019s difficult economic times makes dollars and sense. Master data management is an investment in cost savings, revenue recovery, human resource optimization, and capital investment efficiency.<\/p>\n<p>Unlike transactional data, master data doesn\u2019t capture one time transactions. It\u2019s longer lasting and slowly changing, making it difficult to manage in one time processes. Master data management is a continuing effort that must be a part of the entire lifecycle of the master data from inception to deletion. Master data is involved with transactional data everywhere including business intelligence, mandatory financial reports, billing, marketing and other critical business activities. If the master data, the gas that fuels the corporate engine, is dirty, the company doesn\u2019t run very efficiently, or at all. Find a way to clean up the fuel and that corporate engine will run more efficiently.<\/p>\n<p>In addition to the DPI blog, I\u2019ll be blogging through the coming months leading up to our release. Monday, our product team site also went live: <a href=\"http:\/\/www.microsoft.com\/sqlserver\/2008\/en\/us\/mds.aspx\">http:\/\/www.microsoft.com\/sqlserver\/2008\/en\/us\/mds.aspx<\/a><\/p>\n<p>We\u2019re excited to be working on a solution to a problem that exists in every substantial company in the world.<\/p>\n<p>Thanks,<\/p>\n<p>Kirk<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi Kirk Haselden here. I\u2019m the product unit manager for Master Data Services. I\u2019m responsible for the master data management strategy, team and product delivery at Microsoft. I manage the day to day aspects of the team, drive execution and overall product development.<\/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":[],"content-type":[2445],"topic":[],"coauthors":[],"class_list":["post-5783","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Master Data Services \u2013 What\u2019s the big deal? - 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\/2009\/05\/13\/master-data-services-whats-the-big-deal\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Master Data Services \u2013 What\u2019s the big deal? - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Hi Kirk Haselden here. I\u2019m the product unit manager for Master Data Services. I\u2019m responsible for the master data management strategy, team and product delivery at Microsoft. I manage the day to day aspects of the team, drive execution and overall product development.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/\" \/>\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=\"2009-05-13T22:01:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_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=\"4 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\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Master Data Services \u2013 What\u2019s the big deal?\",\"datePublished\":\"2009-05-13T22:01:00+00:00\",\"dateModified\":\"2024-01-23T06:51:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/\"},\"wordCount\":958,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/\",\"name\":\"Master Data Services \u2013 What\u2019s the big deal? - 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\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg\",\"datePublished\":\"2009-05-13T22:01:00+00:00\",\"dateModified\":\"2024-01-23T06:51:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Master Data Services \u2013 What\u2019s the big deal?\"}]},{\"@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":"Master Data Services \u2013 What\u2019s the big deal? - 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\/2009\/05\/13\/master-data-services-whats-the-big-deal\/","og_locale":"en_US","og_type":"article","og_title":"Master Data Services \u2013 What\u2019s the big deal? - Microsoft SQL Server Blog","og_description":"Hi Kirk Haselden here. I\u2019m the product unit manager for Master Data Services. I\u2019m responsible for the master data management strategy, team and product delivery at Microsoft. I manage the day to day aspects of the team, drive execution and overall product development.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2009-05-13T22:01:00+00:00","article_modified_time":"2024-01-23T06:51:55+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_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":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Master Data Services \u2013 What\u2019s the big deal?","datePublished":"2009-05-13T22:01:00+00:00","dateModified":"2024-01-23T06:51:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/"},"wordCount":958,"commentCount":6,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/","name":"Master Data Services \u2013 What\u2019s the big deal? - 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\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg","datePublished":"2009-05-13T22:01:00+00:00","dateModified":"2024-01-23T06:51:55+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kirk20Haselden20casual_thumb_1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/05\/13\/master-data-services-whats-the-big-deal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Master Data Services \u2013 What\u2019s the big deal?"}]},{"@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\/5783","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=5783"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5783\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=5783"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=5783"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=5783"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=5783"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=5783"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=5783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}