Database Administration (DBA) Articles

1997 and earlier

2006

The Two Biggest Database Performance "Things".
Database Trends and Applications, December 2006.

The Lifecycle of Data.
Database Trends and Applications, November 2006.

Database Archiving for Long-Term Data Retention.
Database Trends and Applications, October 2006.

DBA Change Management.
Database Trends and Applications, Sept 2006.

Planning for Future Capacity.
Database Trends and Applications, August 2006.

Data Professional's Salaries.
Database Trends and Applications, July 2006.

Do Data Security Breaches Require a Data Professional's Oath?
Database Trends and Applications, June 2006.

Database Standards and Procedures.
Database Trends and Applications, May 2006.

Regulatory Compliance and Data Governance.
zJournal, April / May 2006.

Data Security and Privacy: Concerns of the DBA?
Database Trends and Applications, April 2006.

On Data and Database Administration.
Database Trends and Applications, March 2006.

Database Design and the Internet.
Database Trends and Applications, February 2006.

Database Storage Management.
Database Trends and Applications, January 2006.

2010

Defining Database Performance.
Database Trends and Applications, October 2010.

Managing Database Storage.
Database Trends and Applications, September 2010.

More DBA Proverbs.
zJournal, August / September 2010.

The 10 Database Commandments.
zJournal, June / July 2010.

Are DBAs Obsolete?
Database Trends and Applications, June 2010.

Data Security Is Not Just a Technology Problem.
Database Trends and Applications, April 2010.

11 Rules of the Road for DBAs.
zJournal, December 2009 / January 2010.

2009

You Can't Force Data Quality.
Database Trends and Applications, November 2009.

Making Static SQL More Dynamic...and Vice Versa.
IDUG Solutions Journal, Fall 2009 (November).

The Definition of Database Performance.
Quest Pipelines, November 2009.

New Additions to the DBA Bookshelf.
Database Trends and Applications, October 2009.

Specialty Processors on the Mainframe.
Database Trends and Applications, September 2009.

Managing Data Resources During Mergers and Acquisitions.
Database Trends and Applications, August 2009.

Database Security Needs Evolve and Grow.
Database Trends and Applications, July 2009.

Are DBAs Really DBAs Today?
zJournal, June / July 2009.

Avoid Black Boxes to Improve Performance.
Database Trends and Applications, June 2009.

Advice for Job-Seeking Data Professionals.
Database Trends and Applications, May 2009.

Thoughts on Data Quality.
The Data Administration Newsletter, May 2009.

DB2 System Configuration and Performance.
zJournal, April / May 2009.

25 Questions to Evaluate DBA Tool Vendors.
Database Trends and Applications, April 2009.

Database Statistics and Optimization.
Database Trends and Applications, February 2009.

DBA Staffing Considerations.
Database Trends and Applications, January 2009.

DBA Proverbs.
zJournal, December / January 2009.

2008

Things You've Probably Neglected.
IDUG Solutions Journal, November 2008.

Reoptimizing SQL.
zJournal, October / November 2008.

Change Control for DB2 Access Paths.
Database Trends and Applications, October 2008.

On Becoming a DBA.
Database Trends and Applications, September 2008.

The 17 Skills Required of a DBA.
Database Trends and Applications, August 2008.

Database Auditing Capabilities for Compliance and Security.
The Data Administration Newsletter, August 2008.

Consider Data Access Auditing to Classify Database Data.
Database Trends and Applications, July 2008.

The Growing Importance of Metadata.
Database Trends and Applications, June 2008.

The Cost of a Data Breach.
Database Trends and Applications, May 2008.

Database Data Needs Long-Term (100 Year) Archiving Solution.
Database Trends and Applications, April 2008

An Update on Data Professional's Salaries.
Database Trends and Applications, March 2008.

Keeping Up With The DBMS.
Database Trends and Applications, February 2008.

A Data Tinged Look Back at 2007.
Database Trends and Applications, January 2008.

