This presentation covers the new XML Features in SQL Server 2005. It is divided into two general areas, the first being enhancements to existing features such as the "For XML" clause and the OpenXML function. The second half of the presentation covers new features such as the new XML data type as well as the ability to query your XML Data using XQuery.
Please note that the data for this demo uses the Adventureworks database that was installed as part of SQL Server 2005. There are some instances where the installation does not include 2005 ( a bug I believe). If you have encountered this, you can find it here