XML and SQL Server 2000 [Paperback]

John Griffin (Author)

Book Description

Publication Date: July 20, 2001 | Series: Landmark (New Riders)

XML and SQL Server 2000 will enable SQL developers to understand and work with XML, the preferred technology for integrating eBusiness systems. These developers have realized the need to be able to understand and work with high-speed storage and generation capabilities that XML documents and data offer. The pervasiveness of XML has finally caused the beginnings of the appearance of tools that allow easier manipulation of XML itself. SQL Server 2000 has added several new features that SQL Server 7 never had that make working with and generating XML easier for the developer. XML and SQL Server 2000 provides a comprehensive discussion of SQL Server 2000's XML capabilities. There is a brief discussion in the first two chapters on XSL/XSLT and DTD's targeted to database developers since most developers are new to this technology. From there, numerous examples are discussed in the areas of IIS Directories, http, XML views and XML schemas, openxml, and much more.

Editorial Reviews

From the Back Cover

XML and SQL Server 2000 will enable SQL developers to understand and work with XML, the preferred technology for integrating eBusiness systems. This book will provide a comprehensive discussion of SQL Server 2000's XML capabilities. There is a brief discussion in the first two chapters on XSL/XSLT and DTD's targeted to database developers since most developers are new to this technology. From there numerous examples are discussed in the areas of IIS Directories, http, xml views and xml schemas, openxml, and much more.

About the Author

John Griffin is currently Senior Applications Developer for Iomega Corp. in Roy, UT. He has worked in the computer industry in one form or another since 1969. Previous experience includes contract work for Sprint-Paranet of Houston, TX, systems administration for the Department of Defense, and serving in the U.S. Navy for nine years. He holds the MCNE, MCSE, MCP+I and A+ certifications. John lives in Layton, Utah with his wife, Judith, and Australian Shepherd, Maggie.

Product Details

• Paperback: 384 pages
• Publisher: New Riders Publishing; 1st edition (July 20, 2001)
• Language: English
• ISBN-10: 0735711127
• ISBN-13: 978-0735711129
• Product Dimensions: 8.9 x 6.9 x 0.9 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #3,548,379 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

4.0 out of 5 stars A Readable Guide, November 21, 2001

By 

R. Brunner (South Pasadena, CA United States) - See all my reviews

This review is from: XML and SQL Server 2000 (Paperback)

In this book, John Griffin has provided a readable discussion of how to incorporate XML into your SQL Server 2000 applications. Starting with a gentle introduction to both XML and XSLT, John quickly moves into incorporating SQL Server 2000 into web applications, including discussion on Virtual Directories, executing SQL via HTTP, and Forms based queries. He then moves onto advanced topics like XDR Schemas and XPath, before concluding with chapters on FOR XML and OPEN XML, which are both important Microsoft extensions to SQL that are explicitly designed to improve the performance of SQL Server 2000 with XML.
One of the only disappointments I had with this book was the neglect of Web Services, which I would expect would be a major reason for using XML with SQL Server 2000. This is not a major criticism, and might be addressed in later editions of the book. In any event, any serious SQL Server 2000 developer should take a look at this book.

4 of 4 people found the following review helpful:

2.0 out of 5 stars You have a FREE and BETTER alternative to this book!, November 15, 2002

By A Customer

This review is from: XML and SQL Server 2000 (Paperback)

Based on the average review scores this book got, I decided to acquire an electronic copy of it through DevX's online bookshelf. After reading this book, I feel cheated. You see, at about the middle point of my reading, I wanted to look up SQL Server 2000's Books Online (BOL) - which comes free with SQL Server install - for details of a certain item. Lo and behold, most of the examples and text in this book closely resembles the BOL's "XML and Internet Support" section. In fact, a lot of the content is almost verbatum copy. In order to make the book look different from the BOL, the author seemed to shuffle the content a little bit and tried to describe the technical points from a different approach than BOL. But he apparently did not do a good job of it. After going through this book, I still feel not clear on a lot of the technical details. So I went back to the BOL and got my questions answered there. It seemed to me that the author manufactured - I don't want to use the word WROTE - the book just to make some quick money. The only merit I'm willing to give this book is its chapters that summarize XSLT and XDR Schema.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Hundreds of hands-on examples, December 8, 2001

By 

Midwest Book Review (Oregon, WI USA) - See all my reviews

This review is from: XML and SQL Server 2000 (Paperback)

XML And SQL Server 2000 provides an informative, comprehensive, invaluable discussion of SQL Server 2000's new time-saving, easy-to-use XML capabilities. Following a brief discussion on XSL/XSLT and DTD's, users will find hundreds of hands-on examples that can be utilized in day-to-day operations in such areas as IIS Directories, http, xml views and xml schemas, openxml, and much more.