The Evolution of Database Security.
zJournal, Dec 07 / Jan 08.

2004

What is Knowledge and Can it be Managed?
Database Trends and Applications, December 2004.

Ensuring Data Integrity is a Tricky Business.
Database Trends and Applications, November 2004.

Facilitating Efficient Database Management.
Certification Magazine, November 2004.

The Five Nines of Database Availability.
Database Trends and Applications, October 2004.

Programmers Use Excuses, Too: The DBA Corner.  
Database Trends and Applications, September 2004.

The Top DBA Excuses and How to Overcome Them.
Database Trends and Applications, August 2004.

How Secure Are Your Databases?: The DBA Corner.
Database Trends and Applications, July 2004.

So You Want to Become a DBA?: The DBA Corner.
Database Trends and Applications, June 2004.

Why Outsourcing the DBA is Not an Option.
Database Trends and Applications, May 2004.

The Engine of Intelligence.    (link no longer active)
Intelligent Enterprise, April 17, 2004.

Make the Most of Your DBA Reporting Structure.
Database Trends and Applications, April 2004.

Will Vendors Automate the DBA Out of Business?
Database Trends and Applications, March 2004.

Database Applications Require Multiple Design Reviews: The DBA Corner.
Database Trends and Applications, February 2004.

The Death of Denormalization: The DBA Corner.
Database Trends and Applications, January 2004.

New Year's Resolutions for a DBA. (link no longer active)
dbazine.com, January 2004.

The Evolution of Database Security.
zJournal, Dec 07 / Jan 08.

2003

Business Eye for the DBA Guy: The DBA Corner.
Database Trends and Applications, December 2003.

An Introduction to Database Design: From Logical to Physical.    (link no longer active)
dbazine.com, November 2003.

Nuggets of Data Rambling Through my Mind.   
Database Trends and Applications, November 2003.

Measuring DBA Effectiveness.   (link no longer active)
dbazine.com, October 2003.

Round-the-Clock Data Availability is Elusive but Expected: The DBA Corner.
Database Trends and Applications, October 2003.

Required Reading from the DBA's Bookshelf.
Database Trends and Applications, September 2003.

How to Curb the Curmudgeon in the Corner.
Database Trends and Applications, August 2003.

Development and Production DBA Skills.
Database Trends and Applications, July 2003.

A DBMS Architecture by Any Other Name...
Database Trends and Applications, June 2003.

What is a DBA? - Part 6. (link no longer active)
dbazine.com, May 2003.

Follow the DBA Rules of Thumb for an Easier Life.  
Database Trends and Applications, May 2003.

Complexity and DBMS Upgrades & Migrations.
Database Trends and Applications, April 2003.

DBAs! You Should Fear XML!
The Data Administration Newsletter, April 2003.

What is a DBA? - Part 5. (link no longer active)
dbazine.com, April 2003.

What is a DBA? - Part 4. (link no longer active)
dbazine.com, March 2003.

Dealing with DBMS Complexity: The DBA Corner.
Database Trends and Applications, March 2003.

What is a DBA? - Part 3. (link no longer active)
dbazine.com, February 2003.

Apps are Temporary, But Data is Forever.
Data Discussions, February 2003.

DBAs Do Storage Management: The DBA Corner.
Database Trends and Applications, February 2003.

What is a DBA? - Part 2. (link no longer active)
dbazine.com, January 2003.

Data Modeling and Normalization. (link no longer active)
amazon.com, January 2003.

Charting the Evolution from DBA to e-DBA.
Database Trends and Applications, January 2003.

2001

Database Fragmentation and Disorganization.
Database Trends and Applications, December 2001.

Database Disaster Planning: The DBA Corner.
Database Trends and Applications, November 2001.

Modern Database Administration, Part 3.
DM Review, November 2001.

Logic, e-Business, and the Procedural eDBA.
dbazine.com, October 2001.

