Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
SQL Server 2000 Xml Distilled Paperback – October, 2002
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Full of helpful examples in T-SQL as well as VB6 and VB.NET. There are several other books out there that scratch the surface of XML support in SQL Server, but none of them are as complete as this one.
In addition to having a ton of examples this book also does a good job of explaining when to use each supported option.
Furthermore, plenty of performance data is provided to help you decide what will work best in your environment.
Curlingstone has really taken time to make this book as technically sound as it could be.
Whether you are a developer or a DBA keep this one handy!
I highly recommend for all the developers who want to get the data from SQL Server 2000 in XML format. The book also covers in great detail about programmatic access of SQLXML in VB6 and .NET.
If you are planning an integration with Biz Talk server and SQL server or if you are planning to expose your Stored procedures through Web services, I think this is the only book which covers those topics through case studies.
I strongly recommend this book to all SQL Server 2000 Developers and DBA's.
The content is mega interesting & discussed as you would use it here on planet-earth. It really gets into the juicy everyday issues.
For example, converting data-types, and modeling enumerations: from XML code to creating a table & then inserting values into the table.
Talk about nitty-gritty discussion: when it comes to OPENXML, in other books it's the same old story "it impacts performance", well that's not the case in this book - here there is a download file to setup and test, & a series of timing graphs supported with clear & objective discussion. The book even identifies an apparent level of fixed overhead for the number of elements that are parsed.
This book's approach is refreshing for any programmer working with Microsoft SQL 2000. It shows uses of xml technology with this relational database but spares the reader the frustrating "some day you be able" prehamble usually found in texts about recent technology.
Each topic is followed by ready-to-run samples. Of course XML technology is a bit foreign for relational database administrators, and these topics demand a fair degree of explanation. Anyway the book balances appropriately the theory/samples ratio.