(Roger McCoy) In this article, learn to take advantage of the compressed Extensible Markup Language (XML) format used by OpenOffice.org and similar programs to automate document editing. Learn to dissect OpenOffice.org’s OpenDocument Format (ODF) text files and make changes to your documents using s
Other News
Defining cascading referential integrity constraints in SQL Server
(Tim Chapman) Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the act
Shrinking Automatic Storage Tablespaces
(Chris Eaton) In DB2 9 you have the ability to create automatic storage tablespaces which can draw storage from the database defined storage pool as needed. In essence you can create a database with automatic storage by using CREATE DATABASE FOO ON C:, D:, E:
Time dimension – What should the key be?
(Simon Sabin) We are currently implementing a data warehouse and the design of the time dimension was recently being done.
Client Printing Support in SQL Server Reporting Using SOAP
(vikas chaudhary) As the reports rendered by the “Render()” web method do not support the toolbar provided in the “ReportViewer” control, it makes a difficult choice for a programmer to print reports from the application directly.
Threading on Multiple Cores in the .NET Framework
(Kevin Hoffman) Recently I’ve been doing a little bit of thinking about concurrency and multi-threading. Multi-threading is a fantastic tool, but it’s also a really big gun with which to shoot your foot. In other words: It’s a powerful tool and if it gets into the wrong (read: unprepared) hands, it
The Basics of Using the Factory Pattern in PHP 5
(Alejandro Gervasio) If you need to create multiple objects that belong to the same family, you probably want to use the factory pattern. This three-part series takes a close look at using the factory pattern in PHP.
A gotcha with parallel index builds, parallel degree and query plans
(Tanel Poder) Reading the following article about PARALLEL hint by Jonathan Lewis made me remember a somewhat related gotcha with parallelism.
10g Upgrade issues
(Dave) This weekend we are upgrading our E-Business Suite database from 9i to 10g (10.2.0.2 to be specific). Today while performing some final checks I noticed that an initialization parameter was not set properly in our test environment.
Implementing System p virtualization with DB2 and WebSphere using IBM Enterprise Workload Management
(Peter Kokosielis, Sunil Kamath, Mike Liu, Tony Lau and Mathew Thoennes) Learn the details of a solution that uses System p virtualization with DB2 and WebSphere using IBM EWLM in a J2EE environment. The solution exceeds service-level agreement (SLA) targets with stable, predictable response times.