A Generic Process to Convert XML Data - Part 1

Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.

Using XML to Enhance the Performance of String Manipulations

This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.

Performance Optimizations for the XML Data Type in SQL Server 2005

This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005. To get the most value from this paper, you need to be familiar with the XML features in SQL Server 2005. For background material, see XML Support in Microsoft SQL Server 2005 and XML Best Practices for Microsoft SQL Server 2005 on the Microsoft Development Network (MSDN)

XML Query

Loading XML data into SQL Server 2008

This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data

XML Storage

XML Workshop XXI - Generating an ATOM 1.0 Feed with FOR XML EXPLICIT

This long running, and very popular, XML series continues with a look at building an ATOM feed with SQL Server.

Name Spaces

Where is the Query in XQuery?

Michael David discusses how XQuery was designed from the ground up to process hierarchical XML data, but it is still missing capabilities that a hierarchical query processor product should have and did have originally.

Create a computed column in SQL Server using XML data

Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.