(Scott Robinson) In the roll-your-own world of HTML, it’s easy to get swept up in the heady process of Web page creation and forget that we’re programming. Paradoxically, Web pages often become things of beauty in our eyes, as lovingly rendered as a painting. In those situations, we can lose sight o
Other News
Tips for improving INSERT performance in DB2 Universal Database
(Bill Wilkins) Improving the performance of database inserts is very important to managing a database, especially in an OLTP environment. This article explains exactly what happens when an insert occurs, looks at alternatives, and examines issues that affect insert performance, such as locking, inde
Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services
(Steve Callan) In this continuing series of installation cookbooks, we will look at a new and improved version of Oracle’s Application Server. This standalone release of Application Server, identified by “10g (9.0.4),” enables you to deploy forms (and reports) over the web without the overhead of in
Installing DB2 UDB on non-RPM Linux distributions
(Monty Wright) Installing DB2 UDB on a non-RPM Linux distribution presents some challenges. Author Monty Wright draws on direct customer experience to help you through the process.
File Watcher for SQL Server
(Muthusamy Anantha Kumar) SQL Server Database administrators often come across situations where the scheduled DTS jobs failed because the Source File didn’t arrive on time. It is a tedious process to cleanup if there are dependent jobs that have run before the first DTS job completed successfully. T
Get Weeks’ Start and End Dates
(Murthy Mamidanna) Here is a SQL query that lists the start and end dates of the weeks that passed in the month at any given date. For example, suppose that today’s date is 28 April 2003, and you want to list the start and end dates of the weeks (weeks are defined as starting on Monday and ending on
PRB: Cluster Group Containing SQL Server and MS DTC Moves Slowly
When moving a cluster group containing both Microsoft Distributed Transaction Coordinator (MS DTC) and SQL Server resources between nodes, it takes several minutes to take the resources offline and move the group to the other node. However, if the MS DTC resource is taken offline before moving the g
Federating Mainframe Data
(Karen Durward, Holly Hayes and Nelson Mattos) By some estimates, 60 percent of business data assets are housed in mainframes — and these assets are growing 20 percent every year. Meanwhile, the pool of skilled mainframe IT staff is shrinking. Entrants into the technology labor force don’t realize h
Real Best Practices from Real XML Projects
Consistently called a “must read” and a “practical guide to Web Services success” for Enterprises looking to deploy Web Services based solutions, this report presents a detailed adoption roadmap and 60 unique business case studies. Synthesized from over 200 hours of interviews with 117 senior execut
Working with VARRAYs in Oracle – Part II
(James Koopmann) In Part I of this series, we saw how to create an abstract data type and define an array within a table. The mechanisms for inserting data into this structure and selecting data from this structure was not too difficult but did require some thought processes and will no doubt look a