Professional SQL Server 2005 Integration Services (Programmer to Programmer)

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach

Microsoft SQL Server 2005 Reporting Services 2005

Professional ASP.NET 2.0

Professional SQL Server 2005 Reporting Services

Xml

Professional SQL Server 2005 XML (Programmer to Programmer)

Format: Paperback
Author: Scott Klein
ReleaseDate: 11 January, 2006
Publisher: Wrox
Rating:

You Need this Book
The clear examples of creating XML Schema collections, altering them, etc. If you are considering using XML in SQL Server 2005, this book will pay for itself quickly. 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).

Clear, complete and well done book
After the web was set up, it wasn't long before people wanted to extract information from one system to incorporate into their own web page. The web was designed for people to read what was stored at a computer somewhere else.

For a quick example, go to www. books-on-line. com. At the upper left is a little box for you to enter an ISBN number. Put in a number and click on Get Prices. Then what happens is that the Books-On-Line web site goes to Amazon and gets up to the minute information and displays it back to you in a simple format.

As part of their ASP. NET design effort, Microsoft has added a new datatype called XML to their SQL Server database. This book is on using this new feature. It describes the data type. Talks about constraints, schemas, all the things you would expect. It then talks about the integrated features to facilitate the generation of XML code that can be sent out over the web.

XML is a major new concept in distributed computing. The book covers this aspect of the Microsoft approach and does so very well. It is complete and thorough and very well written.

excellent book
It went indepth about xml and how to use it with the new sql server 2005 datatypes. This was a very good book. 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.