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

Have you ever received an XML file from someone to import into SQL Server? It's not as easy as you might expect, especially in SQL Server 2000. New author Steve Moore brings us an article and code on how to do just that.   Read more...

Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.   Read more...

Robyn Page and Phil Factor almost dispel the myth that XML is boring, with their radical new SQL Server XML workbench.  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...

Learn how to upload multiple XML files to an SQL Server 2005 database XML data type column.  Read more...

Michael M. David returns to SQLSummit.com to explore two approaches to XML hierarchical structure transformations. He explains the difference between restructuring and reshaping XML data, with the latter driven by the semantics of the data structure.   Read more...

If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out your XSLT from your XDM.  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...

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

XML really makes it easy to move data from here to there and from there to here. However, eventually the data needs to be stored somewhere, most likely in a relational database. Here is how Edmond Woychowsky gets data from an XML document into a relational database.   Read more...

SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.   Read more...

This article explains how to transform a nebulous application requirement like "take a flat file that was produced by an upstream mainframe application and produce an XML document for a downstream application," into a flexible working solution.  Read more...

The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.   Read more...

XML is becoming more and more the mainstream for data transfers between systems. Web services and SOAP communications are built into SQL Server 2005, requiring the more and more DBAs understand how to work with XML. Raj Vasant has written a number of articles on XML and brings us a look at how XML should and should not be used.   Read more...

Have you ever received an XML file from someone to import into SQL Server? It's not as easy as you might expect, especially in SQL Server 2000. New author Steve Moore brings us an article and code on how to do just that.   Read more...

Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.   Read more...

SQL Server 2000 had extensions built in to allow you to work with XML data, however, most installations did not work with it. XML has proven that it is a very powerful way of transmitting and working with data, but creating it from relational data has proven to be difficult. New author Hugh Lynch, CTO of Restricted Stock Systems, Inc. brin gs us a method for easily creating XML from your SQL Servers.   Read more...