(Paul C. Zikopoulos) The IBM DB2 Universal Database product (DB2 UDB) comes with countless features and capabilities, among them the DB2 Query Patroller product.
Other News
How To Encrypt Data in Oracle Using PHP
(Larry Ullman) While the process of storing and retrieving data is at the heart of any dynamic Web site, professional applications require more thought and effort than these simple transactions imply. A crucial but easily overlooked aspect of data storage is protecting sensitive information—from pas
Decide what to include at compile time using conditional compiler constants
(Tony Patton) There are various scenarios where certain sections of code are not necessary depending upon what you are compiling. For example, you may want to include debugging code during testing but with final application roll-out. Thankfully, C#, VB.NET, and even J# provide this functionally via
Automate acceptance tests with Selenium
(Christian Hellsten) Acceptance, or functional, testing is designed to put manual tasks through their paces, but testing these tasks by hand can be time consuming and prone to human error. In this article, the author shows architects, developers, and testers how to use the Selenium testing tools to
Road test: Four databases tested
(Steve Turvey) For many businesses, a database is the vital organ that lives, breathes, and protects precious data — the treasured jewel of their enterprise. Everything they know, and every way to know it, is dictated by these all-powerful tools.
SQL Server on a SAN
(Mel Shum) As a DBA, one of your many tasks is to manage your SQL Server databases’ ever-expanding storage requirements. How often do you find yourself adding more disk, trying to accurately size a database, or wishing you could more efficiently use your existing disk capacity? Storing database
Oracle, Oh The DBMS_PIPES Are Calling
(James F. Koopmann) Oracle pipes have been around for a long time but I venture to say that not many use this powerful mechanism. Let’s explore this feature and realize that it is truly not dead yet.
Is BizTalk Server an ESB?
(Matt Nicholson) Is Biztalk Server Microsoft’s version of the Enterprise Service Bus? This interview discusses this together with human workflow and long-running transactions with Scott Woodgate from Microsoft’s Business Process and Integration team.
Split Mirroring
(Roger E. Sanders) In the first three columns of this series, I described various recovery methods: transaction log files, backup images with version recovery, and transaction log files with roll-forward recovery. In this column, I’ll introduce split mirroring and explain how to use it to back up an
Consider what’s new in Microsoft SQL Server 2005
(Scott Lowe) SQL Server 2005 has finally hit the market and brought with it significant new features and changes from previous versions. This document explains the various editions of SQL Server 2005 and provides you with an overview of the new management console.