The Ghost in the Machine

Now that hierarchical data structures are popular again because of XML, their full hierarchical processing is still being limited to flat two dimensional linear path processing by relational processing. This will change when database professionals realize that ANSI SQL relational processing can now support full multipath nonlinear hierarchical processing.

Gain Space Using XML data type

This article is an attempt to explain the application of new XML support in SQL Server 2005 for efficient data storage and performance.

XML Workshop 24 - Modifying XML Documents Using XQuery Part 1

This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.

Table-Valued Function to Split Strings with Xml

Splits a string using the xml parser.

Split string using XML

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.

XML

Using the FOR XML Clause to Return Query Results as XML

The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in Books-on-Line. We challenged Bob Sheldon to make it seem simple. Here is his sublime response.

OPENXML

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part II

Continuing with his series on using auditing information to roll transactions forward or back, David McKinney shows us how to generate audit triggers using XML.

Overview of Native XML Web Services for Microsoft SQL Server 2005

Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.