(ScaryDBA) I just found my first fundamental difference between execution plans in SQL Server 2005 and SQL Server 2008. In 2005 when you run an query and have it display an XML execution plan by issuing the statement SET STATISTICS XML ON you get a second result set that includes a URL. The same thi

(Rick Jelliffe) Charles Goldfarbs idea of using grammars to represent documents has proven itself useful in many situations, and the DTD legacy lives on in ISO RELAX NG and W3C XSD. However, there are many structures that regular grammars, as conventionally implemented, cannot cope with. And it is p

(Joe Pluta) I’ve been writing about Service-Oriented Architecture (SOA) for some time now. I did a complete review of the state of the technology in an article I wrote back in November of 2004. In that article, I commented that SOA is really the latest version of client/server technology, except tha

(Leonard Anghel) Learn how to use the DOMImplementationDS and DOMConfiguration classes to validate an XML document only when a DTD document can be found:

(Tyler Anderson) The Ruby on Rails framework has handy XML features that will make developing with and serving database data in XML format to your JavaScript applications easier than ever. JavaScript also has built-in XML parsing capabilities that make it a snap to receive and parse data in XML form

(Ben Nadel) When I was working on my XmlDeleteNodes() user defined function, I ran into a weird issue involving the ARGUMENTS scope and implict array notation. This feels very much like a bug to me, but I am not 100% sure. With my XmlDeleteNodes() method, you could pass in either a single node or an

(John Charles Olamendy) This article is intended to illustrate the principles and techniques used to build reports using Reporting Services. Reports are important components of enterprise applications and are mainly used to provide a descriptive and summary view of your data in order to discover inf

(Ben Nadel) Yesterday, I was working on an audit system that stored data at XML when I needed to delete a bunch of XML nodes from a particular document. I don’t spend a lot of time manipulating ColdFusion XML documents; most of my work with them has been either creating them and searching them using

(Ivan Pepelnjak) When transforming the WordProcessingML documents, I wanted to output an IMG element that would contain the HREF attribute equal to the picture name used in the Word file (assuming the picture is linked, not just inserted). However, the picture name in the Word file usually contains

(Michael Galpin) This is the second article in a four-part series about using XForms, IBM DB2 pureXML, and Ruby together to more easily create Web applications. In this series you will develop a hypothetical application for managing patient information at a doctor’s office. You will get a taste of t