Xml

Cast any string directly to XML with auto-escaping characters in SQL Server

Recently I had to look up the definition for a bunch of SQL objects and didn’t want to manually retrieve them manually in SSMS (with Create Scripts) or Visual Studio (by searching the object name in my TFS repository).

Read More

How to Show Better Execution Plans in Azure Data Studio

Azure Data Studio is starting to mature and some neat features are coming to the vscode-based (and now multidatabase and multiplatform) tool.

Read More