An Introduction to Querying XML With T-SQL

2022

TL; DR

Learn to query and manipulate with XML T-SQL

Session Details

XML is everywhere, it's probably already in your database and sooner or later you're going to need to get at the data inside it. This session will, in as short a time as possible, show you the key methods needed to start taking data out of a piece of XML and into your queries.

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.