XML Data Modification Language Workbench

XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases, this is the most efficient way to modify elements in an XML column, yet the techniques of using XML-DML have not been well, or simply, described - up until now. Robert Sheldon presents a practical workbench to show the various modify methods

XML XQuery problem

Processing XML files with SQL Server functions

Loading and processing XML files into SQL Server tables can be simple, thanks to a method that uses SQL Server functions and XPath expressions.

XML Workshop XXIII - A TSQL ATOM Library

MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.

Creating Hierarchical Data Structure Mashups

You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.

Improved XML Support in SQL 2008

XML Import Solution

This article explores how we can import XML into SQL Server using a powerful open source tool called XMLStarlet

XML Workshop XXII - A TSQL RSS Library

RSS feeds are becoming almost required for any type of data publication. SQL Server MVP Jacob Sebastian brings us the next installment of his XML Workshop series that looks at a series of T-SQL functions to generate the RSS formatted data.

Navigationless Database XML: Hierarchical Data Processing

Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL.

A Generic Process to Convert XML Data - Part 2

Continuing with his series on loading and transforming XML data, Leo Peysakhovich shows how to create the generic process to perform the convesions.