Investigating Errors With Extended Events
This is my go-to technique to capture errors which I can debug later.
XML
Generate XML documents efficiently
Believe it or not, there is a wrong and correct way when it comes to generating XML documents in SQL.