Since we are currently talking about SQL Server 2005 in our MSDN event live, here is a great article on XML in SQL 2005.

http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5xml.asp