XML, SQL Server, and You

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

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.

Speaker

Barney Lawrence has over a decade's experience on Microsoft data platforms working in social care, health and travel industries. He currently works as a Senior BI Developer for Jet2.com.

Barney Lawrence's Sessions

What's What and Who's Who? Cross System Record Linkage with Fabric

One SKU, Two SKU, Old SKU, New SKU

Data Linkage Options: MDM vs Splink (PySpark)

The Metadata Driven Data Warehouse

Buddy Panel

An Introduction to Data Vault

An Introduction to Querying XML With T-SQL

An Introduction to Window Functions

Introducing Tableau Relationships

XML, SQL Server, and You

DAX as Dance-Contexts Explained