by Joe Celko – In my last column, I promised to discuss commodity identifiers: codes used to identify items that are handled in the aggregate, as a commodity.
Author: SSWUG Research
Marking Up Bureaucracy
by Paul Ford – If there is a perfect user of XML, it’s the huge, sprawling United States government. With thousands of diverse offices, from the Navy to National Park Service, each federal agency routinely exchanges gigabytes-worths of documents and data with other offices, businesses, and citizens.
Grab headlines from a remote RSS file
By Nicholas Chase – In this article, Nick shows you how to retrieve syndicated content and convert it into headlines for your site. Since no official format for such feeds exists, aggregators are often faced with the difficulty of supporting multiple formats, so Nick also explains how to use XSL tra
oXygen adds limited Relax NG-driven editing support
SyncRO Soft has released version 2.0.4 of oXygen XML Editor, adding, among other new features, initial support for validated editing against Relax NG schemas. But that initial support has some shortcomings that make it of limited value in its current state.
Using XPath with SOAP
by Massimiliano Bigatti – In the article I’ll show a JAXM Web Service for calculating statistics and a generic JAXM client that uses the service, demonstrating the use of XPath for generic data extraction.
How can I extract XML from SQL using DTS?
Using the DTS ActiveX Script Task it is pretty easy to accomplish something like this. Here is a script that I used to create a Package which was scheduled and executed successfully.
Export Customized XML from Microsoft Word with VB.NET
by A. Russell Jones – Learn to use Word automation from .NET to turn hard-to-process Word documents into customizable XML.
Eric Brown Discusses SQL Server—Past, Present, and Yukon
It’s been a busy year for SQL Server. Not only did it celebrate its 10th anniversary last winter, Microsoft is preparing a new version, code-named “Yukon,” that’s currently undergoing a round of early beta testing. MSDN Magazine recently talked to Eric Brown, a product manager for SQL Server, about
Converting Oracle Pro*C Programs to DB2 UDB
By Marina Greenstein – Changes in your database often mean changes to your application. This article explains the steps necessary during Oracle Pro*C program conversion to C with embedded DB2 SQL calls.
Locking Down the Grid
By Lisa Vaas – Core to security in Oracle Corp.’s upcoming 10g grid technology will be a component called Oracle Internet Directory, an LDAP directory with an Oracle database back-end that leverages the database’s scalability, high availability and security features, according to Oracle Chief Securi