{"id":30150,"date":"2020-03-31T01:00:37","date_gmt":"2020-03-31T08:00:37","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=30150"},"modified":"2024-01-22T22:51:25","modified_gmt":"2024-01-23T06:51:25","slug":"migrate-sql-workloads-to-the-cloud-with-confidence","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/","title":{"rendered":"Migrate SQL workloads to the cloud with confidence"},"content":{"rendered":"<p>Wouldn\u2019t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence.<\/p>\n<p>That type of crystal ball is essentially what Microsoft gives us in the form of <a href=\"https:\/\/docs.microsoft.com\/sql\/dea\/database-experimentation-assistant-overview?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Database Experimentation Assistant (DEA)<\/a>. To learn about the benefits of other Azure database capabilities, read <a href=\"http:\/\/aka.ms\/dbmseries_confidence_open\" target=\"_blank\" rel=\"noopener noreferrer\">Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators<\/a><em>.<\/em><\/p>\n<p>The Database Experimentation Assistant allows you to evaluate a targeted version of SQL Server for a specific workload. By conducting A\/B testing, you can see how the workload on the source server in your current environment will perform in the new environment. The Database Experimentation Assistant has the ability to capture and replay on Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Linux.<\/p>\n<p>The Database Experimentation Assistant provides analysis metrics to identify potential issues when upgrading from earlier versions of SQL Server starting with 2005 to more recent versions. Database Experimentation Assistant analysis metrics include:<\/p>\n<ul>\n<li>Queries that have compatibility errors.<\/li>\n<li>Degraded queries and query plans.<\/li>\n<li>Other workload comparison data.<\/li>\n<\/ul>\n<h2>Prerequisites for running Database Experimentation Assistant<\/h2>\n<p>Make sure you meet the following prerequisites before running Database Experimentation Assistant:<\/p>\n<ul>\n<li>The minimum hardware requirement is a single-core machine with 3.5 GB of RAM.<\/li>\n<li>The ideal hardware requirement is an eight-core CPU (with 3.5 GB of RAM or more). Note: Database Experimentation Assistant run times do not improve on processors with more than eight cores.<\/li>\n<li>An additional 33 percent of performance trace size is needed to store A, B, and report analysis databases.<\/li>\n<li>The user running Database Experimentation Assistant must be able to connect to the database servers using Windows authentication.<\/li>\n<li>The user must also have sysadmin rights on both the source and target database servers.<\/li>\n<\/ul>\n<h2>Running Database Experimentation Assistant<\/h2>\n<p>Database Experimentation Assistant guides you through an A\/B test of your source and proposed servers in three stages:<\/p>\n<h3>1. Capture a workload trace<\/h3>\n<p>The first stage is to capture a workload trace on the source server, which is usually the production server. Trace files capture the entire query workload on that server, including timestamps. Before you start, back up the databases.<br \/>\nNote: A query must execute at least 15 times during the capture period for the Database Experimentation Assistant to determine whether performance will improve or degrade in the new environment.<\/p>\n<h3>2. Replay a workload trace<\/h3>\n<p>Next, replay the trace file on two target servers. Target one will mimic your source server, and Target two will mimic the proposed target environment. The hardware configurations of the targets should be as similar as possible to enable SQL Server to analyze the effect your proposed changes have on performance. To replay a workload trace, your computers must be set up to run distributed replay traces.<\/p>\n<h3>3. Analyze the replayed workload traces<\/h3>\n<p>Finally, generate an analysis report using the replay traces, and review the report for insights about potential performance implications in the new environment.<\/p>\n<h2>Learn more<\/h2>\n<p>Migrating SQL Server to the cloud can be a major undertaking. The more assurance you have that the migration will be a success, the better. As an experimentation solution for SQL Server upgrades, Database Experimentation Assistant can help you evaluate a targeted version of SQL Server for a specific workload. You can then rest assured that the workload will perform as expected and can proceed confidently with your migration.<\/p>\n<p>To learn more about moving your databases to the cloud, download <a href=\"http:\/\/aka.ms\/dbmseries_confidence_close\" target=\"_blank\" rel=\"noopener noreferrer\">Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators<\/a><em>.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wouldn\u2019t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence. That type of crystal ball is essentially what Microsoft gives us in the<\/p>\n","protected":false},"author":1457,"featured_media":32028,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5226,2391],"content-type":[2424],"topic":[],"coauthors":[2487],"class_list":["post-30150","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-sql-database","content-type-best-practices","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-5-1593580452-31","review-flag-dea-1593580492-742","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Migrate SQL workloads to the cloud with confidence - 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\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrate SQL workloads to the cloud with confidence - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Wouldn\u2019t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence. That type of crystal ball is essentially what Microsoft gives us in the\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/\" \/>\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=\"2020-03-31T08:00:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-1024x683.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"683\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Migrate SQL workloads to the cloud with confidence\",\"datePublished\":\"2020-03-31T08:00:37+00:00\",\"dateModified\":\"2024-01-23T06:51:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/\"},\"wordCount\":603,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/\",\"name\":\"Migrate SQL workloads to the cloud with confidence - 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\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg\",\"datePublished\":\"2020-03-31T08:00:37+00:00\",\"dateModified\":\"2024-01-23T06:51:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg\",\"width\":2560,\"height\":1707,\"caption\":\"a person sitting at a table using a laptop\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrate SQL workloads to the cloud with confidence\"}]},{\"@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":"Migrate SQL workloads to the cloud with confidence - 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\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/","og_locale":"en_US","og_type":"article","og_title":"Migrate SQL workloads to the cloud with confidence - Microsoft SQL Server Blog","og_description":"Wouldn\u2019t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence. That type of crystal ball is essentially what Microsoft gives us in the","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2020-03-31T08:00:37+00:00","article_modified_time":"2024-01-23T06:51:25+00:00","og_image":[{"width":1024,"height":683,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-1024x683.jpg","type":"image\/jpeg"}],"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\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Migrate SQL workloads to the cloud with confidence","datePublished":"2020-03-31T08:00:37+00:00","dateModified":"2024-01-23T06:51:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/"},"wordCount":603,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/","name":"Migrate SQL workloads to the cloud with confidence - 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\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg","datePublished":"2020-03-31T08:00:37+00:00","dateModified":"2024-01-23T06:51:25+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/03\/Win19a_SMB_CrossA_0234-scaled.jpg","width":2560,"height":1707,"caption":"a person sitting at a table using a laptop"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/31\/migrate-sql-workloads-to-the-cloud-with-confidence\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Migrate SQL workloads to the cloud with confidence"}]},{"@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\/30150"}],"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=30150"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/30150\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/32028"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=30150"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=30150"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=30150"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=30150"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=30150"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=30150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}