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


DBA Corner columns

2012 Columns

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

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

Performance Management Must Evolve to
Meet Changing Data Warehouse Demands
.
Database Trends and Applications, October 2012.

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

Regulatory Compliance and Database Administration.
Database Trends and Applications
, August 2012.

Removing Superfluous Spaces.
Database Trends and Applications, July 2012.

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

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

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

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

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

A Data-Tinged Look Back at 2011.
Database Trends and Applications, January 2012.


2011 Columns

Compliance and Data Access Tracking.
Database Trends and Applications, December 2011.

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

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

Cost Containment Thru Capping.
Database Trends and Applications, September 2011.

Through The Looking Glass.
Database Trends and Applications, August 2011.

Blinking Your Databases to Health.
Database Trends and Applications, July 2011.

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

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

Mitigating Data Risk During an Acquisition.
Database Trends and Applications, April 2011.

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

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

A Data-Tinged Look Back at 2010.
Database Trends and Applications, January 2011.

2008 Columns

A Data-Tinged Look Back at 2008.
Database Trends and Applications, December 2008.

Data, Data, Everywhere.
Database Trends and Applications, 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.

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.

2007 Columns

The Most Important Thing is Recoverability. December 2007.

Data Access Auditing: A Compliance Requirement. November 2007.

The Impact of Data Volume on Operational Databases. October 2007.

Simplified Database Search. September 2007.

Data Quality Starts With Proper Data Types. August 2007.

A Good Book on Physical Database Design. July 2007.

A Forced Tour of Duty. June 2007.

The Impact of e-Discovery on Data Management. May 2007.

The Return of the Repository? April 2007.

Data Governance is More Than Regulatory Compliance. March 2007.

Two Good New Year's Resolutions for a DBA. February 2007.

Types of DBAs. January 2007.

2006 Columns

The Two Biggest Database Performance "Things". December 2006.

The Lifecycle of Data. November 2006.

Databases Must be Archived for Long-Term Data Retention. October 2006.

DBA Change Management. September 2006.

Planning for Future Capacity. August 2006.

Data Professional's Salaries. July 2006.

Do Data Security Breaches Require a Data Professional's Oath? June 2006.

Database Standards and Procedures. May 2006.

Data Security and Privacy: Concerns of the DBA? April 2006.

On Data and Database Administration. March 2006.

Database Design and the Internet. February 2006.

Database Storage Management. January 2006.

2005 Columns

Model-Based Development and Management. December 2005.

Use DBA Tools to Assure Efficient Data Management. November 2005.

Database Archiving Solves Many Issues. October 2005.

The Log is the Database. September 2005.

Recommended Additions to the DBA Bookshelf. August 2005.

Database Auditing. July 2005.

Sarbanes-Oxley Requires Rigor in Database Administration. June 2005.

The Tao of DBA. May 2005.

Plan for Disasters and Test the Plan Regularly. April 2005.

Often Misunderstood, Don't Ignore Nulls. March 2005.

Intelligent Automation Can Solve the Complexity Problem. February 2005.

Performance Tuning Requirements for Database Applications. January 2005.

Columns from 2004 to 1996

Columns from Database Trends


Intelligently Managing DB2 Memory Structures. May 2001.

Why Data is Still Important. April 2001.

IT's a Crazy World. March 2001.

The 24x365 Availability Challenge. February 2001.

An Update on Oracle. January 2001.

 


Updates, Trends, and Thoughts. December 2000.

News From the Front - The Database Wars Escalate. November 2000.

Managing Database Change. October 2000.

Pervasive Computing And Pocket Databases. September 2000.

Intelligent Database Management. August 2000.

Open Source Database Management Systems. July 2000.

An Update on the Database Wars. June 2000.

The DAMA Symposium and Meta Data Conference 2000. May 2000.

A Basic IT Library. April 2000.

Accuracy Versus Speed. March 2000.

Minimizing Outages With Transaction Recovery. February 2000.

Two Interesting Acquisitions. January 2000.


 

XML Marks the Spot. December 1999.

Linux and the DBMS. November 1999.

E-Business Requires eDBA. October 1999.

What's In A Name? September 1999.

The IT Skills Shortage. August 1999.

The PDA DBA. July 1999.

Managing the Information Tsunami. June 1999.

Columns from Database Trends & Applications

