Do you cringe whenever you have to look at an XML document?
Does the very thought of XML data living in your database make you scream?
Do you have a panic attack any time you have to parse XML?
If you answered yes to any of these questions, then this session is for you! We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
Adam Belebczuk is a Database Engineer & Consultant with over 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL development, performance tuning, high availability, & disaster recovery.