Read more...

With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.  Read more...

Read more...

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.  Read more...

New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.  Read more...

An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.  Read more...

I prepared this version (my original did not used XML) By being helped by forums feedback from SQL central Forward it to yours peers.  Read more...

More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.  Read more...

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.  Read more...

New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.  Read more...

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.  Read more...

Checking XML indexs with a sample.  Read more...

In the fourth installment of this series, Jacob Sebastian moves on to SQL Server 2005 and the new XML capabilities that make working with XML data easier than ever.   Read more...

In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes.   Read more...

In part 2 of this series, Jacob Sebastion continues looking at XML in SQL Server 2000 with some advanced XML processing.  Read more...

How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.   Read more...

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!   Read more...

New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.   Read more...

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...