1999 DBMS Trends Into the 21st Century. IDUG Solutions Journal (Face Off w/Willie Favero) XML Marks the Spot. Database Trends, December 1999. Linux and the DBMS. Database Trends, November 1999. E-Business Requires eDBA. Database Trends, October 1999. Profile of an eDBA. DB2 Magazine, Fall 1999. What's In A Name? Database Trends, September 1999. Using Nulls in SQL Server. SQL Server Update, September 1999. The IT Skills Shortage. Database Trends, August 1999. Using CASE Expressions. SQL Server Update, August 1999. Mixing DB2 and Object Orientation? IDUG Solutions Journal, Summer 1999. The PDA DBA. Database Trends, July 1999. Data Warehousing Guidelines for DB2. DB2 Update, July 1999. SQL Server and the Procedural DBA. SQL Server Update, July 1999. Managing the Information Tsunami. Database Trends, June 1999. Using the Identity Property. SQL Server Update, May 1999. Through The Looking Glass. The Data Administration Newsletter, April 1999 The Living Mainframe. Computing News & Review, April 1999. ERP Requires DBA. Computing News & Review, March 1999. Triggers and DB2 Version 6. DB2 Update, March 1999. The Need for a Procedural DBA. IDUG Solutions Journal, March 1999. What is Knowledge and Can It Be Managed? The Data Administration Newsletter, March 1999 Raw Iron: The Database Appliance. Computing News & Review, February 1999. Using Views in Microsoft SQL Server. SQL Server Update, February 1999. The Database Wars. Computing News & Review, January 1999. The Buffer Pool. PLATINUM SYSJOURNAL, Winter 1999. 1998 Managing and Improving the IT Infrastructure. Computing News & Review, December 1998. Using Check Constraints To Simulate Domains. TDAN, December 1998. Storage Impact of Type 2 Indexes. DB2 Update, December 1998. Using Constraints in SQL Server. SQL Server Update, December 1998 SQL Analysis and Review. Computing News and Review, November 1998. The Pros and Cons of Procedural SQL. SQL Server Update, November 1998. The Future of SQL. IDUG Solutions Journal, October 1998. Evaluating DBA Tool Vendors. Computing News and Review, October 1998. Dealing with Fragmentation and Disorganization. Oracle Update, October 1998. Preparing for DB2 Version 6. DB2 Update, October 1998. Character Versus Numeric Data Types. DB2 Update, October 1998. Referential Integrity in Microsoft SQL Server. SQL Server Update, October 1998. Managing DB2 for OS/390 Performance - Really. DB2 Magazine, Fall 1998. Defining Database Performance. Computing News and Review, September 1998. Java: Hype or Hope? IDUG Solutions Journal, August 1998. Data Warehousing Guidelines for DB2. Enterprise Systems Journal, August 1998. A.N.A.R.C.H.Y. Computing News and Review, August 1998. Software Scrubbing Bubbles. Computing News and Review, July 1998. Accessing DB2 Over the Internet. DB2 Update, June 1998. Finding DB2 Information Using the Internet. DB2 Update, June 1998. The Procedural DBA. Oracle Update, June 1998. Tools for a Comprehensive Database Environment — Part 1, Part 2. TDAN, June and Sept 1998. Wanted: New Type of DBA. Computing News and Review, June 1998. The Most Important Thing is Performance. Computing News and Review, May 1998. DB2 and the Year 2000. DB2 Update, May 1998. The Age of the VHDB. Computing News and Review, April 1998. Finding Oracle Information on the Internet. Oracle Update, April 1998. Data Warehouse Administration: Challenges Never Stop. IDUG Solutions Journal, March 1998. Death Valley Days for the DBMS? Computing News and Review, March 1998. Changes to the System Catalog for DB2 Version 5. DB2 Update, March 1998. What's In A Name: Database Naming Standards. TDAN, March 1998. Data Warehouse and Data Mart Administration. Computing News and Review, February 1998. Openness Complicates Database Management. Computing Canada, January 26, 1998. 1997

