{"id":1705,"date":"2013-02-13T12:25:30","date_gmt":"2013-02-13T17:25:30","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/jonathan\/?p=1705"},"modified":"2017-04-13T12:55:34","modified_gmt":"2017-04-13T16:55:34","slug":"graphically-viewing-extended-events-deadlock-graphs","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/","title":{"rendered":"Graphically Viewing Extended Events Deadlock Graphs"},"content":{"rendered":"<p>I&#8217;ve previously blogged about the <a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/multi-victim-deadlocks\/\" target=\"_blank\">changes to the xml_deadlock_report in Extended Events to support multi-victim deadlock analysis<\/a>.\u00a0 One of the side effects of this change was that the XML document for the deadlock report had to be modified to be able to accommodate multiple victim processes in the graph.\u00a0 As a result of this, the deadlock graphs that are provided by Extended Events in SQL Server 2008 cannot be saved and opened graphically inside of SQL Server Management Studio.\u00a0 If you attempt to open an Extended Events deadlock graph you will get an error similar to the following:<\/p>\n<h2><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image.png\"><img decoding=\"async\" style=\"background-image: none; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" alt=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb.png\" width=\"244\" height=\"87\" border=\"0\" \/><\/a><\/h2>\n<pre class=\"brush: plain; gutter: false; title: ; notranslate\" title=\"\">\r\nFailed to initialize deadlock control.\r\n        There is an error in XML document (1, 2).\r\n                &lt;deadlock xmlns=&quot;&quot;&gt; was not expected\r\n<\/pre>\n<p>Until recently there wasn&#8217;t anything you could do about this, but today there are two options for viewing the deadlock graph in graphical format; <a href=\"https:\/\/www.sqlsentry.com\/plan-explorer\/sql-server-query-view.asp\" target=\"_blank\">SQL Sentry Plan Explorer Pro<\/a> and SQL Server 2012 Management Studio.<\/p>\n<h2>Plan Explorer Pro<\/h2>\n<p>One of the new Pro features that was added in SQL Sentry Plan Explorer at the beginning of November 2012 was the ability to open deadlock graph .xdl files in Plan Explorer.\u00a0 The display is exactly the same display that you would get from Performance Advisor for deadlocks proactively collected during it&#8217;s monitoring, which really simplifies the analysis of the deadlock graph information.\u00a0 While I was beta testing the changes ahead of the public release, I mentioned that the XML from the deadlock graphs generated by Extended Events had a different output to support multi-victim deadlock analysis, and Brooke (the developer for Plan Explorer at SQL Sentry) asked for an example.\u00a0 A few hours later I had another beta build that handled the multi-victim deadlock graph format provided by Extended Events which is shown below.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image2.png\"><img fetchpriority=\"high\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" alt=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb1.png\" width=\"644\" height=\"395\" border=\"0\" \/><\/a><\/p>\n<h2>SQL Server 2012 Management Studio<\/h2>\n<p>I didn&#8217;t actually realize this until I was recording the next Insider Demo Video for our <a href=\"https:\/\/www.sqlskills.com\/joincommunity.asp\/\" target=\"_blank\">SQLskills Insiders Newsletter<\/a>, but SQL Server 2012 Management Studio has also been updated to handle the XML format output by Extended Events, and it also understands the multi-victim deadlock information.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image3.png\"><img decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" alt=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb2.png\" width=\"644\" height=\"150\" border=\"0\" \/><\/a><\/p>\n<p>However, if you compare the relative amount of information provided here, even if you use the hover tips on the individual processes, there is still a significant amount of information that is missing.\u00a0 For example, you don&#8217;t get the isolation levels of the processes in the graphical display at all, which can be important for troubleshooting specific types of deadlocks.<\/p>\n<p>If you haven&#8217;t given SQL Sentry Plan Explorer Pro a spin, I&#8217;d really recommend it.\u00a0 I had the opportunity to take the next Beta release of Plan Explorer Pro for a spin last night, and there are some really awesome new features coming that will make plan analysis faster and easier than you&#8217;ve ever experienced.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve previously blogged about the changes to the xml_deadlock_report in Extended Events to support multi-victim deadlock analysis.\u00a0 One of the side effects of this change was that the XML document for the deadlock report had to be modified to be able to accommodate multiple victim processes in the graph.\u00a0 As a result of this, the [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,23],"tags":[],"class_list":["post-1705","post","type-post","status-publish","format-standard","hentry","category-deadlock","category-extended-events"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias<\/title>\n<meta name=\"description\" content=\"Learn how to graphically display the in Extended Events deadlock graph XML produced by the xml_deadlock_report in SQL Server 2008 and SQL Server 2012.\" \/>\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.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Learn how to graphically display the in Extended Events deadlock graph XML produced by the xml_deadlock_report in SQL Server 2008 and SQL Server 2012.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-13T17:25:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:55:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"Graphically Viewing Extended Events Deadlock Graphs\",\"datePublished\":\"2013-02-13T17:25:30+00:00\",\"dateModified\":\"2017-04-13T16:55:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/\"},\"wordCount\":475,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/image_thumb.png\",\"articleSection\":[\"Deadlock\",\"Extended Events\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/\",\"name\":\"Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/image_thumb.png\",\"datePublished\":\"2013-02-13T17:25:30+00:00\",\"dateModified\":\"2017-04-13T16:55:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"description\":\"Learn how to graphically display the in Extended Events deadlock graph XML produced by the xml_deadlock_report in SQL Server 2008 and SQL Server 2012.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/image_thumb.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/image_thumb.png\",\"width\":244,\"height\":87},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/graphically-viewing-extended-events-deadlock-graphs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deadlock\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/deadlock\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Graphically Viewing Extended Events Deadlock Graphs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias","description":"Learn how to graphically display the in Extended Events deadlock graph XML produced by the xml_deadlock_report in SQL Server 2008 and SQL Server 2012.","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.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/","og_locale":"en_US","og_type":"article","og_title":"Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias","og_description":"Learn how to graphically display the in Extended Events deadlock graph XML produced by the xml_deadlock_report in SQL Server 2008 and SQL Server 2012.","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/","og_site_name":"Jonathan Kehayias","article_published_time":"2013-02-13T17:25:30+00:00","article_modified_time":"2017-04-13T16:55:34+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"Graphically Viewing Extended Events Deadlock Graphs","datePublished":"2013-02-13T17:25:30+00:00","dateModified":"2017-04-13T16:55:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/"},"wordCount":475,"commentCount":1,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb.png","articleSection":["Deadlock","Extended Events"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/","name":"Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb.png","datePublished":"2013-02-13T17:25:30+00:00","dateModified":"2017-04-13T16:55:34+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"description":"Learn how to graphically display the in Extended Events deadlock graph XML produced by the xml_deadlock_report in SQL Server 2008 and SQL Server 2012.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2013\/02\/image_thumb.png","width":244,"height":87},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/graphically-viewing-extended-events-deadlock-graphs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Deadlock","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/deadlock\/"},{"@type":"ListItem","position":3,"name":"Graphically Viewing Extended Events Deadlock Graphs"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/1705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=1705"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/1705\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=1705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=1705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=1705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}