What is Knowledge and Can it be Managed?  December 2004.

Ensuring Data Integrity is a Tricky Business.  November 2004.

The Five Nines of Database Availability.  October 2004.

Programmers Use Excuses, Too.  September 2004.

Reviewing the Top DBA Excuses and How to Overcome Them. August 2004.

How Secure Are Your Databases? July 2004.

So You Want to Become a DBA? June 2004.

Why Outsourcing the DBA is Not an Option. May 2004.

Make the Most of Your DBA Reporting Structure. April 2004.

Will Vendors Automate the DBA Out of Business? March 2004.

Database Applications Require Multiple Design Reviews. February 2004.

The Death of Denormalization. January 2004.


 

Business Eye for the DBA Guy. December 2003.

Nuggets of Data Rambling Through my Mind. November 2003.

Round-the-Clock Data Availability is Elusive but Expected. October 2003.

Required Reading from the DBA's Bookshelf. September 2003.

How to Curb the Curmudgeon in the Corner. August 2003.

Development and Production DBA Skills. July 2003.

A DBMS Architecture by Any Other Name Is Still Confusing. June 2003.

Follow the DBA Rules of Thumb for an Easier Life. May 2003.


Complexity Complicates Database Upgrades & Migrations. April 2003.

Dealing with DBMS Complexity. March 2003.

DBAs Do Storage Management. February 2003.

Charting the Evolution from DBA to e-DBA. January 2003.

 


The DBA and Application Design. December 2002.

Data Modeling Concepts Every DBA Should Know. November 2002.

Optimize Your Database Performance. October 2002.

Keeping Your Databases up to P.A.R. September 2002.

DBA Certification. August 2002.

Database Design -- From Logical to Physical. July 2002.

DBMS Architecture. June 2002.

How Much Availability is Enough? May 2002.

What is a DBA? April 2002.

Select Database Utilities With Care. March 2002.

Measuring DBA Effectiveness. February 2002.

Dealing With Downtime. January 2002.


 

Database Fragmentation and Disorganization. December 2001.

Database Disaster Planning. November 2001.

Dissecting Database Performance. October 2001.

The Role of the DBA Has Expanded. September 2001.


 


2017 Columns

The Importance of the Relational System Catalog.
Database Trends and Applications, March 2, 2017.

Digital Transformantion and the DBA.
Database Trends and Applications, February 9, 2017.

Trends Impacing DBAs in 2017.
Database Trends and Applications, January 3, 2017.

2016 Columns

Modernizing Database Administration with Autonomics.
Database Trends and Applications, December 1, 2016.

Navicat: A Helpful Toolkit for DBAs.
Database Trends and Applications, November 9, 2016.

Designing for Batch Database Applications.
Database Trends and Applications, October 7, 2016.

Big Data Guidance for Relational DBAs.
Database Trends and Applications, September 2, 2016.

Improving IT Security with Database Auditing Techniques.
Database Trends and Applications, August 4, 2016.

New Trends in Database Administration.
Database Trends and Applications, July 12, 2016.

The Importance of Keeping Your DBMS Up-to-Date.
Database Trends and Applications, June 9, 2016.

The Importance of SLAs.
Database Trends and Applications, May 4, 2016.

How to Improve Database Security.
Database Trends and Applications, April 2016.

The Integrity of Your Data is of the Utmost Importance.
Database Trends and Applications, March 2016.

Using Data Models to Improve Development.
Database Trends and Applications, February 2016.

Does the Title “DBA” Still Apply?
Database Trends and Applications, January 2016.

2015 Columns

Determining Your Database Backup Schedule.
Database Trends and Applications, December 2015.

The Difference Between Development DBAs & Production DBAs.
Database Trends and Applications, November 2015.

DBAs: Get Your Priorities Straight!
Database Trends and Applications, October 2015.

The Problem with Database Standards.
Database Trends and Applications, September 2015.

The Big Unstructured Data Lie.
Database Trends and Applications, August 2015.

A Compendium of DBA Quotes and Wisdom.
Database Trends and Applications, July 2015.

What is a NewSQL Database System?
Database Trends and Applications, June 2015.

How Effective Are Your DBAs?
Database Trends and Applications, May 2015.

Data Modeling Still Applies.
Database Trends and Applications, April 2015.

Missing Information and the Relational Null.
Database Trends and Applications, March 2015.