Large Partitioned Table Spaces. DB2 Update, November 1997.

DBMS Trends into the 21st Century. IDUG Solutions Journal, November 1997.

The Capability Maturity Model - From a Data Perspective. TDAN, December 1997.

Data Definition Guidelines. InformIT, October 1997.

The Oracle Environment. Oracle Update, October 1997.

Models for Estimating Performance. IDUG Solutions Journal, Aug 1997. (w/Rick Bolesta)

Denormalization Guidelines. The Data Administration Newsletter, June 1997.

To Partition or Not to Partition, That is the Question. DB2 Magazine, Spring 1997.

1996 Stored Procedure Guidelines for DB2. DB2 Magazine, Winter 1996. Managing Systems in the Age of the Web. PLATINUM Edge, September 1996. Optimizing DB2 Outer Joins. DB2 Update, September 1996. Procedural SQL. Enterprise Systems Journal, July 1996. Distributed Query Optimization. Technical Support, July, 1996. Security Enhancements in DB2 V4. DB2 Update, June 1996. Using Variable Character Data in DB2. DB2 Update, June 1996. Storing Procedural Logic in the Database. Sybase Technical Journal, Spring/Summer 1996. Tools for a Comprehensive DB2 Environment. IDUG Solutions Journal, Issue 2, 1996. Industry Trends Impacting Database Administration. Computing News and Review, May 1996. DB2 Version 4 Catalog Revisions. DB2 Update, April 1996. Dealing with Data Outhouses. DM Review, March 1996. DB2 Version 4 Security and Authorization Enhancements. PLATINUM Edge, March 1996. DB2 Version 4 Dirty Read Capability. DB2 Update, February 1996. DB2 Version 4 Check Constraints. DB2 Update, January 1996. Reorganizing the System Catalog in DB2 Version 4. IDUG Solutions Journal, Winter 1996. 1995 Gathering DB2 Information in Cyberspace. Enterprise Systems Journal, December 1995. The Procedural DBA. Database Programming & Design, December 1995. DB2 V4 Outer Join Basics. DB2 Update, October 1995. Referential Integrity in SYBASE SQL Server 10. Relational Database Journal, Sept-Oct 1995. An Introduction to the Architecture of DB2 for OS/2. PLATINUM Edge, September 1995. DB2 V4 In-Line Views. DB2 Update, September 1995. Distributed Query Optimization. IDUG Solutions Journal, July-Sept. 1995. An Introduction to the Architecture of ORACLE. PLATINUM Edge, Summer 1995. Producing Quality Software. Systems Development Management, May 1995. Stored Procedures in DB2 Version 4. IDUG Solutions Journal, April 1995. An Introduction to the Architecture of DB2. PLATINUM Edge, Spring 1995. DB2 SQL Analysis Tools. DB2 Update, February 1995. Optimizing Client/Server Performance. Data Management Review, January 1995. Lock Avoidance in DB2 Version 3. DB2 Update, January 1995. Data Set Closing From Deferred to Pseudo. Relational Database Journal, Jan-Feb 1995. 1994 Implementing DB2 in a Client/Server Environment. Mainframe Client/Server, December 1994. New Catalog Statistics in DB2 Version 3. DB2 Update, December 1994. What is a Stored Procedure? Enterprise Systems Journal, December 1994 An Introduction to the Architecture of SYBASE SQL Server. PLATINUM Edge, Winter 1994 DB2 V3 Bufferpool Tuning: A Trip to Tune Town. Relational Database Journal, Nov-Dec 1994. Getting Integrity in SYBASE SQL Server. DBMS Magazine, November 1994. Views on Views. DB2 Update, October 1994. Client/Server Development Considerations. Data Management Review, September 1994. What's in a Name? DB2 Update, September 1994. Pursuing Procedural SQL. PLATINUM Edge, Fall 1994. What is a Trigger? Enterprise Systems Journal, August 1994. DB2-IBM's Answer to Client/Server. Data Management Review, June 1994. QMF Performance Tuning (Parts 1, 2, & 3). DB2 Update, Jun-Jul-Aug 1994. DB2 for MVS: Triggers & Stored Procedures. PLATINUM Edge, Summer 1994. The Future of DB2. DB2 Update, May 1994. Dismissing Dynamic Dangers. Database Programming & Design, May 1994. The Wrapping: Package Implementation Considerations (Part 1, Part 2, & Part 3). Relational Database Journal, May-Jun / Jul-Aug / Sept-Oct '94. The Great Debate: Relational v. OO. Byte, April 1994. DB2 Dataset Placement. DB2 Update, April 1994. The Bufferpool: DB2 Tips, Thoughts, and Rumors. Relational Database Journal, Mar-Apr 1994. Know Your Data. DB2 Update, March 1994. A Look at DB2 Version 3. DB2 Update, February 1994. 1993 DB2 Version 3: A Closer Look (Part 2). PLATINUM SYSJOURNAL, Winter '93. The Object-Oriented Tutorial Series: Part IV. "Making Object Relational Successful". Data Management Review, December 1993. Preparing for DB2 Design Reviews. DB2 Update, December 1993. Denormalization Techniques for DB2 Tables. Relational Database Journal, Nov 1993 - Jan 1994. DB2 Version 3: A Closer Look (Part 1). PLATINUM SYSJOURNAL, Fall 1993. A BASE for CASE. Data Management Review, September 1993. How DB2 V2.3 Impacts EDM Pool Size. DB2 Update, September 1993. Preparing for DB2 Version 3 Buffer pools. DB2 Today, August 1993. The Object-Oriented Tutorial Series: Part III: "Object vs. Relational". Data Management Review, August 1993. The Buffer Pool: DB2 Tips, Thoughts, and Rumors. Relational Database Journal, Aug - Oct 1993. DB2 Tips & Techniques: DB2 Data Set Placement. PLATINUM SYSJOURNAL, Summer 1993. DB2 Organizational Issues: It's Here, But Now What? Data Management Review, July 1993. The Doors to DB2. (cover story) DB2 Today, May 1993. The Object-Oriented Tutorial Series: Part II: "An Object Oriented Tutor". Data Management Review, May 1993. How DB2 V2.3 Will Affect Your Standards. DB2 Update, May 1993. The Buffer Pool: DB2 Tips, Thoughts, and Rumors. Relational Database Journal, May-July 1993. The Databases of Our Lives. PLATINUM SYSJOURNAL, April 1993. The Object Oriented Tutorial Series: Part I: "To ODB or Not To ODB, That Is The Question". Data Management Review, February 1993. A Critical Look at the DB2 Catalog (Parts I and II). Technical Support, Jan 1993, Feb 1993. How DB2 V2.3 Impacts EDM Pool Size. IDUG Globe, January 1993. 1992 Technical Tips for Users of DB2 V2.3. PLATINUM SYSJOURNAL, September 1992. The Future of DB2 Security (Part II). Database Management, August 1992. The Future of DB2 Security (Part I). Database Management, July 1992. 1991 Dynamic SQL For DB2. Enterprise Systems Journal, December 1991. Problem Too Complicated for Simple Arithmetic. Database Management, November 1991. One View Per Base Table? Don't Do It! Database Programming & Design, February 1991. Mastering Disaster Recovery. Database Programming & Design, January 1991. 1990 DBA Shoptalk: Dusting Off The Database. Database Programming & Design, August 1990. DB2 V2.2: A Few More Bells & Whistles. Database Programming & Design, June 1990. Effective DB2 Object Monitoring Using The DB2 Catalog. Mainframe Journal, May 1990.

Articles 1999 and Older

Links to older articles by Craig S. Mullins

Craig’s Db2 Books Db2 Dev Guide Db2 App Perf Tao of Db2

Craig’s DBA Book DBA Best Practices 2ed