Lately I have been working more and more with Extended Events and prior to that Cached Plans exploration.
And, has both are stored as XML, it makes sense to see what tools are available for accurately querying XML data. 740 more words
Once we have our Extended Events Session Setup and it is collecting data, we should occasionally check in and review the collected data.
I blogged a few times about XML flattening in the past :