perfectxml.com
 Basic Search  Advanced Search   
Topics Resources Free Library Software XML News About Us
  You are here: home Info Bank Book Reviews » Professional SQL Server 2000 XML Tuesday, 14 August 2007
Book Review: Professional SQL Server 2000 XML
Professional SQL Server 2000 XML book is a complete and well-organized reference to learn the latest XML features introduced in SQL Server 2000 and it's XML integration Web releases. The book covers each and every detail with respect to utilizing SQL Server's XML features to build Web and Enterprise application. If you are a member or lead of any development team, and are planning to use SQL Server 2000 in your project, we recommend this book you'll learn many new ways to build database application with very less code that is manageable and efficient.

The book assumes that you have little XML experience, although Chapter 1 (20 pages) presents a nice introduction to XML and surrounding standards. The second chapter briefly talks about SQL Server 2000 XML features and reference to chapters where the individual topics are discussed in greater details. The third chapter focuses on "FOR XML" clause, discusses various options available with it and also how to using it with ADO. Next comes, OPENXML once again various T-SQL examples explain the OPENXML options and features, and there are two nice examples on using OPENXML with ADO. The following two chapters discuss (Annotated) XDR and XSD Schemas in detail and how to use them with SQL Server 2000.

One of the main features of SQL Server 2000 XML features includes direct access to data over HTTP. Accessing SQL Server data using URL Queries, XML Templates, using XPath syntax, Updategrams, etc. are the focus of next few chapters. Chapter 7 takes an in-depth look at XML templates, including the improvements made by the Web Release. Chapter 8 is specifically geared towards the XPath support in SQL Server.

Updategrams, a very important feature made available in Web Release 1.0, is discussed in great detail in Chapter 9. The three simple examples (to insert, delete, and update) nicely explain what the Updategrams and what they can be used for. Further, many examples discuss Mapping style, handling special characters, working with identity columns and GUIDs, data type conversion issues, parameter passing, using schema, etc. "Updategrams integrated with applications" - the next section in the chapter, features updategrams being called from HTML forms, ASP pages, VB code, etc. The following chapter discusses XML Bulk Load, yet another important feature introduced in Web release 1.0.

These ten main chapters are followed by five case studies that illustrate using XML in your legacy applications, as well as today's Web/Enterprise applications and also target towards your future projects where you can utilize SQL Server 2000's XML functionality.

The last pages of book conclude with nice appendices on creating/configuring virtual directories and XML view mapper. The final appendix describes the enhancements included in Web Release 2 (beta 1).

Overall, a must to have reference guide for all SQL Server developers, this book presents SQL Server XML features in the best possible way!

45%   (31 votes)

Would you recommend this book? :    Yes   No    
Additional Book Information

Professional SQL Server 2000 XML
Publisher:    Wrox Press
ISBN #:    1861005466
Authors:    Paul Burke, Sam Ferguson,
Denise Gosnell, Paul Morris,
Jan D Narkiewicz, J Michael Palermo,
Jon D Reid, Darshan Singh,
Brian Smith, Karli Watson,
Carvin Wilson, Warren Wiltsie
Publish Date:    June 2001
Code:    Download
Errata:    View/Submit
Online Discussions:    http://p2p.wrox.com/list.asp?list=sql_server

Sample Chapter on perfectxml.com

Chapter 6: XSD Schemas

Buy this book online

BookPool:    NA
Amazon:    $49.99
Fatbrain:    $39.99
Barnes & Noble:    NA
Chapters.ca:    $74.95

Summary of Contents

Introduction
Chapter 1: An Introduction to XML
Chapter 2: Overview of XML in SQL Server
Chapter 3: FOR XML
Chapter 4: OPENXML
Chapter 5: XDR Schemas
Chapter 6: XSD Schemas
Chapter 7: XML Templates and Views
Chapter 8: XPath
Chapter 9: Updategrams
Chapter 10: XML Bulk Load

Case Study 1: Enhancing Legacy Applications with XML
Case Study 2: An Order Entry System Using VB and XML
Case Study 3: Creating an XML Reporting System
Case Study 4: SOAP
Case Study 5: A .NET Case Study

Appendix A: Creating and Configuring Virtual Directories
Appendix B: Microsoft XML View Mapper 1.0
Appendix C: Web Release 2 - Beta 1

Index

  Contact Us | E-mail Us | Site Guide | About PerfectXML | Advertise ©2004 perfectxml.com. All rights reserved. | Privacy