(Brian Moran) T-SQL is a powerful tool, but it doesn’t provide native language constructs to do all the operations you need to do, such as creating rank within a result set. I’m not going to describe how to impose order within a result set (read Itzik Ben-Gan’s T-SQL 2005 column “Ranking Functio

(Rajasekar Krishnamurthy, Raghav Kaushik, and Jeffrey F. Naughton) Recently, the database research literature has seen an explosion of publications with the goal of using an RDBMS to store and/or query XML data. The problems addressed and solved in this area are diverse. This diversity renders i

(Coach Wei) XML is a simple, flexible text format initially designed for large-scale electronic publishing. It is flexible, open, and human-readable, and can be learned easily. XML can also be generated, parsed, analyzed, and transformed easily. It’s no wonder that XML has been widely used for s

(Peter Mikhalenko) Several years ago the only way to work with a web site was through a personal computer. There were different browsers, some of which were text-based terminals and others that were GUI apps. It was assumed that the “normal” user had a machine with a large color display with full gr

(Uche Ogbuji) A critical issue in designing XML formats is figuring out how to arrange elements and represent relationships between them. Element design works best when it naturally corresponds to how people think about the concepts that each element represents. This article discusses best pract

(Bruce Silver) For 30 years, a few strident voices have warned us that the world is running out of oil. With low energy prices, it used to be easy for some to dismiss them as tree-hugging cranks, but now with oil costing more than $40 per barrel and rising, maybe their dire predictions are finally c

(Bernhard Borges, Kerrie Holley and Ali Arsanjani) In many respects, SOA is an evolution of the fundamental tenets governing component-based development (CBD). It also represents a quantum leap in bringing business and information technology into closer alignment through a set of SOA services ground

(Bob DuCharme) The Extensible Metadata Platform (XMP) is a specification describing RDF-based data and storage models for metadata about documents in any format. The specification includes information about embedding XMP in text files such as HTML and SVG/XML; image formats such as JPEG, TIFF, and G

You may use an object of the ServerXMLHTTP class to establish an HTTP connection to a Web site. When the Web site redirects your request to another Web site, the waitForResponse method of the ServerXMLHTTP class fails, and you receive the following error message: This method cannot be called unti

(Marc Clifton) I needed a simple serialization / deserialization mechanism to save and load state information for objects whose type (the class) is constructed and compiled at runtime. Neither XmlSerializer nor BinaryFormatter classes handle this scenario. So, I wrote a lightweight assembly to