Play Podcast  (Right click to download)

Remember when it was called just plain, old “data,” instead of “data assets”? In a very competitive world, and a very regulated environment, companies these days use databases to combine traditional online access with reporting and decision-support. More and more frequently, companies save data from every click a customer makes on their Web sites, then analyze them for sales and marketing. And, of course, there are the compliance issues around Sarbanes-Oxley, which mandates that businesses must keep copies of voicemail, instant messages, e-mail, and much more to provide reports on your data’s initial, transient, and existing states at a moment’s notice. So, your enterprise’s database has become a real differentiator, and so has its performance.

In this podcast interview, two of IBM’s tech gurus, Paul Zikopoulos and Dwaine Snow, come out of the lab to talk about one tool they think can make a positive difference in the DBA’s worklife, and in the database’s value: the Query Patroller. And in this fast-paced interview, they cover the nuts-and-bolts of what the tool does and how to use it, best practices about implementing it, anecdotes about customers’ experiences with Query Patroller, and more.

Podcasts for RSS readers -  (Get Media Player)
RSS2 feed for audio podcasts for MP3 players -   or 

Related Article

Taking Control: DB2 Query Patroller

by Paul C. Zikopoulos and Dwaine R. Snow

Remember when it was called just plain, old “data,” instead of “data assets”? In a very competitive, and regulated, world, companies these days use databases to combine traditional online access with reporting and decision-support. And, of course, there are the compliance issues around Sarbanes-Oxley, that mandate even more data storage and reporting. So, your enterprise’s database has become a real differentiator, and so has its performance. In this podcast interview, two of IBM’s tech gurus, Paul Zikopoulos and Dwaine Snow, come out of the lab to talk about one tool they think can be a major positive in the DBA’s worklife, and in the database’s value: the Query Patroller.

Resources

DB2 Query Patroller - Product Overview

DB2 Query Patroller and the DB2 Design Advisor

Bios

Paul C. Zikopoulos BA, MBA, is an award-winning writer and speaker with the IBM Database Competitive Technologies team. He has more than ten years of experience with DB2 products and has written numerous magazine articles and books about it. Paul has co-authored the books DB2 Version 8: The Official Guide, DB2: The Complete Reference, DB2 Fundamentals Certification for Dummies, DB2 for Dummies, and A DBA's Guide to Databases on Linux®. Paul is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). Currently he is writing a book on the Apache Derby/IBM Derby database.

Dwaine R. Snow is a senior product manager for DB2 UDB and focuses on competitive technologies. Dwaine has worked with DB2 UDB for the past 14 years as part of the development team focusing on the database engine and tools, the development of the DB2 Certification program, and as part of the lab-based consulting team. Dwaine has presented at conferences worldwide, contributed to the DB2 tutorial series, and has written a number of articles and coauthored books on DB2 including The Advanced DBA Certification Guide and Reference for DB2 Universal Database for Linux, UNIX®, and Windows, DB2 UDB for Windows, The DB2 Cluster Certification Guide, and the second edition of the DB2 Certification Guide for Linux, UNIX, and Windows. Dwaine is a DB2 Certified Solutions Expert in both Database Administration and Application Development, as well as a Certified Advanced DBA. He has also worked extensively onsite with customers in planning and implementing both transaction-based and data warehouse systems.

Production Credits

Dana Farver, Executive Producer, Communities Editor-in-Chief
Tom Parish, Audio Producer, Show Host
Kimberly Stone, Web Development Manager
Scott Ebner, Web Developer