Dissecting Database Performance.
Database Trends and Applications, October 2001.

Modern Database Administration, Part 2.
DM Review, October 2001.

The Role of the DBA Has Expanded.
Database Trends and Applications, September 2001.

Modern Database Administration, Part 1.
DM Review, September 2001.

Database Design and the eDBA.
dbazine.com, August 2001.

Online Resources of the eDBA.
dbazine.com, July 2001.

Intelligently Managing DB2 Memory Structures.
Database Trends, May 2001.

The eDBA and Recovery.
dbazine.com, March 2001.

Getting Down to Data-Basics.
dbazine.com, February 2001.

2000

The eDBA and XML.
dbazine.com, December 2000

Managing Database Change.
Database Trends , October 2000.

The eDBA and Java.
dbazine.com, September 2000

Intelligent Database Management.
Database Trends , August 2000.

The eDBA and Data Availability.
dbazine.com, May 2000

DB2 and the Procedural DBA
DB2 Update, February 2000.

1998

Using Check Constraints To Simulate Domains.
The Data Administration Newsletter, December 1998.

Managing and Improving the IT Infrastructure.
Computing News & Review, December 1998.

SQL Analysis and Review.
Computing News and Review, November 1998.

Evaluating DBA Tool Vendors.
Computing News and Review, October 1998.

Software Scrubbing Bubbles.
Computing News and Review, July 1998.

The Procedural DBA.
Oracle Update, June 1998.

Wanted: New Type of DBA.
Computing News and Review, June 1998.

Data Warehouse Administration: The Challenges Never Stop.
IDUG Solutions Journal, March 1998.

What's In A Name: Database Naming Standards.
The Data Administration Newsletter, March 1998.

Data Warehouse and Data Mart Administration.
Computing News and Review, February 1998.

  

1994

Views on Views.
DB2 Update, October 1994.

Client/Server Development Considerations.  (link no longer active)
Data Management Review, September 1994.

What's in a Name?  (link no longer active)
DB2 Update, September 1994.

What is a Trigger?
Enterprise Systems Journal, August 1994.

The Great Debate.
Byte, April 1994.



1997

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

Denormalization Guidelines.
The Data Administration Newsletter, June 1997.


  


1996

Managing Systems in the Age of the Web.
PLATINUM Edge, September 1996.

Distributed Query Optimization.
Technical Support, July, 1996.

Industry Trends Impacting Database Administration.
Computing News and Review, May 1996.

 

  


1995

The Procedural DBA.
Database Programming & Design, December 1995.

 

  

1993

Preparing for DB2 Design Reviews.  (link no longer active)
DB2 Update, December 1993.

The Object-Oriented Tutorial Series: Part III: "Object vs. Relational"
Data Management Review, August 1993.

The Object-Oriented Tutorial Series: Part II: "An Object Oriented Tutor"
Data Management Review, May 1993.

The Object Oriented Tutorial Series: Part I: "To ODB or Not To ODB, That Is The Question"
Data Management Review, February 1993.

  

2002

The Automated Future: Take 2.   (link no longer active)
DB2 Magazine Online, December 2002.

The DBA and Application Design.
Database Trends and Applications, December 2002.

Data Modeling Concepts Every DBA Should Know.
Database Trends and Applications, November 2002.

eDBA: Database Disaster Planning and the eDBA.   
    
(link no longer active)
dbazine.com, November 2002.

What is a DBA? - Part 1. (link no longer active)
dbazine.com, November 2002.

Optimizing database performance, part 3: Compression, page size, and more.
searchdatabase.com, 05 November 2002

Optimizing database performance, part 2: Denormalization and clustering.
searchdatabase.com, 23 October 2002

Optimizing database performance, part 1: Partitioning and indexing.
searchdatabase.com, 16 October 2002

Optimize Your Database Performance.
Database Trends and Applications, October 2002.