The Impact of Change on Database Structures.
Database Trends and Applications, February 2015.

Key Developments in Big Data, Data Management, and New Tech in 2014.
Database Trends and Applications, January 2015.

2014 Columns

What Can You Do to Avoid Database Locking Problems?
Database Trends and Applications, December 2014.

Top 10 Steps to Building Useful Database Indexes.
Database Trends and Applications, November 2014.

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

A Short History of DB2 for z/OS.
Database Trends and Applications, September 2014.

The Danger of Dirty Reads.
Database Trends and Applications, August 2014.

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

Regulatory Compliance Requires Metadata and DQ Programs.
Database Trends and Applications, June 2014.

Introduction to Recursive SQL.
Database Trends and Applications, May 2014.

Advanced Analytics Projects Offer Value.
Database Trends and Applications, April 2014.

Database Contingency Planning.
Database Trends and Applications, March 2014.

Gaining an Appreciation of Metadata Through Music.
Database Trends and Applications, February 2014.

A Data-Tinged Look Back at 2013.
Database Trends and Applications, January 2014.

2013 Columns

Thinking About Migrating to Version 11 of DB2 for z/OS?
Database Trends and Applications, December 2013.

A Primer on the Basics of NoSQL Databases.
Database Trends and Applications, November 2013.

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

Successful Database Change Management Requires Planning.
Database Trends and Applications, September 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.

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

The Many Methods of Data Movement.
Database Trends and Applications, May 2013.

Should Traditional Data Management Concepts Apply in the Age of Big Data?
Database Trends and Applications, April 2013.

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

Developing Cross-Platform Database Apps with FileMaker Pro 12.
Database Trends and Applications, February 2013.

A Data-Tinged Look Back at 2012.
Database Trends and Applications, January 2013.



2009 Columns

A Data-Tinged Look Back at 2009.
Database Trends and Applications, December 2009.

You Can't Force Data Quality.
Database Trends and Applications, 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.

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

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

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

Dynamic SQL On The Rise.
Database Trends and Applications, March 2009.

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

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

2010 Columns

SQL Performance Basics.
Database Trends and Applications, December 2010.

Useful SQL Techniques.
Database Trends and Applications, November 2010.

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

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

The High Cost of Enterprise Software.
Database Trends and Applications, August 2010.

Database Fundamentals.
Database Trends and Applications, July 2010.

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

Analyzing Any Data, Anywhere, All the Time.
Database Trends and Applications, May 2010.

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

A Quick Look at the Open Source DBMS Market.
Database Trends and Applications, March 2010.

The Evaporation of Privacy.
Database Trends and Applications, February 2010.

Information Overload? No Such Thing!
Database Trends and Applications, January 2010.

Recent review from The Chartered Institute for IT:

“This book is a guide to the discipline of modern database administration and gives detailed instructions and requirements of database administration.  It is an excellent book for learning database administration activities, processes and procedures.”

Read the full review here → http://www.bcs.org/content/conWebDoc/50909


Recent review from DB2utor, Troy Coleman:

“Once you’ve picked up and read DB2 Developers Guide, you will know why people on the DB2 List Serve forum refer to this book as the BIBLE. You will find that the DB2 Developer’s Guide is a comprehensive guide for both the beginner and experienced in DB2 … What makes this book unique is the case studies illustrating various DB2 10 features and capabilities.”

Read the full review here →
http://ibmsystemsmag.blogs.com/db2utor/db2-developers-guide-1/

For more details on database systems visit:

Columns from Computing News & Review


The Living Mainframe. April 1999.

ERP Requires DBA. March 1999.

Raw Iron: The Database Appliance. February 1999.

The Database Wars. January 1999.


 

Managing and Improving the IT Infrastructure. December 1998.

SQL Analysis and Review. November 1998.

Evaluating DBA Tool Vendors. October 1998.

Defining Database Performance. September 1998.

A.N.A.R.C.H.Y. August 1998.

Software Scrubbing Bubbles. July 1998.

Wanted: New Type of DBA. June 1998.

The Most Important Thing is Performance. May 1998.

The Age of the VHDB. April 1998.

Death Valley Days for the DBMS? March 1998.

Data Warehouse and Data Mart Administration. February 1998.



Industry Trends Impacting Database Administration. May 1996.