{"id":14501,"date":"2015-12-15T12:00:00","date_gmt":"2015-12-15T20:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/"},"modified":"2024-01-30T10:23:36","modified_gmt":"2024-01-30T18:23:36","slug":"planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/","title":{"rendered":"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3"},"content":{"rendered":"\n

Step 2: Target destinations for each application and workload<\/h1>\n\n\n\n

As you know, the end of support deadline for SQL Server 2005 is on April 12, 2016. In this three- part blog series, we are discussing important steps to take as you plan your upgrade. In our last post, we walked through the importance of discovering what\u2019s running in your IT environment <\/a>before you begin the actual upgrade process. Running the Map Assessment Tool Kit <\/a>can really help get you on track for developing an efficient upgrade plan.<\/p>\n\n\n\n

After you\u2019ve collected data on what\u2019s running in your IT environment, the next step to think about is where you\u2019ll run your upgraded databases. When it comes to modernizing your data platform, you have a few options for where to move applications and workloads. You can upgrade your on-premises servers, implement virtual machines or move to the cloud \u2014 most likely you\u2019ll choose some combination of the three.<\/p>\n\n\n\n

We\u2019ve put together the SQL Server Upgrade Target Decision Tool <\/a>to help you think through this process, compare your options, and identify upgrade targets based on your individual business needs.<\/p>\n\n\n\n

Consolidation and virtualization<\/h1>\n\n\n\n

Upgrading is the perfect time to look for ways to gain efficiency and manage performance \u2014 in this case, we\u2019re talking about consolidation and virtualization. The following diagram highlights how you might approach consolidating and virtualizing your applications and workloads as well as taking Web applications to the cloud with Azure SQL Database.<\/p>\n\n\n\n

\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

You can move certain applications and processes to upgraded on-premises servers to get the reliable performance you need for mission-critical tasks.<\/p>\n\n\n\n

If you choose to virtualize using Windows Server Hyper-V or Azure VMs, one of the great benefits of virtualization is that you can run multiple applications or workloads on the same server while each maintains its own separate environment. Another benefit is that Azure VMs help further reduce total cost of ownership and increase availability. Because Azure VMs are hosted in the cloud, you can leverage the high availability of Microsoft\u2019s cloud infrastructure while reducing capital expense for purchasing your own hardware and related IT costs.<\/p>\n\n\n\n

Another option is to consolidate multiple databases or instances using Windows Server and Hyper-V to reduce IT sprawl, increase efficiency and free up resources for new tasks.<\/p>\n\n\n\n

Moving your Web applications to the cloud and reducing administration is possible using Azure SQL Database, which is a database-as-a-service in the cloud. With this option, you get the benefits of a cloud infrastructure with enterprise-grade security and scale, high availability, superior performance and near-zero maintenance.<\/p>\n\n\n\n

Ready for increased ROI?<\/h1>\n\n\n\n

According to a Microsoft-commissioned Forrester Consulting study<\/a>1<\/span>, analysis based on information from interviewed businesses resulted in a 9.5-month payback when migrating to SQL Server 2012 or 2014. Check out the SQL Server Upgrade Target Decision Tool<\/a> to compare target impacts and specific upgrade features.<\/p>\n\n\n\n

For more detailed information to help you plan your custom data platform upgrade, take a look at Directions from Microsoft\u2019s report, \u201cMigrating From SQL Server 2005<\/a>.\u201d<\/p>\n\n\n\n

In the final blog in this series, we\u2019ll talk through some common upgrade strategies. Come back here to learn ways to approach the upgrade process effectively.<\/p>\n\n\n\n

1<\/sup><\/i>Microsoft-commissioned Forrester Consulting study: The Total Economic Impact\u2122 of Microsoft SQL Server, July 2014<\/i><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Step 2: Target destinations for each application and workload As you know, the end of support deadline for SQL Server 2005 is on April 12, 2016. In this three- part blog series, we are discussing important steps to take as you plan your 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":[],"content-type":[2424,2448],"topic":[],"coauthors":[2487],"class_list":["post-14501","post","type-post","status-publish","format-standard","hentry","content-type-best-practices","content-type-updates","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-5-1593580452-31","review-flag-9-1593580472-173","review-flag-forre-1680212574-146","review-flag-free-1593619513-128","review-flag-lever-1593580264-545","review-flag-micro-1680215164-570","review-flag-new-1593580247-437"],"yoast_head":"\nPlanning an efficient upgrade from SQL Server 2005: Step 2 of 3 - 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\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Step 2: Target destinations for each application and workload As you know, the end of support deadline for SQL Server 2005 is on April 12, 2016. In this three- part blog series, we are discussing important steps to take as you plan your upgrade.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/\" \/>\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=\"2015-12-15T20:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-30T18:23:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3\",\"datePublished\":\"2015-12-15T20:00:00+00:00\",\"dateModified\":\"2024-01-30T18:23:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/\"},\"wordCount\":544,\"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\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/\",\"name\":\"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3 - 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\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png\",\"datePublished\":\"2015-12-15T20:00:00+00:00\",\"dateModified\":\"2024-01-30T18:23:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3\"}]},{\"@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":"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3 - 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\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/","og_locale":"en_US","og_type":"article","og_title":"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3 - Microsoft SQL Server Blog","og_description":"Step 2: Target destinations for each application and workload As you know, the end of support deadline for SQL Server 2005 is on April 12, 2016. In this three- part blog series, we are discussing important steps to take as you plan your upgrade.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-12-15T20:00:00+00:00","article_modified_time":"2024-01-30T18:23:36+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png","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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3","datePublished":"2015-12-15T20:00:00+00:00","dateModified":"2024-01-30T18:23:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/"},"wordCount":544,"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\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/","name":"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3 - 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\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png","datePublished":"2015-12-15T20:00:00+00:00","dateModified":"2024-01-30T18:23:36+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/SQL121515.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Planning an efficient upgrade from SQL Server 2005: Step 2 of 3"}]},{"@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\/14501","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=14501"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14501\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=14501"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=14501"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=14501"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=14501"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=14501"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=14501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}