There are many good articles available on the web about XML support in databases and especially SQL Server. But even the best articles can be nitpicked on (including my own :-)).
Check out the following posts (and the original articles) to get my take and constructive criticism on some recent web articles on XML and SQL Server:
- My comments on the Infoworld article "Databases flex their XML"
- Some comments on “Kiss the Middle-tier Goodbye with SQL Server Yukon”
- Tim Anderson's interview on SQL Server Yukon: Some clarifications
- Philip Howard's article for The Register on the recent announcement for the new XML support in an upcoming IBM database release.