Why DBAs Must be Jacks-of-all-Trades.
InformIT, September 2002.

Keeping Your Databases up to P.A.R.
Database Trends and Applications, September 2002.

DBA Certification.
Database Trends and Applications, August 2002.

Database Design -- From Logical to Physical.
Database Trends and Applications, July 2002.

DBMS Architecture.
Database Trends and Applications, June 2002.

How Much Availability is Enough?
Database Trends and Applications, May 2002.

eDBA: Online Database Reorganization.
  
(link no longer active)
dbazine.com, May 2002.

What is a DBA?: The DBA Corner.
Database Trends and Applications, April 2002.

Measuring DBA Effectiveness: The DBA Corner.
Database Trends and Applications, February 2002.

eDBA: Intelligent Automation of DBA Tasks.
  
(link no longer active)
dbazine.com, February 2002.

Dealing With Downtime: The DBA Corner.
Database Trends and Applications, January 2002.

The Evolution of Database Security.
zJournal, Dec 07 / Jan 08.

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.

The PDA DBA.
Database Trends, July 1999.

SQL Server and the Procedural DBA.
SQL Server Update, July 1999.

ERP Requires DBA.
Computing News & Review, March 1999.

The Need for Procedural DBA. (link no longer active)
IDUG Solutions Journal, March 1999.

  



2012

Database Design Traps.
Database Trends and Application, December 2012.

Data Administration versus Database Administration.
SSWUG, November 2012.

A DBA By Any Other Name...
Database Trends and Application, November 2012.

Materialized Query Tables…and the Death of Denormalization?
SSWUG, October 2012.

The Ever-Changing Role of the DBA.
SSWUG, October 2012.

Surrogate Keys or Natural Keys?
Database Trends and Applications, September 2012.

UNIX for DBAs.
SSWUG, June 2012.

Bachelor Programming Syndrome.
Database Trends and Application, June 2012.

What is Large?
Database Trends and Application, May 2012.

Harden Your Applications to Combat SQL Injection.
Database Trends and Applications, April 2012.

Evaluating a DBA Job Offer.
Database Trends and Application, March 2012.

Supporting Temporal Data in the Database.
Database Trends and Application, February 2012.

2011

The Guide to Being a Successful DBA.
Database Trends and Application, November 2011.

The Return of the DBA Proverbs.
zJournal, October / November 2011.

Building Your SQL Library.
Database Trends and Application, October 2011.

The State of Database Administration 2011: Types, Trends, & Technologies.
SSWUG, August/September 2011

The Procedural DBA.
SSWUG, July 2011

The Importance of Database Design Reviews.
Database Trends and Application, May 2011.

DBA as a Management Discipline.
Database Trends and Application, June 2011.

Database Archiving and Auditing Can Minimize the Potential of a Data Breach.
SSWUG,May 2011

Database Administration and the Goal of Diminishing Downtime.
Database Trends and Application, March 2011.

Taking A Systematic Approach to View Creation.
Database Trends and Application, February 2011.

2014

A Sample DBA Job Posting.
Toad World, October 24, 2014.

Improving Data Integrity Using Check Constraints.
Database Trends and Applications, October 2014.

The Ten Database Commandments.
Database Trends and Applications, July 2014.

Database Standards and Procedures.
Toad World, June 24, 2014.

Best Practices for Upgrading to a New DBMS Version.
Toad World, April 30, 2014.

Database Contingency Planning - Preparing for Disasters You Hope Won’t Happen.
Database Trends and Applications, March 2014.


2013

The DBA’s Guide to Application Development.
Database Trends and Applications, October 2013.

What Does a DBA Do?
Information on Demand 2013, October 1, 2013.

DBA Proverbs – More Words to Live By.
Enterprise Tech Journal, August / September 2013.

Database Recovery is a Compliance Issue.
SSWUG, September 26, 2013.

Successful Database Change Management Requires Planning.
Database Trends and Applications, September 2013.

