How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.  Read more...

Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article the author concentrates on the FOR XML clause in SQL Server versions, 2000 and 2005. Click on title for more  Read more...

Use XQuery scripting language to retrieve specific XML data type values in SQL Server. Learn to script and use Value() and Query() to retrieve single and multiple XML values.  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.  Read more...

Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.  Read more...

Continuing on with his series, Jacob Sebastian shows how you can shape the query results to a certain pre-defined XML structure in this article.  Read more...

The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.  Read more...

SQL Server 2005 has greatly expanded the XML capabilities of this platform, but should you use it in your database? New author and MVP Simon Munro brings us a look at how he has used XML and where it might fit in your database.   Read more...

By adding XML-based documentation capability to your SQL code, you can automatically extract and format tagged comments into a complete API documentation set for your SQL libraries.   Read more...

Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.  Read more...

Learn performance impacts of the XML data type and VARCHAR (MAX) data type in SQL Server 2005. Here are storage, I/O and CPU results of XML in SQL Server.  Read more...

Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page.   Read more...

This article will quickly dive head first right into XML.   Read more...

Read more...

Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.  Read more...

Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.  Read more...

This white paper consolidates general information, best practices, and tips for designing Microsoft SQL Server Reporting Services (SSRS) reports. It is intended to provide a starting point for design questions and an overview of some of the capabilities of Reporting Services.  Read more...

Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.  Read more...

Use familiar XML markup to extend the capabilities of your relational database.  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.  Read more...

Continuing with his series on XML in SQL Server 2005, Jacob Sebastian brings us a number of examples on how to work with XML in different situations with SQL Server 2005.   Read more...