Professional SQL Server 2005 XML

If you are considering using XML in SQL Server 2005, this book will pay for itself quickly. The clear examples of creating XML Schema collections, altering them, etc. are very helpful. The only problem with this book is that SQL Server 2005 does not fully support XML Schemas. Because this book was written using a beta product (I believe) perhaps the author could not have know exactly how the final version would shake out. However, partial support of standards is important to any developer. You often find out only by trial and error what is supported and what isn't. The Wrox web site offers nothing of the kind for this book. So buy this book, but be aware if you are using complex XML Schemas there may be some surprises (e.g., notation not supported).

This was a very good book. It went indepth about xml and how to use it with the new sql server 2005 datatypes. He covers all aspects of xml in sql and how to best use them. Other major new features like using the clr in sql are also covered. I also liked the real world full examples the author provides.

SQL Server 2005's XML integration is a much deeper topic than most developers presume at this point, the XML data type is not all there is to "it", I assure you. The book explores all kinds of interesting facets of SQL Server's XML integration including my personal favorite, an appendix that explains XQuery in a comprehensive manner for those traditional TSQL coders. I am beginning the transition myself, from Technical Editor TE to an author via online articles and books, but I will always be available as a TE for Scott! Scott, you rock dude! And I look forward to your next book!