by Kendall Grant Clark – Before setting off for PyCon, I finished an XML-Deviant column (“An XML Hero Reconsiders?”) in which I examined the XML development community’s reaction to some recent questions posed by Tim Bray about a perennial bugaboo, XML parsing strategies. To my surprise, the conversa
Author: SSWUG Research
Output large XML documents, Part 1
by Brett McLaughlin – This tip details the problems associated with outputting large XML documents, starting with an examination of the options for XML output. It then looks at DOM and XML output, along with possible solutions to the memory consumption associated with extended DOM usage. You’ll get
A Look at MSXML 4.0 RTM
By John Peterson – While I’m sure many of you know that Microsoft has released version 4.0 of their XML parser, for those of you who don’t, well you do now… and this should serve as your wake up call!
Oracle, Unisys Team on Transportation Security
By Lisa Vaas – Oracle Corp. and Unisys Corp. have been tapped by a Homeland Security agency to construct a single online spot to report security incidents relating to airlines and other transportation systems and for travelers to check on situations in flux.
How the Query Optimizer Uses Statistics
When the query optimizer in SQL Server 7.0 examines the distribution statistics of a composite index, does it take into account the statistics for each column in the index or just the statistics in the first column (assuming that this table has only index statistics, not column statistics)? If the o
I Will Never Have To Port This Code – Debunking shortcuts and SQL myths
by Joe Celko – If you hang around the database developer newsgroups, you’ll find rookie programmers who write their code with proprietary features of whatever SQL product they have. They argue that they’ll never have to port this code, so why bother to write standard SQL when you can gain some advan
HOWTO: Automate Word to Perform a Client-Side Mail Merge Using XML from SQL Server
This article demonstrates how to automate Microsoft Word 2000 from client-side script to perform a mail merge for labels. Word 2000 does not have a direct method for using XML data as the data source for a mail merge. The sample illustrates Active Server Pages (ASP) code that streams an XML recordse
Script to find the tablespaces within certain extents
By Prince Kumar – The following script finds the tablespaces that can extent to a maximum of "ExtLimit". In this case, I didn’t want any files to be more than 2 GB so I set MAXSIZE to 2 GB. Also, I did not include temp files in this script.
Cleaning Up SOAP’s Act
For SOAP to be enterprise-worthy, security must be an integral part of the Web services standard.
Generate .NET Code With XSLT
by Kathleen Dollard – Find out how to use Extensible Stylesheet Language Transformations to auto-generate classes that provide strongly typed access based on your database’s XML Schema Definition.