(Susan Visser) Congratulations to author and IBM Champion Tony Andrews on his new book:

(Dave Stokes) Optimizing MySQL Queries is often wrongly viewed by many DBAs as a ‘dark art’. For years we have been pre-pending EXPLAIN to SELECT statements in hopes of looking into the entrails of our offered code in hopes that the query optimizer deities looked whit favor on our efforts.

(Simon Harris and Susanne Englert) Combine InfoSphere DataStage and InfoSphere Federation Server to provide an efficient and flexible architecture for moving and transforming data. This article promotes the use of InfoSphere Federation Server as a “data pre-processor” for InfoSphere DataStage, and d

(Roman Kharkovski) I often get question from my clients on the footprint and start/stop speed of the WebSphere Application Server (WAS). If you ever installed WAS, you know that the download size is around 1.5 GB, takes at least 30 minutes to install and once you have it configured and start doing d

(Ember Crooks) In case anyone is wondering why I’m currently just barely managing one post a week, the first and most obvious reason is preparation for Black Friday/Cyber Monday. Retail clients really stress their databases on these days, and a bit of proactive work can go a long way.

(Benjamin Leonhardi and Saeid Modares) This article will build the basic foundation of a hardened, monitored, and secured Netezza environment. To achieve this, InfoSphere Guardium, IBM’s solution for database activity monitoring and auditing, will be used. Hardening Netezza with Guardium will be pre

(David Birmingham) In Part 1 of this article, we examined scalable capture of million and even billions of referential errors. The power available in an IBM PureData System for Analytics machine to use set-based techniques for finding and capturing referential disconnections utterly eclipses and com

(Adrian B. Jordan) This white paper explains the steps required to migrate an IBM WebSphere Portal v6.1 database to WebSphere Portal v8, using the IBM DB2 Administration Tool (DAT) v7.2 for DB2 Universal Database on z/OS. We focus on the DB2 migration utility, job execution, and troubleshooting the

(Ramazan Polat) Suppose that we have a table that contains duplicate rows and we want to eliminate any duplicate row while retaining the original row.

(Serge Rielau) The new PureData expert integrated systems are optimized for delivering data applications with simplicity and speed.