XML, SQL Server, and You

2022

TL; DR

Everything you wanted to know about XML on SQL Server but were afraid to ask.

Session Details

Learn (almost) everything you need to know about handling XML in SQL server in one hour-long session. We will cover the basics of querying XML, covering common patterns you will encounter as well as more advanced tricks using the XQuery language. You'll learn how to construct XML from the data on your server. Finally, we'll look at the good, the bad, and the ugly of XML indexes. What they are, how they make your queries faster and, the problems they may cause you.

3 things you'll get out of this session

Barney Lawrence's other proposed sessions for 2026

(Almost) Everything You Wanted To Know About Purview Data Governance - 2026

An Introduction to Window Functions - 2026

DAX Explained Through Dance, Memes and Dad Jokes - 2026

Barney Lawrence's previous sessions

Data Linkage Options: MDM vs Splink (PySpark)

Comparison of various data linkage solutions.

The Metadata Driven Data Warehouse

Tired of writing the same old Insert/Update/Delete statements over and over? Is your pipelines folder overflowing? Need to get your new data warehouse up and running as fast as possible? Metadata (data about data) comes to the rescue and in this session we’ll show you how.

DAX as Dance-Contexts Explained

Dance your way to an understanding row and filter contexts in DAX.