XML

Investigating Errors With Extended Events

Production errors are hard to reproduce. Here's my go-to Extended Events session that captures errors with their full TSQL calling stack.

Generate XML documents efficiently

Believe it or not, there is a wrong and correct way when it comes to generating XML documents in SQL.

Parse TSQL Stack