\nWhile working on validating my demos for the 24 Hours of PASS and my PASS Summit 2011 Precon – Extended Events Deep Dive, I noticed a significant, and breaking change to the Event XML output for the raw event data in the ring_buffer and file_target in SQL Server Denali. In SQL Server 2008 and 2008R2, the Event XML represented the output of XML data elements differently than in SQL Server Denali CTP3. A good example of this is the xml_deadlock_report output, which I previously discussed in my SQL Server Central article,\n<\/p>\n
\nIn SQL Server 2008 and 2008R2, the query to retrieve the deadlock graph from the system_health session was (excluding the work around that was included in the original article since the xml_deadlock_report was fixed in a later Cumulative Update and the latest Service Pack for SQL Server 2008 and 2008 R2).\n<\/p>\n
\r\nSELECT \r\n CAST(event_data.value('(data\/value)[1]', 'varchar(max)')) AS XML) AS DeadlockGraph \r\nFROM \r\n( SELECT XEvent.query('.') AS event_data \r\n FROM \r\n ( -- Cast the target_data to XML \r\n SELECT CAST(target_data AS XML) AS TargetData \r\n FROM sys.dm_xe_session_targets AS st \r\n INNER JOIN sys.dm_xe_sessions AS s \r\n ON s.address = st.event_session_address \r\n WHERE name = N'system_health' \r\n AND target_name = N'ring_buffer' \r\n ) AS Data \r\n -- Split out the Event Nodes \r\n CROSS APPLY TargetData.nodes ('RingBufferTarget\/event[@name="xml_deadlock_report"]') AS XEventData (XEvent) \r\n) AS tab (event_data);\r\n<\/pre>\n\nIf you run this same code in SQL Server Denali CTP3, the output will not be the xml_deadlock_report but instead the textual data that was included in the sub-nodes of the value node for the xml_deadlock_report events in the target. This unfortunately has broken a number of my scripts that were initially written for SQL Server 2008 and 2008R2 that expect the XML output as text in the value element as follows:\n<\/p>\n
\r\n<event name="xml_deadlock_report" package="sqlserver" id="123" version="1" timestamp="2011-09-15T23:29:02.851Z"> \r\n <data name="xml_report"> \r\n <type name="unicode_string" package="package0" \/> \r\n <value><deadlock-list> \r\n<victim-list> \r\n <victimProcess id="process806e2088"\/> \r\n <process-list> \r\n <process id="process806e2088" taskpriority="0" logused="10000" waitresource="DATABASE: 15 " waittime="1477" schedulerid="2" kpid="3720" status="suspended" spid="57" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2011-09-15T19:29:01.370" lastbatchcompleted="2011-09-15T19:27:21.193" clientapp="Microsoft SQL Server Management Studio \u2013 Query" hostname="SQL2K8R2-IE2" hostpid="4464" loginname="SQLSKILLSDEMOS\\administrator" isolationlevel="read committed (2)" xactid="68641" currentdb="15" lockTimeout="4294967295" clientoption1="671090784" clientoption2="390200"> \r\n <executionStack> \r\n <frame procname="" line="1" sqlhandle="0x01000100721ac42240ff1285000000000000000000000000"> \r\n <\/frame> \r\n <\/executionStack> \r\n <inputbuf> \r\nALTER DATABASE DemoNCIndex SET MULTI_USER \r\n <\/inputbuf> \r\n <\/process> \r\n <process id="process469b88" taskpriority="0" logused="10000" waitresource="DATABASE: 15 " waittime="1892" schedulerid="2" kpid="4188" status="suspended" spid="58" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2011-09-15T19:29:00.957" lastbatchcompleted="2011-09-15T19:29:00.947" clientapp="Microsoft SQL Server Management Studio \u2013 Transact-SQL IntelliSense" hostname="SQL2K8R2-IE2" hostpid="4464" loginname="SQLSKILLSDEMOS\\administrator" isolationlevel="read committed (2)" xactid="68638" currentdb="15" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"> \r\n <executionStack> \r\n <frame procname="" line="1" sqlhandle="0x010001008af5b714605a1f85000000000000000000000000"> \r\n <\/frame> \r\n <\/executionStack> \r\n <inputbuf> \r\nuse [DemoNCIndex] <\/inputbuf> \r\n <\/process> \r\n <\/process-list> \r\n <resource-list> \r\n <databaselock subresource="FULL" dbid="15" dbname="" id="lock83168d80" mode="S"> \r\n <owner-list> \r\n <owner id="process469b88" mode="S"\/> \r\n <\/owner-list> \r\n <waiter-list> \r\n <waiter id="process806e2088" mode="X" requestType="wait"\/> \r\n <\/waiter-list> \r\n <\/databaselock> \r\n <databaselock subresource="FULL" dbid="15" dbname="" id="lock83168d80" mode="S"> \r\n <owner-list> \r\n <owner id="process806e2088" mode="S"\/> \r\n <owner id="process806e2088" mode="S"\/> \r\n <\/owner-list> \r\n <waiter-list> \r\n <waiter id="process469b88" mode="X" requestType="wait"\/> \r\n <\/waiter-list> \r\n <\/databaselock> \r\n <\/resource-list> \r\n<\/deadlock> \r\n<\/deadlock-list> \r\n<\/value> \r\n <text \/> \r\n <\/data> \r\n<\/event>\r\n<\/pre>\n\nInstead in SQL Server Denali CTP3, the event output is as follows:\n<\/p>\n
\r\n<event name="xml_deadlock_report" package="sqlserver" timestamp="2011-09-17T18:49:03.654Z"> \r\n <data name="xml_report"> \r\n <type name="xml" package="package0" \/> \r\n <value> \r\n <deadlock> \r\n <victim-list> \r\n <victimProcess id="processf7034a18" \/> \r\n <\/victim-list> \r\n <process-list> \r\n <process id="processf7034a18" taskpriority="0" logused="144" waitresource="RID: 2:1:281:0" waittime="2394" ownerId="162349" transactionname="user_transaction" lasttranstarted="2011-09-17T11:48:48.410" XDES="0xff047120" lockMode="S" schedulerid="2" kpid="692" status="suspended" spid="58" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2011-09-17T11:49:01.247" lastbatchcompleted="2011-09-17T11:48:48.410" lastattention="2011-09-17T11:39:47.393" clientapp="Microsoft SQL Server Management Studio \u2013 Query" hostname="WIN-QSTGAPD63IN" hostpid="3004" loginname="WIN-QSTGAPD63IN\\Administrator" isolationlevel="read committed (2)" xactid="162349" currentdb="2" lockTimeout="4294967295" clientoption1="671090784" clientoption2="390200"> \r\n <executionStack> \r\n <frame procname="adhoc" line="1" sqlhandle="0x02000000303b01237c6994b4eab30fb77cbb5a8e46f2b2540000000000000000000000000000000000000000"> \r\nSELECT Column2 \r\nFROM TableB <\/frame> \r\n <\/executionStack> \r\n <inputbuf> \r\nSELECT Column2 \r\nFROM TableB <\/inputbuf> \r\n <\/process> \r\n <process id="processf7035168" taskpriority="0" logused="144" waitresource="RID: 2:1:271:0" waittime="7494" ownerId="162369" transactionname="user_transaction" lasttranstarted="2011-09-17T11:48:53.693" XDES="0xf7044dd0" lockMode="S" schedulerid="2" kpid="3244" status="suspended" spid="60" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2011-09-17T11:48:56.150" lastbatchcompleted="2011-09-17T11:48:53.693" lastattention="1900-01-01T00:00:00.693" clientapp="Microsoft SQL Server Management Studio \u2013 Query" hostname="WIN-QSTGAPD63IN" hostpid="3004" loginname="WIN-QSTGAPD63IN\\Administrator" isolationlevel="read committed (2)" xactid="162369" currentdb="2" lockTimeout="4294967295" clientoption1="671090784" clientoption2="390200"> \r\n <executionStack> \r\n <frame procname="adhoc" line="2" stmtstart="4" sqlhandle="0x020000002e8952007a6c36a78a2aa436877a27f57a0725c80000000000000000000000000000000000000000"> \r\nSELECT Column1 \r\nFROM TableA <\/frame> \r\n <\/executionStack> \r\n <inputbuf>\r\n\r\nSELECT Column1 \r\nFROM TableA <\/inputbuf> \r\n <\/process> \r\n <\/process-list> \r\n <resource-list> \r\n <ridlock fileid="1" pageid="281" dbid="2" objectname="tempdb.dbo.TABLEB" id="lockf7d4ff80" mode="X" associatedObjectId="2161727822326792192"> \r\n <owner-list> \r\n <owner id="processf7035168" mode="X" \/> \r\n <\/owner-list> \r\n <waiter-list> \r\n <waiter id="processf7034a18" mode="S" requestType="wait" \/> \r\n <\/waiter-list> \r\n <\/ridlock> \r\n <ridlock fileid="1" pageid="271" dbid="2" objectname="tempdb.dbo.TABLEA" id="lockf7d51380" mode="X" associatedObjectId="2089670228247904256"> \r\n <owner-list> \r\n <owner id="processf7034a18" mode="X" \/> \r\n <\/owner-list> \r\n <waiter-list> \r\n <waiter id="processf7035168" mode="S" requestType="wait" \/> \r\n <\/waiter-list> \r\n <\/ridlock> \r\n <\/resource-list> \r\n <\/deadlock> \r\n <\/value> \r\n <\/data> \r\n<\/event>\r\n<\/pre>\n\nIf you compare the two bold sections to each other you will notice the difference. In SQL Server 2008 and 2008R2, the value element is XML escaped entirely as text, but in SQL Server Denali CTP3, the value attribute contains a valid XML document as a child node in the XML itself. This has a significant impact to how you actually access the XML data in Denali CTP3. To read the XML Document, you have to switch from using the .value() XML function along with a CAST() operation to using a .query() operation on the Event XML specifying the deadlock node as a part of the .query() XPATH for it as shown in the following code example:\n<\/p>\n
\r\nSELECT \r\n event_data.query('(event\/data\/value\/deadlock)[1]') AS DeadlockGraph \r\nFROM \r\n( SELECT XEvent.query('.') AS event_data \r\n FROM \r\n ( -- Cast the target_data to XML \r\n SELECT CAST(target_data AS XML) AS TargetData \r\n FROM sys.dm_xe_session_targets AS st \r\n INNER JOIN sys.dm_xe_sessions AS s \r\n ON s.address = st.event_session_address \r\n WHERE name = N'system_health' \r\n AND target_name = N'ring_buffer' \r\n ) AS Data \r\n -- Split out the Event Nodes \r\n CROSS APPLY TargetData.nodes ('RingBufferTarget\/event[@name="xml_deadlock_report"]') AS XEventData (XEvent) \r\n) AS tab (event_data);\r\n<\/pre>\n\nThis same thing applies to all of the XML data elements including the sqlserver.tsql_stack and sqlserver.tsql_frame Actions. In addition other actions such as the sqlserver.plan_handle have similar changes that require changing the code to process the Event XML to capture the values being output.<\/p>\n","protected":false},"excerpt":{"rendered":"
While working on validating my demos for the 24 Hours of PASS and my PASS Summit 2011 Precon – Extended Events Deep Dive, I noticed a significant, and breaking change to the Event XML output for the raw event data in the ring_buffer and file_target in SQL Server Denali. In SQL Server 2008 and 2008R2, […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,38,40],"tags":[],"class_list":["post-513","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2008","category-sql-server-denali"],"yoast_head":"\n
Extended Events Changes in SQL Server 2012 | Jonathan Kehayias<\/title>\n<meta name=\"description\" content=\"Shows the changes in the Extended Events output in SQL Server 2012 for XML column elements on events using the xml_deadlock_report event as an example.\" \/>\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\/extended-events-changes-in-sql-server-2012\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extended Events Changes in SQL Server 2012 | Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Shows the changes in the Extended Events output in SQL Server 2012 for XML column elements on events using the xml_deadlock_report event as an example.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-21T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-02-07T06:02:47+00:00\" \/>\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=\"9 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\\\/extended-events-changes-in-sql-server-2012\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"Extended Events Changes in SQL Server 2012 – Event XML for XML data elements\",\"datePublished\":\"2011-09-21T08:00:00+00:00\",\"dateModified\":\"2013-02-07T06:02:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/\"},\"wordCount\":1816,\"commentCount\":0,\"articleSection\":[\"Extended Events\",\"SQL Server 2008\",\"SQL Server Denali\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/\",\"name\":\"Extended Events Changes in SQL Server 2012 | Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"datePublished\":\"2011-09-21T08:00:00+00:00\",\"dateModified\":\"2013-02-07T06:02:47+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"description\":\"Shows the changes in the Extended Events output in SQL Server 2012 for XML column elements on events using the xml_deadlock_report event as an example.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/extended-events-changes-in-sql-server-2012\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extended Events\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/extended-events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Extended Events Changes in SQL Server 2012 – Event XML for XML data elements\"}]},{\"@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":"Extended Events Changes in SQL Server 2012 | Jonathan Kehayias","description":"Shows the changes in the Extended Events output in SQL Server 2012 for XML column elements on events using the xml_deadlock_report event as an example.","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\/extended-events-changes-in-sql-server-2012\/","og_locale":"en_US","og_type":"article","og_title":"Extended Events Changes in SQL Server 2012 | Jonathan Kehayias","og_description":"Shows the changes in the Extended Events output in SQL Server 2012 for XML column elements on events using the xml_deadlock_report event as an example.","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/","og_site_name":"Jonathan Kehayias","article_published_time":"2011-09-21T08:00:00+00:00","article_modified_time":"2013-02-07T06:02:47+00:00","author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"Extended Events Changes in SQL Server 2012 – Event XML for XML data elements","datePublished":"2011-09-21T08:00:00+00:00","dateModified":"2013-02-07T06:02:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/"},"wordCount":1816,"commentCount":0,"articleSection":["Extended Events","SQL Server 2008","SQL Server Denali"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/","name":"Extended Events Changes in SQL Server 2012 | Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"datePublished":"2011-09-21T08:00:00+00:00","dateModified":"2013-02-07T06:02:47+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"description":"Shows the changes in the Extended Events output in SQL Server 2012 for XML column elements on events using the xml_deadlock_report event as an example.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/extended-events-changes-in-sql-server-2012\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Extended Events","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/extended-events\/"},{"@type":"ListItem","position":3,"name":"Extended Events Changes in SQL Server 2012 – Event XML for XML data elements"}]},{"@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\/513","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=513"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/513\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}