There's a great new article up on MSDN giving an overview of the XML Support in Sql Server 2005:
XML Support in Microsoft SQL Server 2005
How do I know its great? Well, because I contributed of course! Just a little, I did the section on SqlXml. Shankar Pal and Mark Fussell did most of it. Check it out for a great overview though.
Off to San Deigo tomorrow to get in a little golf before Tech-Ed. Demos and slides are mostly done, hopefully everyone will enjoy my talk. I've ended up with 23 slides, but that also includes a nice bulkload demo and an objects out of the database demo using SqlXml. Hopefully that will be “Extreme” enough for everyone.