Novick Software SQL Server Consulting Design Programming Training  

  sql server mvp



SQL Server 2000 XML Distilled

Authors: Andrew Novick, Kevin Williams, Daryl Barnes, Bryant Likes, Stephen Mohr, Paul Morris, Andrew Polshaw, Simon Sabin, Jeni Tennison

Buy from

Publication date: October 2002
ISBN: 1-904347-08-8
Price: $49.99
Page count: 600
Publisher: Apress (Originally Curlingstone)  

Download an updated
version of the SQL XML
Demonstration Utility
now in C#

Download the programs and example files from the publisher here!

XML is one of a family of web standards for data description, validation, manipulation, and interchange. It enables the construction of application-specific data languages, which can be handled by generic tools. Its other main benefits are its platform independence, self-describing structure, and human readability. All the big relational database vendors are adding XML support to their databases and their confidence in XML as a maturing data standard is strengthening. Microsoft's commitment to XML extends beyond the database to include application and presentation layers, particularly in .NET. The nascent field of web services will depend on the effective interface between relational databases and the XML messages that link them.

SQL Server 2000 XML Distilled is for you if:

  • You are an experienced SQL Server professional (a DBA or data-tier developer) with a knowledge of the basics of XML who is being asked either to present relational data in an XML format, or to store XML data
  • You are wondering what the motivation is in combining SQL Server 2000 and XML
  • You want to understand what support SQL Server 2000 provides for these tasks
  • You need the detail on the latest SQL Server XML features provided in SQLXML 3.0
  • You are concerned about the security and performance consequences of the design choices you make

    SQL Server 2000 XML Distilled shows you:

  • Where XML as a data model makes sense
  • When and how best to get both relational databases and XML to work together
  • How to set up and configure the SQL Server XML environment
  • How to query SQL Server data and return an XML format FOR XML, URL, and template queries
  • Ways to map between relational and XML schemas
  • SQL Server Annotated Schemas, XML Views, and XPath queries
  • How to store XML data in a relational database OPENXML, Updategrams, and SQLXML BulkLoad
  • .NET support for XML in SQL Server 2000 SQLXML Managed Classes and DiffGrams
  • Case studies of multi-client data access and Biztalk working with SQL Server 2000
  • The future of XML support in SQL Server web services and XQuery

    Table of Contents:

    Chapter 1: SQL Server XML and the DBA
    Chapter 2: Architecture and Setup
    Chapter 3: Mapping Data from SQL Server to XML
    Chapter 4: FOR XML
    Chapter 5: URL Queries and Template Queries
    Chapter 6: Annotating schemas
    Chapter 7: XML Views
    Chapter 8: XPATH Queries
    Chapter 9: Mapping Data from XML to SQL Server
    Chapter 10: OPENXML
    Chapter 11: Updategrams
    Chapter 12: SQLXML Bulk Load (Andrew Novick)
    Chapter 13: Programmatic Access with SQLXML (Andrew Novick)
    Chapter 14: SQL Server as a Web Service
    Chapter 15: Case study: Detecting Web Site Clients
    Chapter 16: Case Study: BizTalk Integration
    Chapter 17: Emergent Technologies
    Appendix A: XPATH Reference
    Appendix B: XML Schema Reference
    Appendix C: A Query Tool (Andrew Novick)

  • RSS as HTML

    information about novick software site

    Personal Blog


    New Tips:

    Use dsinit to set the SQL Server instance for Windows Azure dev storage


    Nov 7, '12
    Loser: DB

    Full Schedule



    Available Now

    User-Defined Functions

    Get it wtih the Bonus 100 UDF Library

    Latest News

    Novick Software Celebrates 10 Years in Business