← All presentations

XML Xtreme!

Download

Abstract

We’ve all had to work with XML at some point, and you may have even searched XML documents in a text editor. However, did you know you can query XML documents within SQL Server? In this session, I’ll show you how you can query XML documents as a data source alongside SQL Server tables and how to optimize your queries for better performance. You’ll learn how to check conditions that determine if the data you need exists and how to deal with incomplete or missing data.

Presented at:

  • Greater Lansing SQL Server (GLASS) & SQL PASS in Detroit (SPID), Michigan (Detroit & Lansing) on Oct 25, 2023 (virtual) (video)
  • Salt Lake City SQL Server Users Group on Oct 17, 2016
  • SQL Saturday #530, Indianapolis, IN on Aug 13, 2016