XML WITHOUT XANAX HOW TO HANDLE XML IN SQL SERVER

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. If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML. session you will be armed with the basic information needed to know how to properly backup the database so that you can recover it after a failure. You will learn how to properly maintain the database so that it runs at peek performance, while using the least possible space. You will also learn how to look for, and correct database corruption problems. 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 Hosted by Steve Cantrell of DBAFundamentals