(Charles Hooper) As long time readers of this blog might know, in my free time during roughly the last 10 years I have been working on a program named “Hyper-Extended Oracle Performance Monitor”. Since 2005 or 2006 I have permitted a few people to try the beta versions of the program, thinking that
Other News
How To Build A Report with Multiple Children
(Jeff Smith) I was asked recently if SQL Developer supported multiple children reports. The answer is ‘yes’, and here is a post showing how to achieve this.
Removing a Member from a Data Sharing Group
(Troy Coleman) DB2 10 brings many resource improvements in the area of CPU reduction and virtual storage relief. For instance, Jeff Berger discusses capacity improvements in his article, “DB2 10 Conversion Mode.”
Fetching Multiple Rows
(Craig S. Mullins) When you need to retrieve multiple rows, consider deploying a multi-row fetch to transfer more than one row using a single FETCH statement. This capability was added as of DB2 Version 8.
What is XML Really About?
(Mark Baker) We all know that XML is a good thing. The pundits and the vendors all tell us so. XML opens up many possibilities for content. But exactly how (and why) it does so is not always made clear. Getting your content into XML is not, by itself, enough to deliver any or all of the things that
The Global Positioning of XML
(DaveMcG) XML is everywhere. If you don’t believe it, get a USB cable and connect a GPS device to a computer, then browse for any file with the extension .gpx. We quickly found a 2 MB file named Current.gpx on a Garmin GPS. Opening it in XMLSpy reveals XML data and an XML Schema assignment at the to
Troubleshooting SQL Server Performance Problems Using Internal vs. External Resources
(Brian Moran) I’ve been giving a lot of thought to the business and process side of SQL Server performance tuning over the past few months as I launch a new business. I’ve come up with an interesting observation that I’d like to share with you. I need to lump performance tuning scenarios into two di
Working with Dates and Times in PHP and MySQL
(Sean Hudgston) When working in any programming language, dealing with dates and time is often a trivial and simple task. That is, until time zones have to be supported.
Configure InfoSphere CDC with InfoSphere DataStage for real-time ETL
(Srinivasan R. Mottupalli) In this article, learn to configure the IBM data replication product called IBM InfoSphere Change Data Capture with the extract, transform, and load (ETL) tool InfoSphere DataStage, a component of IBM InfoSphere Information Server.
Application-Wide Help in SharePoint Using DVWPs and List-Based Content
(Marc D Anderson) In a recent client project, we wanted to offer some sort of online help capability. While SharePoint has a help capability built into it, we wanted something a bit different.