What’s In a Name? On Database Naming Standards.
SSWUG, September 3, 2013.

Bad Database Standards Can Cause Performance Problems.
Database Trends and Applications, August 2013.

How to Become a DBA.
Database Trends and Applications, July 2013.

The Ever-Changing Role of the DBA.
The Data Administration Newsletter, July 2013.

Database Administration and Storage Management.
Database Trends and Applications, June 2013.

Managing Database Storage.
SSWUG, May 23, 2013.


Share on Facebook Share on Twitter Share on Digg Share on Stumble Upon Share via e-mail Print

2007

The Most Important Thing is Recoverability.
Database Trends and Applications, December 2007.

Data Access Auditing: A Compliance Requirement.
Database Trends and Applications, November 2007.

The Impact of Data Volume on Operational Databases.
Database Trends and Applications, October 2007.

Simplified Database Search.
Database Trends and Applications, September 2007.

Data Quality Starts With Proper Data Types.
Database Trends and Applications, August 2007.

Financial Institutions' Sensitive Data Requires Careful Archiving.
Houston Business Journal, August 3 - 9, 2007

A Good Book on Physical Database Design.
Database Trends and Applications, July 2007.

A Forced Tour of Duty.
Database Trends and Applications, June 2007.

The Impact of e-Discovery on Data Management.
Database Trends and Applications, May 2007.

Database Archiving for Long-Term Data Retention.
IT Compliance Magazine, Spring 2007.

Two Good New Year's Resolutions for a DBA.
Database Trends and Applications, February 2007.

Types of DBAs.
Database Trends and Applications, January 2007.

2005

Model-Based Development and Management.
Database Trends and Applications, December 2005.

DBA Staffing Considerations.
SearchDataManagement.com, November 2005.

Use DBA Tools to Assure Efficient Data Management.
Database Trends and Applications, November 2005.

Database Archiving Solves Many Issues.
Database Trends and Applications, October 2005.

The Log is the Database.
Database Trends and Applications, September 2005.

Recommended Additions to the DBA Bookshelf.
Database Trends and Applications, August 2005.

Database Auditing: The DBA Corner.
Database Trends and Applications, July 2005.

SOX Requires Rigor in Database Administration.
Database Trends and Applications, June 2005.

The Tao of DBA: The DBA Corner.
Database Trends and Applications, May 2005.

Plan for Disasters and Test the Plan Regularly.
Database Trends and Applications, April 2005.

Often Misunderstood, Don't Ignore Nulls.
Database Trends and Applications, March 2005.

Intelligent Automation Can Solve the Complexity Problem.
Database Trends and Applications, February 2005.

RFID to Complicate DBA. (link no longer active)
dbazine.com, February 2005.

Perspectives on Database Management. (link no longer active)
dbazine.com, February 2005.

How Many DBAs?
SearchOracle.com, February 2005.

Self-Managing Database Systems.
SearchOracle.com, February 2005.

DBA Certification.
SearchOracle.com, February 2005.

On Becoming a DBA.
SearchOracle.com, February 2005.

The Morphing of Database Administration.
SearchOracle.com, February 2005.

Performance Tuning Requirements for Database Applications.
Database Trends and Applications, January 2005.

2005 thru 1999

Preparing for Database Application Design Reviews.
SSWUG, May 16, 2013.

Database Administration in an Increasingly Complex World.
SSWUG, May 2, 2013.

Should Traditional Data Management Concepts
Apply in the Age of Big Data?

Database Trends and Applications, April 2013.

Curbing the Curmudgeons in the Corner.
SSWUG, April 1, 2013.

DBA Rules of Thumb.
The Data Administration Newsletter, March 1, 2013.

Database Recovery Is a Compliance Issue.
Database Trends and Applications, March 2013.

Database Capacity Planning.
SSWUG, February 11, 2013.

Recoverability Trumps Performance.
SSWUG, February 4, 2013.

Earlier Articles