(René Nyffenegger) Suppose I’m the owner of a shop where you can order daily deliveries of certain items.
Author: SSWUG Research
Oracle Database 11g to feature XML enhancements
(Mark Brunelli) The latest version of Oracle’s flagship database — Oracle Database 11g — includes a slew of new XML-related features and enhancements, an Oracle executive said. (R)
REBIND Magic with V8
(Bonnie Baker) As more and more companies are moving to DB2 for z/OS V8, which became generally available on March 1, 2004 (a significant while ago), I’ve noticed a general reluctance to REBIND after migration. I can only speculate as to the reasoning behind this inertia. It’s true that a rock at re
DB2 9 self-tuning memory management
(Paul Read and Eva Angelika Billich) Starting in IBM DB2 9, a new memory-tuning feature, self-tuning memory management, simplifies the task of memory configuration by automatically setting values for several memory configuration parameters. When enabled, the memory tuner dynamically distributes avai
StAX’ing up XML, Part 2: Pull parsing and events
(Peter Nehrer) The event iterator-based API provided by Streaming API for XML (StAX) offers a unique blend of advantages over other XML processing methods in terms of both performance and usability. Part 1 introduced StAX and described in detail its cursor-based API. In this article, delve deeper in
Gradient Background Tab Custom Control
(Scott Lysle) This article describes a quick and simple approach to creating a tabbed custom control with a gradient background. In this example, the standard Windows Forms tab control is extended to provide a persistent gradient background; this differs from using an approach where a gradient backg
Storing Binary Files Directly in the Database Using ASP.NET 2.0
(Scott Mitchell) In building a data-driven application, oftentimes both text and binary data needs to be captured. Applications might need to store images, PDFs, Word documents, or other binary data. Such binary data can be stored in one of two ways: on the web server’s file system, with a reference
How to select the first/least/max row per group in SQL
(Xaprb) Here are some common SQL problems, all of which have related solutions: how do I find the most recent log entry for each program? How do I find the most popular item from each category? How do I find the top score for each player? In general, these types of “select the extreme from each grou
Color Theory for Developers
(Jon Shemitz) Color theory may sound like a subject for the Art Department, not for developers. But we’ve all had the experience of choosing a color scheme using the property grid to select named colors and ending up with a really garish color scheme. In an ideal world it might be the case that only
XQuery, XSLT, and OmniMark: Mixed Content Processing
(Alexander Boldakov, Maxim Grinev and Kirill Lisovsky) Document-oriented XML usually has highly irregular structure in which elements might be mixed in unknown way. Processing such XML requires advanced data-driven facilities: push-style processing enriched with transformation rules and side-effect-
