Product Description:
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

Sponsored Links ( What's this? ) Feedback

• Connect for SQL/XML
  Create XML from relational data across any major database
  datadirect.com
  

• SQL Server 2000 XML Tool
  Develop SQL Server XML Applications SQLXML, Easy-to-use, D/L Free Trial
  www.altova.com/XMLSpy
  

• SQL Server-XML Mapping
  Allora bi-directional XML-RDB transformation GUI/engine.
  www.hitsw.com
  

Avg. Customer Review:
Write an online review and share your thoughts with other customers.

4 of 4 people found the following review helpful: Great companion resource to SQLXML BOL, February 15, 2003 Reviewer: "davidgabele" (Cleveland, OH USA) - See all my reviews This book is an excellent addition to the documentation provided with SQLXML, especially if you are just starting to use SQLXML. The book helps you decide if SQLXML is right for your situation. If it is, the book will continue to walk you through some real examples, covering some of the pros and cons of different methods. Being a developer, I highly recommend this book if you are using or considering to use SQLXML in a Microsoft environment. Was this review helpful to you?  (Report this)

0 of 26 people found the following review helpful: Too narrow, February 12, 2003 Reviewer: Fang Ine (Heliopolis, Egypt) - See all my reviews This book is technically competent, but goes right past the two most important factors; if you are developing XML, then you will probably be using Java, and that if you are developing applications (even with XML) on SQL server, then you are probably using COM+. Sorry. Was this review helpful to you?  (Report this)

1 of 2 people found the following review helpful: Ideal technical publication, December 8, 2002 Reviewer: "james_luetkehoelter" (Madison, WI United States) - See all my reviews This is what a technical publication should be. The book covers all aspects of SQLXML, from programming to administrative issues (including security concerns -- everyone needs to do more of that). It even discusses some of the other technologies out there, such as Oracle's integration with XML and the native xml datatype. If you are using or thinking of using SQLXML, I'd consider this book to be required reading. Was this review helpful to you?  (Report this)

3 of 3 people found the following review helpful: Comprehensive, Reality-Based Guidance, November 25, 2002 Reviewer: Joshua Allen (Seattle, WA United States) - See all my reviews    The people who wrote this book have a great deal of real-world experience using these technologies, and it shows. While the SQL Server product documentation and the first generation of SQL Server XML books are great for giving you a categorical treatment of the features, this book emphasizes the techniques that are proving to be most useful while providing experience-based warnings about potential pitfalls in other techniques. It's also great for getting perspective on pros and cons when you are designing something that could be implemented in multiple ways using SQL Server XML. Was this review helpful to you?  (Report this)

3 of 3 people found the following review helpful: Not to be missed - check out this excellent book!, November 24, 2002 Reviewer: mark horner (Melbourne) - See all my reviews SQL Server 2000 XML Distilled, from cover to cover its 100% professional & 100% technically absorbing. 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. Was this review helpful to you?  (Report this)

1 of 1 people found the following review helpful: Recommended for all SQL Server 2000 Developers and DBA, November 23, 2002 Reviewer: Sreekanth Reddy (Suwanee, GA USA) - See all my reviews Even though this book is one of the first attempts of Curlingstone press, the book is by far one of the best covering how to use XML in SQL Server. Most other books are copy cats of MSDN online refrence but this book stands out by covering SQL XML 3.0 in great detail and explains each and every topic with very good practical examples. 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. Was this review helpful to you?  (Report this)

See all 9 customer reviews...

MS SQL Server: by Golden Lion, Programmer

SQL Kick ass list!...: by Gone Haaaa, SQL Guru

XML & Web Services Books: by Darshan Singh, Managing Editor, PerfectXML

master XQuery, XSLT, XPath, SQLXML, XML, etc.: by Michael Brundage, author, technical lead for XML Query Processing at Microsoft

become a game programmer: by Jacob Marner, M.Sc. in Computer Science, Professional Game Programmer

become an Enterprise Architect (EA): by Edmon Begoli, An Enterprise Architect by Profession and Education

Browse similar items in Books:

• > Subjects > Computers & Internet > Databases > Database Management Systems
• > Subjects > Computers & Internet > Databases > General
• > Subjects > Computers & Internet > Databases > Specific Databases > SQL > General
• > Subjects > Computers & Internet > General
• > Subjects > Computers & Internet > Microsoft > Development > SQL Server
• > Subjects > Computers & Internet > Programming > Extensible Languages > XML

Search Books by subject:
Computer Bks - Data Base Management
Computer Books: General
Computers
Database Management - General
Database Management - SQL Server
Programming Languages - XML


i.e., each book must be in subject 1 AND subject 2 AND ...