Introducing: Extended Events Code Generator v1.0

Uniquely Identifying XML Nodes with DENSE_RANK

Adam Machanic — Mon, 03 Aug 2009 13:19:53 GMT

When working with XML in SQL Server, you might want to uniquely identify one node against another. But

Extended Events Code Generator v1.001 - A Quick Fix

Adam Machanic — Sat, 08 May 2010 23:34:22 GMT

If you're one of the estimated 3-5 people who've downloaded and are using my XE Code Generator , please

re: Introducing: Extended Events Code Generator v1.0

Derek Czarny — Wed, 12 Sep 2012 19:13:37 GMT

Thanks Adam, I was just trying to learn Extended Events by going through Jonathan's articles and began to write my own, when I jumped to the end of Jonathan's articles and found your function. That was exactly what I was trying to do.

re: Introducing: Extended Events Code Generator v1.0

Derek Czarny — Wed, 12 Sep 2012 20:34:31 GMT

I liked some of the examples on the deadlock extended events, where you can click on the xml output in the results and it opens in another query window. On line 309 in your code generator is

WHEN column_name = 'tsql_stack' THEN 'XML'

I modified it to get that same effect:

WHEN column_name in ('tsql_stack','xml_report') THEN 'XML'

re: Introducing: Extended Events Code Generator v1.0

Adam Machanic — Wed, 12 Sep 2012 23:49:56 GMT

Thanks, Derek. Are you aware of the newer version?

http://sqlblog.com/blogs/adam_machanic/archive/2010/05/08/extended-events-code-generator-v1-001-a-quick-fix.aspx

Unfortunately I don't think either version works (well?) with SQL Server 2012. I need to revisit, because I made some assumptions that are no longer true about how the XML output would look.