Two nice articles:
-
XML Support in Microsoft SQL Server 2005
- XML Best Practices for Microsoft SQL Server "Yukon"