Book By Cary Millsap – Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In Optimizing Oracle Performance, Ca
Author: SSWUG Research
User-defined Aggregate Functions in DB2
By Knut Stolze – This article presents an approach for achieving specific aggregations. The technique employs the built-in aggregate function MAX to perform the actual aggregation, and several features that are available for scalar user-defined functions (UDFs) to provide the special needs required
The current state of database research
Senior database researchers gather every few years to assess the state of database research and to recommend problems and problem areas that deserve additional focus. This report summarizes the discussion and conclusions of the sixth ad-hoc meeting held May 4-6, 2003 in Lowell, Mass. It observes th
Microsoft Windows Small Business Server 2003 Released To Manufacturing, Slated To Ship Oct. 9
By Paula Rooney – Microsoft’s Windows Small Business Server 2003 has been released to manufacturing and will officially ship on Oct. 9, Microsoft said.The product, developed under the code name Bobcat, has been redesigned to simplify the installation and deployment for solution providers tha
IBM Expands its Toolbox
IBM DB2 and IMS Tools, formerly IBM Data Management Tools, announced 16 new and enhanced tools for better performance.
Replication Agent for DB2 – Troubleshooting TCP/IP Connectivity
This document addresses initial troubleshooting procedures for the Replication Agent for DB2 product for TCP/IP connectivity.
An Introduction to StAX
by Elliotte Rusty Harold – Most current XML APIs fall into one of two broad classes: event-based APIs like SAX and XNI or tree-based APIs like DOM and JDOM. Most programmers find the tree-based APIs to be easier to use; but such APIs are less efficient, especially with respect to memory usage. An in
Enhance Ant with XSL transformations
By Jim Creasman – Ant is a powerful tool for scripting build processes. When combined with XSLT, Ant’s power and flexibility increase dramatically. Here, Jim explains and illustrates this concept using real world examples from his previous experience.
Serialize Arrays and ArrayLists to XML
The XmlSerializer class provides a great way to convert (serialize) objects to XML and back (deserialize). However, it can be difficult to properly serialize collections such as Arrays and ArrayLists unless you know a few tricks.
Find out space used in all db’s (oneliner) :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 7.x and later Description: