XML Workshop VI - Typed XML and SCHEMA Collection

The sixth installment of the XML Workshop for SQL Server shows how the XML Schemas fit into the XML subsystem. Regular author Jacob Sebastian brings structure to your XML documents with a few schema examples.

XML Workshop IV - FOR XML EXPLICIT

Continuing on with his series and quest to educate us DBAs on the capabilities of SQL Server 2005 with regards to XML, Jacob Sebastian looks at the FOR XML EXPLICIT clause.

XML Workshop I - Generating XML output using FOR XML with AUTO and RAW

Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities.

Advanced XML Processing

Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.

Which type of XML variable requires a\one and...

When you use the sp_xml_preparedocument stored procedure in...

What is the default type of XML data...

SQL Server 2005: Intro to XQuery

Longtime SQL Server expert Michael Coles brings us the second part of his his introductory look at XML in SQL Server 2005 with a short examination of XQuery, the way in which you can write queries on XML data.

Which is these is not necessary for a...

SQL 2005: Enter XML

SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.