Craig Mullins: Articles Published in 2012

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

Some databases require a temporal component, that is, storing data for various periods of time. In this month's DBA Corner column we examine the requirements and capabilities of a temporal database system.

Avoiding Bachelor Programming Syndrome.
SSWUG, January 2012

Unless you plan for, and issue regular COMMITs in your DB2 batch programs, you will cause locking problems for your DB2 environment. Actually, this advice applies to all DBMS programming! (registration required)

A Resurgence of Metadata Management.
SSWUG, January 2012

Are we poised for a resurgence of interest and attention being given to metadata and its management? Metadata management is long overdue for resurgence in popularity. (registration required)

The Database Report: 4Q2011.
The Data Administration Newsletter, January 2012.

The fourth quarter 2011 -- and year-end -- installment of "The Database Report" column, with coverage of the DBMS marketplace including acquisitions, lawsuits, technology, financials, and more.

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

In this month's edition of DBA Corner I take a look back at the year that was in terms of the data and database management market this past year.

Security Improvements in DB2 10 for z/OS.
zJournal, December 2011 / January 2012.

DB2 V10 brings with it many new features and improvements for securing and protecting your DB2 data and databases. This article offers an overview of the highlights.

Craig Mullins: Articles Published in 2011

The Tao of the Database Administrator.
SSWUG, December 2011

Learn how to apply the philosophy of Tao to the job of database administration. (registration required)

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

In a world full of regulations, today's businesses must go beyond just securing their data...companies have to perpetually monitor their systems in order to know who did exactly what, when and how - to their data.

Optimistic Locking in DB2 for z/OS.
SSWUG, December 2011

This article discussed optimistic locking techniques as of DB2 Version 9. (registration required)

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

These ten guidelines, when properly followed, can help you to succeed in your career as a database administrator (DBA).

The Impact of Mergers on Data Management.
SSWUG, November 2011

This article examines some of the data management challenges that need to be tackled when managing through an acquisition. (registration required)

Data Quality Starts with Proper Data Types.
SSWUG, October 2011

Data type and length are the most fundamental integrity constraints applied to data in a database. Making wise data type decisions when designing your databases can go a long way toward promting data quality. (registration required)

DB2 Security - A Common Language for a Common Goal.
IDUG Tech Library Blog, October 2011

(Co-authored with Rebecca Bond) Until recently, the implementation effort to securely protect our z/OS databases and our LUW databases typically traveled on different paths. Other than sharing the concepts of the basic security principles, database professionals had little in the way of common functionality or a common language when it came to creating a robust security approach. This short article discusses the DB2 10 for z/OS and DB2 9.7 LUW improvements toward the goal of a common security language.

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

The latest in a series of columns relating popular sayings and proverbs to the management discipline of database administration (DBA).

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

Every database programmer and DBA should have a library of books on SQL. There are many titles to choose from, and a lot of them are very good. This month’s DBA CORNER column outlines four SQL books that should be on every database professional’s bookshelf.

The Database Report: 3Q2011.
The Data Administration Newsletter, October 2011.

The third quarter 2011 installment of "The Database Report" column, with coverage of the DBMS marketplace including acquisitions, lawsuits, technology, financials, and more.

Ten Breakthroughs That Changed DB2 Forever.
SSWUG, October 2011

Today, DB2 is a high-speed, enterprise DBMS with unparalleled transaction processing capabilities. But it wasn’t always that way. These innovations helped push DB2 to the top.  (registration required)

Collecting Histogram Statistics With RUNSTATS.
SSWUG, September 2011

Histogram statistics, added to DB2 for z/OS in Version 9, can be a useful new way to gather additional stats for improving the performance of range predicates. (registration required)

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

Reigning in costs is a constant goal for IT departments these days. This month's DBA CORNER column offers guidance on using a capacity planning technique called soft capping to reduce monthly software bills.

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

This three-part series examines the role of the DBA and how it is practices circa 2011. It breaks down the various tyeps of DBAs, gives guidance on DBA practices & procedures, and looks at the technological and responsility-based changes impacting today's DBAs. (registration required)

On The Need for Temporal Data.
zJournal, August/September 2011.

Version 10 of DB2 for z/OS supports temporal data structures. This edition of the zData Perspectives column offers an introduction to the differing types of temporal data support and their benefits.

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

Looking for IT guidance in strange places... but the advice is good!

The Database Report: 2Q2011.
The Data Administration Newsletter, July 2011.

The second quarter 2011 installment of "The Database Report" column, with coverage of the DBMS marketplace including acquisitions, lawsuits, strong financials, and more.

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

Simplification is important in today’s era of increasing complexity because many problems arise simply due to lack of managing the things most of us already know. This month's DBA Corner column examines some of the primary issues and concepts that need to be addressed in order to keep database applications humming along.

The Procedural DBA.
SSWUG, July 2011

This five-part series introduces the concept of a procedural DBA for managing database code objects (such as trigggers and stored procedures). (registration required)

Partitioning Pros and Cons.
zJournal, June/July 2011.

Before deciding whether or not to use a DB2 partitioned table space, it is wise to first weigh the pros and cons. This month's column outlines the basic pros and cons of partitioning.

A Basic Introduction to Coding DB2 SQL for Performance.
SSWUG, June 2011

This five-part article series introduces the reader to best practices for coding DB2 SQL to achieve optimal performance. (registration required)

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

Database administration is rarely approached as a management discipline. The term discipline implies a plan, and implementation according to that plan. When database administration is treated as a management discipline, the treatment of data within your organization will improve. It is the difference between being reactive and proactive.

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

This three-part article discusses the on-going onslaught of data breaches and how two different data management disciplines -- database archiving and database auditing -- can help to combat the problem.  (registration required)

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

Design reviews are an important facet of the system development lifecycle for database applications. This month's DBA Corner column highlights the various reviews that are needed and explains why.

Best Practices in DB2 Storage Management.
zJournal, Apr/May 2011.

Managing the storage for DB2 databases can be a troubling task because it requires spanning two disciplines: database administration and storage management. This article discusses the importance of storage for DB2 administration.

Not Your Standard Sorting Requirement.
Quest ToadWorld Pipelines, April 2011.

Sometimes the requirements of a particular application dictate that data needs to be sorted using some irregular collating sequence. This article discusses one such instance and offers up a unique SQL solution to the problem.

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

The Database Report: 1Q2011.
The Data Administration Newsletter, April 2011.

The first quarter 2011 installment of "The Database Report" column, with coverage of the DBMS marketplace spanning hirings and firings, acquisitions, and a computer playing on a game show... and winning!

Diminishing Downtime.
Database Trends and Applications, March 2011.

Dynamic SQL Versus Static SQL.
zJournal, Feb/March 2011.

Many DB2 professionals are not comfortable determining when to choose dynamic SQL instead of static. This issue’s column examines criteria that can be used to help make that decision.

Consider Capping to Control Costs.
The Data Administration Newsletter, February 2011.

Cost containment is important for most organizations in this day and age of financial austerity. But an often overlooked opportunity for controlling cost comes from capacity planning and management. This article discusses how to intelligently automate mainframe soft capping to reign in costs.

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

The manner in which views can be utilized to provide the greatest benefit can be an area of disagreement between database professionals. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach. This article examines the issues and gives guidance on proper view usage.

The Database Report: 4Q2010.
The Data Administration Newsletter, January 2011.

The fourth quarter installment of "The Database Report" column, this month with highlights including the courtroom drama of the Oracle/SAP lawsuit, several interesting acquisitions, quarterly earnings announcements, and our regular industry coverage.

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

In this month's edition of DBA Corner I take a look back at the year that was in terms of the data and database management market this past year.

Rebinding for Optimal DB2 Access Paths.
zJournal, December 2010 / January 2011.

One of the most important contributors to the on-going efficiency and health of your DB2 environment is proper management of DB2 access path changes. In this article we discuss how a thorough REBIND management process is a requirement for healthy DB2 applications.

To Rebind or Not to Rebind: Why Is That Even a Question?
IDUG Solutions Journal, Winter 2010.

One of the most important contributors to the on-going efficiency and health of your DB2 environment is proper management of DB2 access path changes. In this article we discuss how a thorough REBIND management process is a requirement for healthy DB2 applications.

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

Assuring optimal performance of database applications starts with coding properly formulated SQL. As much as 75% of poor relational performance is caused by "bad" SQL and application code. But writing efficient SQL statements can be tricky. This is especially so for programmers new to a relational database environment or those who have never been trained to properly write SQL.

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

This month's DBA Corner column addresses a couple of useful SQL techniques for manipulating data using functions.

Capping to Control Costs.
zJournal, October / November 2010.

Cost containment is an important criterion for IT departments in this day and age of financial austerity. But an often overlooked opportunity for controlling cost comes from capacity planning and management. This column describes intelligently automating soft capping your mainframe environment to reign in costs.

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

DBAs are accustomed to dealing with database performance problems. But before you can implement a truly successful database performance management plan, you need to define what is meant by "database performance." And that is the topic of this month's DBA Corner column.

The Database Report: 3Q2010.
The Data Administration Newsletter, October 2010.

The third quarter installment of "The Database Report" column with news of acquisitions, lawsuits, new product announcements, and quarterly earnings.

DB2 and Storage Management.
IDUG Solutions Journal, Summer 2010 (September).

As a DB2 IT professional, you know that your databases rely on some form persistent storage to maintain data. But perhaps you are not familiar with many of the details. This article discusses the importance of storage for DB2 administration.

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

Managing storage often can be an afterthought for DBAs, but it is a vital component for assuring database availability and performance.

More DBA Proverbs.
zJournal, August / September 2010.

My 2009 z/Data Perspectives column introducing some DBA proverbs proved to be one of my more popular zJournal columns... so here are some additional wisdom that can be applied toward becoming a better DBA.

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

This month's DBA Corner column tackles an issue that most DBAs have dealt with at one time or another... the difficulty of procuring needed enterprise software due to its high cost of acquisition.

Database Fundamentals.
Database Trends and Applications, July 2010.

A back to basics review of the fundamentals of data, databases, and database management concepts, issues, and terminology.

The Database Report: 2Q2010.
The Data Administration Newsletter, July 2010.

The second quarter installment of "The Database Report" column highlighted by SAP's proposed acquisition of Sybase, quarterly earnings announcements, acquisitions during the Q2, and more.

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

People are drawn to lists to help them in just about every aspect of their lives. One of the more famous lists is the ten commandments (in the bible). Here is a less biblical, but perhaps more applicable list of rules for you -- the ten commandments for database professionals. Hopefully it can serve as a good starting point for database development and administration.

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

Every so often, some industry pundit gets his opinions published by declaring that "Database administrators are obsolete" or that "we no longer need DBAs." But is there any truth to that assertion?

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

Stream computing, which involves the ingestion of data (structured or unstructured) from arbitrary sources and processing it, opens up a new world for information processing.

Performance Data - On the Cheap - Using Display.
IDUG Solutions Journal, Spring 2010 (May).

Although a DB2 performance monitor is probably the best method of gathering information about your DB2 for z/OS subsystems and databases, you can gain significant insight into your DB2 environment using the simple DISPLAY command.

What's All zTwittering About?
zJournal, April / May 2010.

Although the mainframe database landscape has been quite stable for the past two to three decades the advents of Linux for System z may be shaking things up a bit.

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

Technology is a crucial component of protecting your valuable business data. But it is not the only thing. This month's column looks at non-technological steps that can be taken to protect your critical data.

Assuring Data Integrity in DB2.
Quest ToadWorld Pipelines, April 2010.

DB2 provides many techniques to automatically enforce and maintain data integrity within your tables. This article describes these techniques and discusses their benefits.

The Database Report: 1Q2010.
The Data Administration Newsletter, April 2010.

The first quarter installment of "The Database Report" column covering the on-going Oracle/Sun saga, quarterly earnings announcements, acquisitions during the 1Q2010, and more.

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

This month's column offers up a review of the open source landscape for database management systems... which has become more interesting as Oracle continues its acquisitive ways.

Database Adventures in Linux for System z Land.
zJournal, February / March 2010.

Although the mainframe database landscape has been quite stable for the past two to three decades the advents of Linux for System z may be shaking things up a bit.

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

An examination of our diminishing expectations of privacy by reviewing little pieces of paper that fall out of our monthly bills and account statements.

You Can't Force Data Quality.
The Data Quality Advisor, January 2010.

In the never-ending quest for quality data, organizations can do much better at verifying the data entered into their customer-facing Web applications.

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

This month I tackle the misguided notion of "information overload." you see, I'm of the opinion that you can never have enough information – at least regarding those things you care about

The Database Report: 4Q2009.
The Data Administration Newsletter, January 2010.

The fourth quarter installment of "The Database Report" column covering the on-going Oracle/Sun saga, quarterly earnings announcements, acquisitions during the 4Q2009, and more.

Index: 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 and older

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

Sometimes the non-technical aspects of DBA are just as challenging as the technical ones. With that in mind, this month’s column offers some “life rules” to guide DBAs as they attempt to keep their companies databases humming along.

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

In this month's edition of DBA Corner I take a look back at the year that was in terms of the data and database management market this past year.

The Definition of Database Performance.
Quest Pipelines, November 2009.
 
DBAs are accustomed to dealing with database performance problems. But before you can implement a truly successful database performance management plan, you need to define what is meant by "database performance." This short article provides a basic definition.

Collecting Histogram Statistics With RUNSTATS.
zJournal, October / November 2009.

Among the many new enhancements that have found their way into DB2 9 for z/OS is the ability to gather histogram statistics with the IBM RUNSTATS utility.

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

This month's DBA CORNER deals with the never-ending quest for quality data -- and the many barriers thwarting that quest.

Just the Facts About Mainframe Specialty Processors.
The Data Administration Newsletter, November 2009.

Over the course of the past decade or so, IBM has introduced several different types of specialty processors. The basic idea of a specialty processor is that it augments the main general purpose CPUs and specific workloads are shuttled to the specialty processors.

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

SQL can be either static or dynamic. But the differences between static and dynamic SQL are lessening over time. And IBM has added features that blur the differences between the two. This article examines ways to make dynamic SQL more static... and static SQL more dynamic... because not everything is always black or white.

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

As my regular readers know, I am an avid reader, especially of technology books. And every now and then I review some of the more interesting database-related books in the DBA Corner column. In this month's column I offer short reviews of four new database books.

An Overview of Mainframe Specialty Processors.
Quest Pipelines, October 2009.

If you are a mainframer you will have at least heard about specialty processors -- zIIPs and zAAPs --- but perhaps you need more information about what they are, what they do, and why they exist. This article takes you on a brief journey into the world of specialty processors!

The Database Report: 3Q2009.
The Data Administration Newsletter, October 2009.

The third quarter installment of "The Database Report" column covering the on-going Oracle/Sun saga, quarterly earnings announcements, acquisitions during the 3rd quarter, and more.

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

If you use an IBM z Series mainframe you've undoubtedly heard about zIIPs and zAAPs and other specialty processors. But maybe you haven't examined them in-depth yet. With that in mind, this article takes a brief journey into the world of specialty processors.

DISPLAY Your Way Out of DB2 Problems.
zJournal, August / September 2009.

Although robust performance and administration tools are probably the best solution for gathering information about your DB2 subsystems and databases, you can gain significant insight into your DB2 environment simply using the DISPLAY command.

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

Managing an ever-increasing mountain of data is not a simple task in the best of times, but doing so while combining formerly separate entities during an economic slowdown can be a monumental challenge.

An Overview of Mainframe Specialty Processors.
IDUG Solutions Journal, Summer 2009 (August).

Most everyone who uses an IBM z Series mainframe has at least heard about zIIPs and zAAPs and perhaps other specialty processors. But maybe you haven't done any real investigation into what they are, what they do, and why they exist. So, with that in mind, this article takes you on a brief journey into the world of specialty processors!

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

Protecting the data in our enterprise databases is extremely important. But what exactly does that mean? And what are the repercussions of managing database security in the age of compliance and Internet-connectivity?

The Database Report: 2Q2009.
The Data Administration Newsletter, July 2009.

This installment of "The Database Report" covers DBMS industry new for the Sexond quarter of 2009, spanning April thru June -- and includes coverage of Oracle's acquisition of Sun Microsystems.

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

So just what does the job of database administrator entail today? Are there really DBAs doing just DBA work any more? What else is required? And is the title DBA still relevant?

This article focuses on debunking the practice of creating "black box" access routines that sit between application programs and DB2. Such configurations remove the requirement for programmers to know how to code SQL--but is this a good thing?

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

This month's column offers up some advice and guidance to job-seeking DBAs, data architects, and database programmers. Given the state of the economy circa mid-2009, I this should be a timely topic!

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

This short article discusses a thorny problem -- data quality -- experienced by most organizations.

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

In this month's edition of z/Data Perspectives we take a peak under the covers of DB2 to examine the impact of system configuration issues (e.g. DSNZPARMs) on DB2 performance.

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

This month's column offers a checklist of questions to help you evaluate DBA tools and vendors.

The Database Report: 1Q2009.
The Data Administration Newsletter, April 2009.

This installment of "The Database Report" covers DBMS industry new for the First quarter of 2009, spanning January thru March.

Utility Improvements in DB2 9 for z/OS.
IDUG Solutions Journal, Spring 2009.

Every new release of DB2 brings with it new functionality and improvements for the IBM DB2 utilities. And DB2 Version 9 is no exception. So let’s take a high level look at the many enhancements made to the utilities in DB2 9 for z/OS.

The Impact of M+A on Data Management.
Data Center Journal, March 2009.

Managing an ever-increasing mountain of data is not a simple task in the best of times, but doing so while combining formerly separate entities during an economic slowdown can be a monumental challenge.

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

This month's column focuses on the importance of gathering appropriate database statistics to enable the optimizer to formulate efficient access paths to your data.

Recovery is a Compliance Issue.
zJournal, February / March 2009.

This month's z/Data Perspectives column examines the regulatory compliance implications of database backup and recovery.

Ten Steps for Mitigating Data Risk During a Merger.
CIO Magazine, February 2009.

Getting a handle on all of the data in your post-acquisition organization requires time and effort. But it need not be fraught with risk.

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

This month's column focuses on the importance of gathering appropriate database statistics to enable the optimizer to formulate efficient access paths to your data.

10 Steps for Mitigating Data Risk During a Merger.
ComputerWorld, February 24, 2009.

Getting a handle on all of the data in your post-acquisition organization requires time and effort. But it need not be fraught with risk.

Database Fundamentals.
IDUG Solutions Journal, Winter 2008/2009.

A back to basics review of the fundamentals of data, databases, and database management concepts, issues, and terminology.

The Database Report: 4Q2008.
The Data Administration Newsletter, January 2009.

This installment of "The Database Report" covers DBMS industry new for the Fourth quarter of 2008, spanning October thru December.

DBA Proverbs.
zJournal, December / January 2009.

This month in z/Data Perspectives we take a look at wisdom handed down through the ages that can be applied toward becoming a better database administrator... if you are creative!

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

Staffing the DBA organization is not a simple matter. Several non trivial considerations must be addressed, including the size of the DBA staff and the reporting structure for the DBAs.

Index: 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 and older

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

In this month's edition of DBA Corner I take a look back at the year that was in terms of the data and database management market this past year.

Data, Data, Everywhere.
Database Trends and Applications, November 2008.

Data is expanding rapidly in today's corporations, but we are also expanding our personal use of data.

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

Even the most diligent DBAs have probably neglected one, if not more, of the things I cover in this article!

DB2 Database Maintenance and Recovery: Getting Past the Common Misconceptions.
zJournal, October / November 2008.

Some misconceptions exist because they’ve been passed down from older generations. But in terms of DB2, best practices for older DB2 versions may no longer be best. This article examines several common misconceptions about DB2 maintenance and recovery.
(co-authored with Brenda Honeycutt)

Reoptimizing SQL.
zJournal, October / November 2008.

This month in z/Data Perspectives we examine ways to re-optimize dynamic and static SQL, as well as the potential benefits of doing so.

Auditing who did what to which data when... and how... is a crucial requirement for financial data, especially given the increasing role of regulatory compliance on financial institutions and the data they manage.

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

This article discusses best practices methodologies for assuring optimal performance by rigorously controlling changes to your DB2 plans and packages.

The Database Report: 3Q2008.
The Data Administration Newsletter, October 2008.

This installment of "The Database Report" covers DBMS industry new for the third quarter of 2008, spanning July thru September.

What Every Good CIO Needs to Know About Mainframe Database Auditing.
Mainframe Executive, September 2008.

Regulatory compliance has become a critical aspect of the IT landscape, and is a big component of every CIO’s job... and nowhere is compliance more crucial than in mainframe database management. A growing number of regulations dictate increased efforts be made to better secure and protect the accuracy and privacy of enterprise data. Since the most valuable enterprise data frequently is stored in a mainframe database, organizations must implement more robust auditing capabilities into their DB2 and IMS environments.

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

This month's DBA Corner column tackles one of the most common questions I am asked: "How can I become a DBA?"

DB2 9 Data Format "Stuff".
zJournal, August / September 2008.

This month in z/Data Perspectives we take a look at all of the new features and functionality that impact the format of DB2 databases and structures.

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

Implementing database administration appropriately and effectively in your organization requires careful thought and planning. At a primary level, though, you need to be able to describe what a DBA must be able to do. This article condenses the basic requirements into 17 basic skills that make a successful DBA.

The Database Report: 2Q2008.
The Data Administration Newsletter, July 2008.

This installment of "The Database Report" covers DBMS industry new for the second quarter of 2008, spanning April thru June.

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

A detailed classification of which data is being used, how it is being used, and when it is being used is required to align data with appropriate regulations and storage types. This article suggests one method for creating such a classification scheme.

The Rise of Dynamic SQL.
zJournal, June / July 2008.

This month in z/Data Perspectives we examine the factors contributing to the increasing popularity of dynamic SQL in DB2 applications and systems.

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

Without metadata data cannot be turned into information. But aside from this fact, governmental regulations require the classification of data, which is also impossible without metadata.

On Recovery Service Levels.
IDUG Solutions Journal, Spring 2008.

Well-planned recovery procedures should be able to assure a complete recovery of enterprise-critical data within a pre-defined time window that provides for minimum disruption of the business. However, within complex environments, it is nearly impossible to perform recovery tests without disrupting the production system. With these issues in mind, this article examines the risk management of business availability, especially focusing on database health.

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

If you read the It press these days you know that data breaches are quite pervasive. We keep hearing about data being lost, stolen, and nefariously accessed. It is all enough to give a data professional a throbbing headache. But what is the actual cost of these data breaches?

Use Real Time Statistics to Automate Your Database Maintenance.
zJournal, April / May 2008.

This month in z/Data Perspectives we examine the Real Time Statistics (RTS) and the benefits that can be accrued by using RTS.

The Database Report: 1Q2008.
The Data Administration Newsletter, April 2008.

This installment of "The Database Report" covers DBMS industry new for the first quarter of 2008, spanning January thru March.

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

Long-term data retention is a reality. And in this edition of the DBA Corner column I review a recent survey on archiving and relate the findings to the retention and preservation of database for long durations.

Collecting Histogram Statistics With RUNSTATS.
DB2 Update, March 2008.

This article discusses one of the many new enhancements that have found their way into DB2 9 for z/OS -- the ability to gather histogram statistics with the IBM RUNSTATS utility.

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

In this edition of the DBA Corner, I review the recent salary surveys with a particular emphasis on the pay for data-related jobs.

Much Ado About DB2 Locking.
zJournal, Feb / March 2008.

This month in z/Data Perspectives we examine the new locking-related features of DB2 for z/OS.

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

One of the more troubling aspects of the DBA job these dayss is keeping up with the latest version of the DBMS. A typical release cycle for DBMS software is 18 to 24 months for major releases with constant bug fixes and maintenance delivered in between major releases. Indeed, keeping DBMS software up-to-date can become a full-time job.

Compliance Needs Drive Data Access Auditing Requirements.
IDUG Solutions Journal, Winter 2007.

An increasing number of regulations are being passed that require effort to be exerted to better secure and protect the accuracy and privacy of enterprise data. This expanding need for data auditability is the focus of this issue's column.

Data Management Made News in 2007.
Database Trends and Applications, January 2008.

In this month's edition of DBA Corner I take a look back at the machinations within the database market over the past year.

The Database Report: 4Q2007.
The Data Administration Newsletter, January 2008.

This installment of "The Database Report" covers DBMS industry new for the Fourth quarter of 2007, spanning October thru December.

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

This month in z/Data Perspectives we examine the many improvements in the security features and functionality available in today's database management systems.

Index: 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 and older

This article discusses a helpful new DB2 Version 9 feature that can be used with multiple utilities: TEMPLATE switching.

If you can't recover your databases after a problem then it doesn’t matter how fast you can access them. So how can anyone deny that recoverability is more important than performance?

Data Quality Starts With Proper Data Type.
Quest Pipelines, December 2007.

Choosing the proper data type and length for each column in each table is the first step to improving data quality. This article outlines the impact of proper data types on database integrity.

One of the more useful techniques to protect your company’s database data is via data access auditing, which is a facility for tracking the use of, and modifications made to, database resources and authority.

New Data Types in DB2 9 for z/OS.
DB2 Update, November 2007.

DB2 Encryption Support Keeps Improving.
zJournal, Oct / Nov 2007.

This month in z/Data Perspectives we examine DB2's encryption capabilities on z/OS and the improvements made to encryption in Version 9.

Tracking Data Access for Compliance.
Group Practice Journal, October 2007.

Increased regulations demand the implementation of policies and procedures to protect sensitive healthcare data. Medical professionals must be ever vigilant in the techniques used to manage and protect the data under their care. And that means companies have to perpetually monitor their systems in order to know who did exactly what, when and how - to their data.

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

This month in the DBA Corner we explore the negative impact that ballooning data volumes have on operational database performance and maintenance... and we show how database archiving can be a solution to the problems created with large databases.

The Database Report: 3Q2007.
The Data Administration Newsletter, October 2007.

Another edition of my quarterly column titled "The Database Report." This installment covers news in the DBMS community for the Third quarter of 2007, spanning July thru September 2007.

Electronic Discovery: It's Not Just About e-Mail.
FindLaw, September 2007.

Most organizations have policies that focus on e-mail retention because of the highly publicized e-discovery cases that relied on information discovered in e-mail communications. But it is critical that retention policies not stop there. The transactional data stored in database systems also must be readily accessible in the event of an e-discovery request.

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

This month in the DBA Corner we ruminate on methods of enabling an easier-to-use search capability for production databases much like the ubiquitous search capability available on the web.

The Buffer Pool: Regulatory Compliance and Database Archiving.
IDUG Solutions Journal, Summer 2007.

In this issue's column we address the archiving of data from operational databases to support long-term data retention regulations.

DB2 9 for z/OS Improves LOB Support.
zJournal, Aug / Sept 2007.

In this month's edition of the z/Data Perspectives we look at the many improvements IBM has made to DB2's support for Large OBjects in Version 9.

Database Access Auditing: Who Did What to Which Data When?
DM Direct, August 24, 2007

Tracking who does what to which specific piece of data is important because there are many threats to the security of your data. This article outlines the issues and proposes some guidelines for a database auditing solution.

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

Many regulations impact the need to retain data for long durations, and this is especially so for data under the care of financial institutions. This article provides guidance on techniques for archiving data to assure regulatory compliance for sensitive financial information.

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

This month's DBA Corner column pontificates on the importance of choosing the proper data type and length for each column in each table and how this simple task is the most fundamental integrity aspect of database design for integrity.

Database Access Auditing: Who Did What to Which Data When?
DW Direct, July 10, 2007

Tracking who does what to which specific piece of data is important because there are many threats to the security of your data. This article outlines the issues and proposes some guidelines for a database auditing solution.

The Database Report: 2Q2007.
The Data Administration Newsletter, July 2007.

Another edition of my quarterly column titled "The Database Report." This installment covers news in the DBMS community for the Second quarter of 2007, spanning April thru June 2007.

This month's DBA Corner column offers a modest proposal for new IT professionals.

The laws and practices that govern the production of evidence in courts of law are changing, and it will have a significant impact on data management. This month's DBA Corner column discusses why this is so.

If You Ain't 8 You're Late.
zJournal, April / May 2007.

The purpose of my column in this issue of zJournal is to look at the status of the DB2 for z/OS community and to convince you to migrate to V8 if you have not done so already.

The Buffer Pool: DB2 Database Performance Fundamentals.
IDUG Solutions Journal, Spring 2007.

This article offers an introduction to the basic premises and notions behind performance management of relational databases in general, and DB2 in particular.

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

Governmental regulations are increasing in number and frequently dictate the amount of time organization must retain different categories of data. To be in compliance with the rules organization will need to focus on regularly archiving their database data in an accessible format. This article discusses the high-level requirements for database archiving.

The Return of the Repository?
Database Trends and Applications, April 2007.

As regulatory compliance increases and data governance gains prominence will the Repository encounter a resurgence in popularity?

The Database Report: 1Q2007.
The Data Administration Newsletter, April 2007.

This installment of "The Database Report" covers DBMS industry new for the First quarter of 2007, spanning January thru mid-March.

Data Governance is More Than Regulatory Compliance.
Database Trends and Applications, March 2007.

Data governance has become a code word for preparing your databases for regulatory compliance. But instituting a comprehensive data governance practice involves much more than just compliance.

DB2 9 for z/OS: No V for z.
zJournal, February / March 2007.

The beta program for the next version of DB2 for z/OS began back in June of 2006. So it is high time we took a glimpse at what this latest and greatest version of DB2 has to offer.

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

If you're a DBA who just can't seem to come up with a good New Year's resolution or two, let me suggest a couple for you...

Efficient SQL Coding Basics.
DB2 Update, February 2007.

Poorly coded SQL and application code can cause performance problems. This article offers guidance on the basics of good SQL programming for DB2 application developers.

DB2 z/OS Index Creation Guidelines.
Quest Pipelines, February 2007.

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

There is not just one simple job "out there" with the title database administrator (or DBA). There are actually many jobs that fall under the larger discipline of database administration and this article documents the most popular DBA roles.

Change Control for DB2 Access Paths.
Quest Pipelines, January 2007.

This article discusses three SQL tips for DB2 that can be used in certain situations to streamline your code. One tip deals with dates, another with removing extra spaces, and a third with aggregating aggregates.

The Database Report: 4Q2006.
The Data Administration Newsletter, January 2007.

This installment of "The Database Report" covers DBMS industry new for the Fourth quarter of 2006, spanning October thru December.

Database Archiving for Long-Term Data Retention.
zJournal, December / January 2007.

Index: 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 and older

Harness The Full Power of Your Data.
Teradata Magazine, December 2006.

An introduction to advanced analytics, including an introduction to Teradata's advanced analytics capabilities and some of their customer's activities in this area.

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

Although the performance of database systems and applications can be impacted by numerous factors, paying close attention to two "things" can minimize database performance problems.

The Buffer Pool: Why Haven’t You Started Using Real Time Statistics?
IDUG Solutions Journal, Winter 2006.

Maintaining efficient DB2-based systems requires analyzing your database objects. But how can you ensure that you are getting up-to-date statistics on your objects? Well, one way is to use Real-Time Stats (RTS). In this edition of The Buffer Pool we will examine RTS and how they can help optimize your DB2 administration tasks.

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

Data proceeds through a predictable lifecycle as it advances through applications and business processes. Understanding this lifecycle can help to better prepare organizations for dealing with data governance and regulatory compliance issues as they impact your corporate data.

DB2 9 for z/OS Roars to Life.
DB2 Magazine, Quarter 4, 2006 Vol. 11, Issue 4

A short introductory article covering the highlights of the next version of DB2 for z/OS, including coverage of XML, online schema evolution advances, new query capabilities, security and performance improvements, and features removed from DB2 9.

To Rebind or Not to Rebind: Is That a Question?
zJournal, October / November 2006.

One of the most important contributors to the on-going efficiency and health of your DB2 environment is proper management of DB2 access path changes. In this article we discuss how a thorough REBIND management process is a requirement for healthy DB2 applications.

Database Archiving for Long-Term Data Retention.
The Data Administration Newsletter, October 2006.

The onslaught of governmental regulations is causing organizations to expand the amount of time they retain data. This requires that database data is archived regularly in an accessible format. Read this article to understand the requirements of database archiving.

The Database Report: 3Q2006.
The Data Administration Newsletter, October 2006.

This installment of "The Database Report" covers DBMS industry new for the third quarter of 2006, spanning July thru September.

The Buffer Pool: Change Control for DB2 Access Paths.
IDUG Solutions Journal, October 2006.

On-going analysis and management of DB2 access paths is important to ensure DB2 application performance. Yet many organizations fail to keep access paths up-to-date. In this edition of The Buffer Pool column we examine access path change management and look at some methods for introducing a better change control discipline for DB2 access paths.

Databases Must be Archived for Long-Term Data Retention.
Database Trends and Applications, October 2006.

In this month's DBA Corner column we take a look at database archiving and the regulations that are driving its adoption in organizations.

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

In this month's DBA Corner column we take a look at the various change management challenges faced by database administrators.

z/Data Perspectives: It's Time for Real Time Stats.
zJournal, August / September 2006.

Although Real Time Statistics (RTS) have been available since just after V7, the feature is not widely implemented. This edition of the z/Data Perspective column discusses the benefits of RTS and urges DB2 shops to use RTS to maintain DB2 statistics “on the fly.”

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

This month's edition of the DBA Corner column examines capacity planning issues from a database perspective.

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

This month's edition of the DBA Corner column examines data professional's salaries as reported by various surveys and reports.

The Database Report: 2Q2006.
The Data Administration Newsletter, July 2006.

This installment of "The Database Report" covers DBMS industry new for the second quarter of 2006, spanning April thru June.

z/Data Perspectives: The Basics of DB2 Buffering.
zJournal, June / July 2006.

Memory usage is one of the most important areas for tuning DB2 subsystem performance. The better memory is allocated to buffers, the better DB2 will perform.

Gaining Knowledge Through Process Mining.
Enterprise Leadership, June 2006.

Process miningit is a growing discipline similar to data mining. Data mining is an analytical process using heuristics to explore large sets of data in search of consistent patterns and relationships. Process mining deploys similar tactics using event logs.

A Few SQL Tips and Techniques.
Quest Pipelines, June 2006.

This article discusses three SQL tips for DB2 that can be used in certain situations to streamline your code. One tip deals with dates, another with removing extra spaces, and a third with aggregating aggregates.

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

Data security should be an important aspect of the data professional's job duties. But with the increasing instances of data breaches it is reasonable to question just how important security is -- or isn't.

Supplying Intelligence.
Teradata Magazine, June 2006.

An overview of Teradata's SeeChain supply chain management software that lets users take action to solve supply chain problems before they happen. Co-written with Rick Lower, solutions manager in Teradata’s demand and supply chain marketing department

The Last Date of the Century.
DB2 Update, May 2006.

A short article detailing how to use SQL in DB2 to retrieve the last date of a given century.

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

Even though it has been said that the best thing about standards is that there are so many to choose from, corporate standards and procedures for using database systems are important for ensuring smooth operational applications and systems.

The Buffer Pool: A Few SQL Tips and Techniques.
IDUG Solutions Journal, May 2006.

It is always a good idea to keep your bag of SQL tricks filled with techniques to help you deal with troubling application development problems. This article goes over a few tips that might just help your out of a difficult spot.

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

In this z/Data Perspectives column we discuss the impact of governmental regulations (such as Sarbanes-Oxley) on data and database management policy.

Social Networks: A Whole Different Reality Under the Radar.
Enterprise Leadership, April 2006.

Does your company’s organizational chart accurately depict how things actually work in your company? Perhaps not. There is an underlying social infrastructure that exists in most organizations. It is informal, but functionally powerful. This article explores this phenomenon and the impact it can have on your business.

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

One of the biggest growing concerns for data professionals is the treatment of data in terms of security, personal privacy, and the potential for abuse. This installment of the DBA Corner takes a look at these concerns.

A Guide to DB2 Locking – Part 3.
dbazine.com, April 2006.

In this third and final installment of a three-part series (adapted from my book, DB2 Developer’s Guide) on locking in DB2 for z/OS, we expand to cover locking in a Data Sharing context, and then offer some basic guidelines for implementing efficient locking in your DB2 systems.

The Database Report: 1Q2006.
The Data Administration Newsletter, April 2006.

This first installment of 2006 of "The Database Report" covers the latest breaking news in the DBMS industry for January thru March 2006.

A Guide to DB2 Locking – Part 2.
dbazine.com, March 2006.

In the second of a three-part series (adapted from my book, DB2 Developer’s Guide) on locking in DB2 for z/OS, we extend our understanding of DB2 locking by examining the types of locks, claims and drains, and lock avoidance.

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

Data and database administration are complementary roles. It is important to know the differences between the roles - and to remember that both are required in order to effectively manage business data.

Model-Based Development and Management.
zJournal, Feb / March 2006.

In this z/Data Perspectives column we discuss how an integrated solution for modeling can help streamline information exchange and enable organizations to effectively translate disparate requirements in context.

The Buffer Pool: A View Review.
IDUG Solutions Journal, February 2006.

The manner in which views can be utilized to provide the greatest benefit can be an area of disagreement between DB2 professionals. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach. This article examines the issues and gives guidance on proper view usage with DB2.

A Guide to DB2 Locking – Part 1.
dbazine.com, February 2006.

In the first of a three-part series (adapted from my book, DB2 Developer’s Guide) on locking in DB2 for z/OS, we examine the high-level basics of DB2 locking, including the reason a DBMS needs a locking mechanism, locks versus latches, the BIND parameters that impact locking, and the impact on your programs.

Do The Simple Things First.
Quest Pipelines, February 2006.

Sometimes we can get too caught up in making things more complex than they really are. By concentrating on the simple things, and making sure we get them done correctly, we can greatly improve the manner in which we administer and use DB2.

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

When databases are designed for e-business applications the tendency is for the DBA to get swept up in the dynamics of web-based design and development. This can be a dangerous mistake when designing databases. This column examines why this is so.

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

Storage management can be quite complex, but when you factor in multiple different database platforms on a variety of operating systems, managing storage becomes extremely challenging.

Assuring Data Integrity in DB2. (Part 2)
dbazine.com, January 2006.

In part 1 of this article, we discussed some of the mechanisms DB2 uses to maintain data integrity. Part 2 of this article discusses more of these mechanisms, highlighting check constraints and their guidelines, code constraints, and more.

The Database Report: 4Q2005.
The Data Administration Newsletter, January 2006.

This year-end installment of "The Database Report" covers the latest breaking news in the DBMS industry for the fourth quarter of 2005.

Index: 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 and older

Top Five DB2 V8 Transition Do’s and Don’ts.
zJournal, Dec 2005 / Jan 2006.

This z/Data Perspectives column provides guidance on things to avoid and things to plan for as you begin to migrate from DB2 V7 to DB2 V8 on the z/OS platform.

What SQL Can Be Used in a Compound SQL Statement?
SearchDataCenter.com, November 2005

Q+A session for web portal on compound SQL.

DBA Staffing Considerations.
SearchDataManagement.com, November 2005.

It can be difficult to determine the optimal number of DBAs required to keep an organization's databases online and operating efficiently; this short article suggests some metrics.

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

Although database administration is required to ensure the efficient and proper design and care of the data in production databases, today’s database systems do not deliver all of the needed functionality required to support large-scale development. In this column we briefly review the many types of data management tools that are available to enhance the functionality of your DBMS.

SQL Performance Tuning Basics.
zJournal, October / November 2005.

This z/Data Perspectives column offers some basic SQL tuning guidelines and rules to help guide you along the path toward building efficient DB2 applications.

The Buffer Pool: Simple Things First.
IDUG Solutions Journal, October 2005.

Simplicity is the theme of this installment of The Buffer Pool column. By concentrating on the simple things, and making sure we get them done correctly, we can greatly improve the manner in which we administer DB2.

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

Database archiving solutions can be implemented not only to tackle on-going database and data growth, but also to help improve performance, increase availability and lower costs. 

The Database Report: 3Q2005.
The Data Administration Newsletter, October 2005.

Read "The Database Report" to hear all about the latest news regarding database management systems and the most popular DBMS vendors.

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

Database transactions logs are a rich source of information that should not be ignored.

Evaluating DB2 Tool Vendors.
zJournal, August / September 2005.

In this installment of the z/Data Perspectives column we explore the proper questions to ask -- and have answered -- when you are shopping for DB2 tools.

Assuring Data Integrity in DB2. (Part 1)
dbazine.com, August 2005.

DB2 provides many techniques to automatically enforce and maintain data integrity within your tables. This article describes these techniques and discusses their benefits.

The Aging Mainframer.
Search390, August 2005.

We continue to hear that the mainframe is dead, but is that really so? More important than the actual hardware is the people who manage it. Where will new mainframers come from?

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

New database books are being published all the time, but which ones are actually worth buying? This month's column examines three recent books that are worth DBA's time and effort to purchase and read.

The Database Report: 2Q2005.
The Data Administration Newsletter, July 2005.

This edition of the quarterly column, "The Database Report," covers the latest news in the DBMS industry including: Oracle's acquisitions, IBM's Viper, and Microsoft TechEd (among other news).

Twenty-Two Years of DB2.
zJournal, June / July 2005.

DB2 has been around for more than two decades now and in this installment of the z/Data Perspectives column we examine how it has grown from its humble beginnings.

Sarbanes-Oxley Requires Rigor in Database Administration: The DBA Corner.
Database Trends and Applications, June 2005.

The Sarbanes-Oxley Act is the most significant government legislation affecting accounting and auditing in more than 70 years. If you work for a public company, you’ve most likely felt the impact of this legislation. But what will be the impact of the Sarbanes-Oxley Act on DBAs?

Some SQL Tricks for the DB2 Developer.
DB2 Update, June 2005.

This article covers several SQL "tricks" to help out during certain type of development situations.

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

Database administration is a complex job requiring patience and experience. But does it also require a philosophy?  Applying Taoist philosophy to database "problems" might just be helpful...

A Short Introduction to Lock Avoidance in DB2 for z/OS.
dbazine.com, May 2005.

A brief introduction to lock avoidance techniques that can be used for your mainframe DB2 applications.

Changing Table Space Partitioning Specifications.
zJournal, April / May 2005.

In this installment of the z/Data Perspectives column we look at the improvements made to managing partitioned table spaces in DB2 V8.

The Buffer Pool: On VSAM and DB2.
IDUG Solutions Journal, April 2005.

In this installment of The Buffer Pool column we examine the issues involved when planning to migrate from VSAM to DB2.

The Database Report: 1Q2005.
The Data Administration Newsletter, April 2005.

Check in with "The Database Report" to read the latest news regarding database management systems and the most popular DBMS vendors.

Plan for Disasters and Test the Plan Regularly: The DBA Corner.  
Database Trends and Applications, April 2005.

A disaster recovery plan is like insurance – you're glad you have it, but you hope you don't need it. But without a plan you will be unprepared in the event of the unthinkable.

Often Misunderstood, Don't Ignore Nulls: The DBA Corner.  
Database Trends and Applications, March 2005.

Nulls are a necessary evil if you use today's most popular SQL database systems. Failing to understand what they are and how to use them is a sure recipe for disaster.

DB2 Annoyances.  
zJournal, February/March 2005.

Annoyances are those little things software does to drive intelligent people crazy. There isn’t a piece of commercial software out there that is not plagued with annoyances and DB2 has its fair share of them. In this article, we examine a few of them.

Database Trends.
SearchOracle.com, February 2005.

A look at the trends and issues impacting the database market as of early 2005.

A Database Bookshelf.
SearchOracle.com, February 2005.

This short article offers suggestions on database management books that are recommended for every database professional to own.

DBA Certification.
SearchOracle.com, February 2005.

Here we examine the benefits and shortcomings of DBA certification.

How Many DBAs?
SearchOracle.com, February 2005.

One of the most common problems perplexing DBA groups and managers is how many DBAs are needed to support their environment. This article examines the issues surrounding DBA staffing.

It's Alive! It's Alive!
SearchOracle.com, February 2005.

This article discusses the reasons why IBM's mainframe computing platform continues to not only exist, but prosper.

Open Source Database Systems.
SearchOracle.com, February 2005.

Open source is a rolling freight train that cannot be stopped, and the DBMS is caught up in the frenzy. This article examines the open source trend as it impacts database systems.

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

The marketing literature tells us that autonomic computing is finding its way into modern DBMS products. But what is the truth of the matter?

The Data Explosion.
SearchOracle.com, February 2005.

This article discusses the issue of phenomenal data growth and its impact on DBAs.

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

Some advice and guidance for folks' who think they want to become a database administrator.

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

Some thoughts on the ever-changing, ever-expanding role of the DBA.

Intelligent Automation Can Solve the Complexity Problem: The DBA Corner.
Database Trends and Applications, February 2005.

Database administration is a complex job. One of the ways to simplify DBA problems is through intelligent automation. By automating some of the tedious day-to-day tasks of database administration, we can simplify our complex environment and reduce manual errors.

The Database Report: 4Q2004.
The Data Administration Newsletter, January 2005.

Check in with "The Database Report" to read the latest news regarding database management systems and the most popular DBMS vendors.

Performance Tuning Requirements for Database Applications: The DBA Corner.
Database Trends and Applications, January 2005.

Database application tuning can be broken down into three components: system tuning, database tuning, and application tuning. This article discusses each component and how all are required to ensure efficiency.

The DB2 Utility Conundrum.
zJournal, December 2004/January 2005.

As organizations finish migrating to DB2 Version 7, they have a decision to make regarding DB2 utilities. This article explains the options and examines the reasons behind this utility conundrum.

Index: 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 and older

High Speed Transaction Recovery.
Technical Support, November 2004

As the demand for 24x7 processing increases, DBAs are looking for ways to perform database maintenance tasks with minimal or not outages. This article discusses high availability database recovery techniques to meet this demand head on. 

The Top Ten Features of DB2 for z/OS V8.
zJournal, October/November 2004.

This installment of the z/Data Perspectives column looks at the top ten new features of DB2 Version 8. Of course, this is just my opinion, but I think I can back it up!  Check it out.

Three Trusty Rules for DB2 Triggers.
DB2portal.com, October 2004.

This article discusses the benefits of dynamic SQL along with coverage of each of the different types of dynamic SQL that can be used with DB2 for z/OS.

What is Large?
zJournal, August/September 2004.

What do people really mean when they talk about large databases? The term is nebulous and ever changing. This article examines just what is meant by the term large database today.

IMS is Alive and Kicking.
zJournal, June/July 2004.

While hierarchical database systems have been surpassed in the marketplace by relational and SQL products like DB2, IMS can brag about its long and proud legacy that continues on today. This installment of my zData Perspectives column examines the current state and health of IBM's IMS.

This article discusses the Real Time Stats (RTS) feature of DB2 for z/OS including definitions of the RTS columns and suggested queries to use for DB2 performance management and administration.

DB2 Advice Your Daddy Didn't Give You.
search390.com, June 2004.

A collection of DB2 questions and answers from my gig as a contributor to the search390 ATE section.

The Buffer Pool: Recursion in DB2 V8, V8, V8... 
IDUG Solutions Journal, Vol. 11, No. 1

In this installment of The Buffer Pool column we examine the recursive SQL capabilities of DB2 for z/OS Version 8. Recursion is demonstrated by means of a simple hierarchy and the SQL needed to walk the hierarchy.

Ever thought about outsourcing your DBA group? This article gives you several reasons why this might not be the best idea in the world.

Ever since the first relational DBMS products were introduced, DBAs have fought the battle of normalization versus denormalization. This installment of my zData Perspectives column examines MQTs and explains why denormalization may be on the brink of extinction.

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

With all the talk of autonomic computing and self-managing database systems some folks think that DBAs are on the fast path to extinction. But there are many reasons why DBAs are going to be needed for a long time. This article examines these reasons.

An Introduction to DB2 Indexing.
dbazine.com, February 2004.

Learn the basics of DB2 for z/OS indexing in this introductory article. Includes discussion of up-to-date Version 8 information on indexes such as changes to partitioning, DPSIs, and non-padded indexes.

DB2 or VSAM?
dbazine.com, February 2004.

This short article provides a synopsis of the advantage of DB2 over VSAM and other flat file approaches. It can be used to reinforce concepts you already know or to educate those who ask that age-old question "Why VSAM shouldn’t be used instead of DB2?"

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

All aspects of the database and application code must be reviewed for efficiency, effectiveness, and accuracy. If done correctly, design reviews are conducted at various times during the application lifecycle.

This article discusses two methods available for generating sequential values for a DB2 column: identity columns (available as of V6) and sequence objects (available as of V8).

The right information infrastructure can support a company all the way to the top or hinder its rise. IBM’s offerings combine rock-solid performance with the flexibility to handle what’s around the corner.

Many technologies and marketers throughout the years have claimed that data has become irrelevant and that some “new and improved” technology, technique, or ideology will replace data as the center of IT and data processing. But it has yet to happen, and it never will happen, either!

An Introduction to Database Design: From Logical to Physical.
dbazine.com, November 2003.

A proper database design cannot be thrown together quickly by novices. What is required is a practiced and formal approach to gathering data requirements and modeling data. This article provides a quick introduction to the concepts of logical modeling database design.

The Buffer Pool: Know Your Isolation Levels.
IDUG Solutions Journal, Vol. 10, No. 3

In this installment of The Buffer Pool column we examine the various options for setting the isolation level in DB2 programs and the implications of each.

zData Perspectives: DB2 V8 Online Schema Evolution.
zJournal, October/November 2003.

Making changes to database structures can be tedious and error-prone, unless you are using a software tool to manage the process. DB2 V8, though, introduces online schema evolution so now, in some cases, you can make changes using a simple ALTER to modify specific characteristics of a DB2 object.

Measuring DBA Effectiveness.
dbazine.com, October 2003.

Measuring the performance of IT professionals can be a difficult proposition. It can be particularly thorny when trying to measure the effectiveness of DBAs.

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

Business requirements are increasingly demanding downtime be diminished. This causes DBAs to scramble to address these needs. This piece looks at the increasing desire for 24x7 availability and the problems it can cause.

The Database Report: 3Q2003. 
The Data Administration Newsletter, October 2003.

Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on Oracle's hostile acquisition bid for PeopleSoft, the announcement of Oracle 10g, as well as a look at news from IBM, Microsoft, and Sybase.

Q&A: Tips for Making Data Warehouses Manageable.
searchdatabase.com, September 19, 2003.

In this interview conducted by TechTarget, Craig discusses current issues in data warehouse administration and management.

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

To be a successful DBA you will need to keep up-to-date on the latest skills - and reading is a great way to do that. This short piece provides advice on some good books for DBAs to acquire and read to hone their database and other related skills.

Although V8 has been out for several months now on Linux, Unix, and Windows platforms, it was just recently announced in January 2003 for mainframe platforms. There is a reason for this — DB2 for z/OS Version 8 is a huge and complex beast. This article will provide you with an overview of the major features and functions of DB2 for z/OS V8.

zData Perspectives: DB2 V7 B4 V8.
zJournal, August/September 2003.

There has been a lot of excitement lately about the next version of DB2, V8, but in this installment of zData Perspectives column we examine several DB2 V7 features that can be implemented today, before V8 arrives.

The Buffer Pool: Choose the Proper Data Type.
IDUG Solutions Journal, Vol. 10, No. 2

In this third installment of my regular column that looks into misunderstood DB2 functionality we discuss the issue of using proper DB2 data types.

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

DBAs are frequently thought of as crusty curmudgeons with vast technical knowledge, but limited people skills. This month's column examines this phenomenon and offers guidance on how best to handle a curmudgeonly DBA.

The Database Report: 2Q2003. 
The Data Administration Newsletter, July 2003.

Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on Oracle's hostile acquisition bid for PeopleSoft, Yukon delays, revised market share numbers, as well as our regular look at database software revenue figures for the major players. 

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

DBAs need different skills when operating in a development versus production capacity. Both, though, are critical for successful database processing. This month's column examines and compares the different disciplines required for each type of DBA.

This article focuses on debunking the practice of creating "black box" access routines that sit between application programs and DB2. Such configurations remove the requirement for programmers to know how to code SQL--but is this a good thing?

zData Perspectives: DB2 and the Old Dipsy Doo.
zJournal, June/July 2003.

The third installment of the bi-monthly zData Perspectives column covers the new DB2 V8 feature - Data Partitioned Secondary Indexes.

Denormalization of DB2 Tables.
searchdatabase.com, June 2003.

A short introduction to the various denormalization options available when designing physical DB2 databases.

As the DBMS vendors slice and dice their packaging into more and confusing editions and models life gets more confusing for DBAs. This month's column examines the many different DBMS packaging and architectural options for DB2 as an example of how confusing things have become.

This article looks at mainframe DB2's ability to enable the storage and management of complex data types using large objects (LOBs).

The sixth and final installment in this series discusses newer technologies that rely on database administration — at least somewhat — to be effectively implemented: database-coupled application logic, Internet-enabled e-business development, and hand-held computing.

Basic DB2 Buffering and Memory Guidelines.
searchDataCenter.com, May 2003.

One of the most important areas for tuning DB2 subsystem performance is memory usage. This tip offers some basic guidance for setting up and tuning DB2 memory usage.

The Buffer Pool: Dynamic Buffer Changes.
IDUG Solutions Journal, Vol. 10, No. 1

This column further investigated commonly misunderstood DB2 functionality – concentrating on dynamic buffer changes and parallel access and partitioning.

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

This month we discuss some basic rules of thumb for DBAs to follow to make their jobs —and lives —easier.

zData Perspectives: DB2—Versions, Service and Such.
zJournal, April/May 2003.

Keeping up-to-date with the latest and greatest DB2 versions and functionality can be a time-consuming task. The second installment of this new column offers up the state of mainframe DB2 versions, releases, and support. 

DB2 Utilities Through the Looking Glass.  
dbazine.com, April 2003.

To pay for IBM's DB2 utility functionality or buy third-party products — that is (one of) the questions ...

SQL Server Transaction Log Guidelines.
dbazine.com, April 2003.

The transaction log is a fundamental component of Microsoft SQL Server. All changes to data in the database are recorded in the transaction log. This article provides a basic introduction to the way in which SQL Server implements and uses transaction logs.

Complexity Complicates Database Upgrades & Migrations: The DBA Corner.
Database Trends and Applications, April 2003.

This month we continue our focus on the increasing complexity of DBMS software with particular attention paid to the task of DBMS upgrades and migrations. 

The fifth installment in this series discusses how to handle the difficulty of managing multiple DBMSs in a multiplatform environment -- that is, heterogeneous database administration.

The Database Report: 1Q2003.
The Data Administration Newsletter, April 2003.

Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on Oracle's revenues, V8 of mainframe DB2, and the Microsoft SQL Server Slammer worm. 

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

A lot has been written about XML in the few years. It is one of the most hyped, and least exciting new technologies in years. XML ain’t all that groundbreaking and it is dangerous to the health of your databases!

DB2 Table Space Options, Part 2.
Mainframe Week, April 2, 2003.

Second part of article discussing DB2 for OS/390 table spaces.

DB2 Table Space Options, Part 1.
Mainframe Week, March 26, 2003.

When designing DB2 databases, DBAs can choose from three types of table spaces, each one useful in different circumstances. This article examines each table space type and your options for deploying DB2 table spaces. First of two parts.

dbazine.com, March 2003.

What does that message mean? Is there more information than the terse

pseudo-sentence that sometimes accompanies the message? How can I interpret

this string of characters and numbers? Here's information on what you'll

need to know about error messages to be an effective DBA or SQL developer.

The fourth installment in this series discusses the different types of DBAs - from application DBA to data modeler to database architect and more.

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

This installment of The DBA Corner focuses on the rising complexity of Database Management Systems and how that impacts DBAs. 

The third installment in this series offers a quick overview of common DBA tasks.

This installment of The DBA Corner focuses on how DBAs need to understand storage technology and sometimes take on the role of Storage Administrator in addition to Database Administrator. 

Tuning DB2 Access Paths.
DB2 Developer Domain, January 2003.

The second installment in this series examining the roles and responsibilities of the database administrator discusses the roles of the DA, DBA, and SA including how they overlap, how they differ, and how they complement each other.  

This installment of The DBA Corner focuses on the changes in roles and responsibilities of the DBA as applications become Internet-enabled.

DB2 Everyplace: A Mobile DB2.
DB2 Update, December 2002.

IBM offers a version of DB2 that is small enough to run on handheld devices called DB2 Everyplace. DB2 Everyplace enables the mobile work force to unplug—but still tune in. This article discusses the features and functionality of DB2 Everyplace.

DB2 and the Procedural DBA, Part 1  Part 2.
Mainframe Week, November 2002.

As DB2 applications mature, more application code is being stored in the database in the form of stored procedures, triggers, and user-defined functions. A proper methodology for handling these server code objects must be established to effectively administer application code that is stored in the database. This article discusses these new code-based objects from a DB2 for OS/390 perspective and suggests a useful re-definition of the role of a DBA in this changing environment.

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

Handling performance problems is an enterprise-wide endeavor; however, the task of enterprise performance management frequently becomes the job of the DBA group. Let's face it, many performance problems are first blamed on the DBMS. This article examines the topic of database performance.

eDBA: Database Disaster Planning and the eDBA.
dbazine.com, November 2002.

The eleventh installment of the eDBA series examines the ever-problematic topic of contingency planning and how to manage database disaster recovery.

The first installment in a series that examines the roles and responsibilities of the database administrator.  

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

Part 3 of a three part series on optimizing database performance. This article is excerpted from Craig Mullins' new book Database administration: The complete guide to practices and procedures. The first and second parts of this series are also available.

Optimizing database performance, part 2: Denormalization and clustering.
searchSQLServer.com, 16 October 2002

Part 2 of a three part series on optimizing database performance. This article is excerpted from Craig Mullins' new book Database administration: The complete guide to practices and procedures. The first and third parts of this series are also available.

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

Part 1 of a three part series on optimizing database performance. This article is excerpted from Craig Mullins' new book Database administration: The complete guide to practices and procedures. The second and third parts of this series are also available.

Coding DB2 SQL for Performance: The Basics.
DB2 Developer Domain, October 2002.

Poorly coded SQL and application code can cause performance problems. This article is intended to give the basics of good SQL programming to application developers, particularly for, but not limited to, those who are using Borland Kylix and Delphi RAD tools.

The Database Report: 3Q2002.
The Data Administration Newsletter, October 2002.

Another installment of the regular TDAN column covering the activities of the major DBMS players in the market. This edition focuses on Oracle and IBM's introduction of DB2 Version 8.

Q&As on DB2 Dates.
dbazine.com, October 2002.

The ability to store dates as a native DB2 data type is a great advantage. But proper usage of dates in DB2 is not universally understood. This article sheds some light on the topic in the form a questions and answers.

Optimize Your Database Performance: The DBA Corner
Database Trends and Applications, October 2002.

Handling performance problems is an enterprise-wide endeavor; however, the task of enterprise performance management frequently becomes the job of the DBA group. Let's face it, many performance problems are first blamed on the DBMS. This article examines the topic of database performance.

Getting Down to Data Basics.
The Data Administration Newsletter, October 2002.

Some daring young enterprises embark on Web-enabled database implementation with nothing more than a bevy of application developers. This approach is sure to fail. If you take nothing else away from this article by Craig Mullins, make sure you understand this: every organization that manages data using a database management system (DBMS) requires a database administration group to ensure the effective use and deployment of the company's databases.

Reorganizing the DB2 Catalog and Directory, Part 1  Part 2  Part 3.
Mainframe Week, October 2002

Since DB2 V4 it has been possible to reorganize the DB2 Catalog and DB2 Directory using the native IBM REORG utility. This article describes how to reorganize the DB2 catalog and provides some implementation tips and advice.

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

This article is an excerpt from my book, Database Administration: The Complete Guide to Practices and Procedures.  It provides a nice introduction to the management discipline of database administration and is useful for DBAs, DBA managers, and anyone who has to interact with DBAs. After reading this article folks should gain a better appreciation for what a DBA does all day long.

The Changing Face of the Database.
eServer Magazine (Mainframe Edition), September 2002.

Database management systems (DBMSs) are the heart of the modern IT infrastructure. Modern database systems, however, are becoming increasingly large and complex. This article looks at the changing trends for database management systems including Internet enabling databases, management and administration issues, and incorporating procedural logic into the DBMS.  

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

A day in the life of a DBA is usually quite hectic... and to add to the chaos, DBAs are expected to know everything about everything. This article discusses how DBAs can focus on  P.A.R. (Performance, Administration, and Recovery) to institute a proactive approach to database administration.

DB2 User-Defined Functions.
dbazine.com, August 2002.

As of DB2 Version 6, it is possible to create user-defined functions to supplement the built-in function supplied with DB2. This article provides an introduction to UDFs and discusses their usage.

DBA Certification: The DBA Corner.
Database Trends and Applications, August 2002.

Professional certification is a recent trend in IT and is available for many different IT jobs. Certifications programs are available for most of the popular DBMS platforms today. This article discusses the trend and offers guidance on certification for database administrators.

Temporary Tables -- Declared and Created.
DB2 Update, August 2002.

As of V5, DB2 enables developers to create and utilize temporary tables. But why are they needed? And how are temporary tables supported in DB2 for OS/390? This article examines these issues.

Craig Mullins Answers Your Database Administration Questions.
searchdatabase.com, August 2002.

This Q&A session is from a web seminar Craig conducted on searchdatabase.com on the topic of Introduction to Database Administration, (or DBA 101).  You can watch this web seminar now by clicking here.

Using TIMESTAMP Columns versus DATE and TIME Columns, Part 1 and Part 2.
Mainframe Week, August 2002.

This two-part article examines the pros and cons of using a TIMESTAMP column versus using DATE and TIME columns to store date and time information in a DB2 table.

Managing the Performance of DB2 for OS/390 and z/OS.
IT Tool Box, July 2002.

This article examines DB2 performance tuning from three different aspects: the system, the database and the application. It provides general guidance on tuning in each of the areas and then discusses how BMC Software's performance solutions can be used to deliver optimal performance.

DB2 Data Type Usage Tips.
dbazine.com, July 2002.

Data type and length are the most fundamental integrity constraints applied to data in a database. This article provides an introduction to data type and length choices and discusses the ramifications of several different DB2 data type scenarios.

The Database Report: 2Q2002.
The Data Administration Newsletter, July 2002.

Latest installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses primarily on the recent DBMS vendor rankings from Gartner and IDC (as well as the highlights of Oracle's antics in the second quarter).

Database Design -- From Logical to Physical: The DBA Corner.
Database Trends and Applications, July 2002.

Database design is the process of transforming a logical data model into an actual physical database. Assuming that the logical data model is complete, though, what must be done to implement a physical database? This article briefly discusses an approach to transforming logical models to physical databases.

DB2 Performance Traces.
dbazine.com, June 2002.

This article, excerpted from Craig's book, DB2 Developer's Guide, provides an introduction to DB2 performance traces.

DBMS Architecture: The DBA Corner.
Database Trends and Applications, June 2002.

Choosing a DBMS is not as simple as you might expect. There are different types of DBMS each with different architectures and purposes. This article discusses the impact of architecture on the DBMS decision.

A DB2 for z/OS Performance Road Map.
dbazine.com, May 2002.

A database application, at its core, requires three components in order to operate: the system, the database and the application. To deliver performance, the DBA must be able to monitor and tune each of these components. This article provides a performance road map to mainframe DB2 based on these three components.  

How Much Availability is Enough?: The DBA Corner.
Database Trends and Applications, May 2002.

In this Internet age the push to provide never-ending uptime continues unabated. Pushed to the ultimate everyone would request -- an entire year of uptime -- 365 days a year 24 hours a day. Clearly it is a laudable goal to achieve 100% availability, but just as clearly it is unreasonable to assume that 100% availability can be achieved. This article discusses a reasonable approach to data availability requirements.

eDBA: Online Database Reorganization.
dbazine.com, May 2002.

The tenth installment of the eDBA series examines the impact of reorganization on availability and the growing trend of reorganizing databases while they remain online.

The 'Top Ten' Problem.
DB2 Update, May 2002.

A common application development problem is the need to retrieve a limited number of qualifying rows from a database. For example, maybe you need to list just the top ten best selling items from inventory, or a list of the ten employees with the highest salary. This article discusses several ways to accomplish this using DB2.

A DB2 for z/OS Performance Road Map.
eServer Magazine (Mainframe Edition), April 2002.

The Database Report: 1Q2002.
The Data Administration Newsletter, April 2002.

Latest installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses primarily on Oracle, including coverage of their security, financials for their fiscal third quarter, pricing flare-ups, and other goings on.

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

If your company uses a database management system (DBMS) then you most likely have a database administration group. But what is a DBA and why are they needed? This article discusses how DBAs are required in order to ensure effective database usage.

Using Templates and Lists in DB2 Utilities.
DB2 Update, April 2002.

As of DB2 V7, IBM offers more functionality in their basic utilities. This article examines how to use templates and lists to enable utilities to operate on groups of DB2 objects. 

A View to a Kill.
dbazine.com, March 2002.

An adaptation of a presentation that discusses the lack of merit in creating base table views.

Select Database Utilities With Care: The DBA Corner.
Database Trends and Applications, March 2002.

Issuing SQL Statements in DB2 Utilities.
DB2 Update, March 2002.

This short article discusses the EXEC SQL utility control statement. EXEC SQL was added to Version 7 of DB2 for OS/390 to allow SQL statements to be issued in conjunction with DB2 utilities. 

eDBA: Intelligent Automation of DBA Tasks.
dbazine.com, February 2002.

The ninth installment of the on-going eDBA series discusses how intelligent automation of DBA tasks can optimize performance and minimize the DBA's growing workload.

Forty Tips in 60 Minutes.
dbazine.com, February 2002.

Forty quick tips on administration and performance aspects of DB2 for OS/390. Adapted from a 1999 IDUG presentation.

An Introduction to Triggers in DB2 for OS/390.
dbazine.com, February 2002.

A quick introduction to the features and functionality of triggers available to mainframe DB2 databases and applications.

DRDA.
dbazine.com, February 2002.

A short introduction to IBM's Distributed Relational Database Architecture (DRDA). Adapted from my book, DB2 Developer's Guide.

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

Measuring the performance of IT professionals can be a difficult proposition. This DBA Corner column looks at several different ways of measuring the effectiveness of DBAs.

Architectures for Clustering: Shared Nothing and Shared Disk.
DB2 Magazine, 1Q2002.

Clustering can bring extra computing power and improved availability. Choosing the architecture that makes sense with your hardware and software makes all the difference. This article discusses the predominant clustering architectures as well as an overview of how they are deployed for the various DB2 platforms.

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

This installment of The DBA Corner focuses on the issues, concerns, and techniques DBAs can use to achieve high database availability.

Database Fragmentation and Disorganization: The DBA Corner.
Database Trends and Applications, December 2001.

This installment of The DBA Corner focuses on the reasons databases need to be reorganized, and how reorganization can be performed.

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

It is imperative that the DBA group is prepared to continue business operations in the event of a disaster. This installment of The DBA Corner discusses aspects of planning for database disaster recovery.

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

The final installment of this three part article covering the changing role of the DBA discusses the growing size of databases, PDA database management, heterogeneity, and rapidly change DBMS software. Each is examined for its impact on corporate DBAs and intelligent automation is presented as a useful solution to database systems management issues and problems.   Part 2    Part 1

Fourth installment of my regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on the events of July 2001 through September 2001, and includes a special focus on the open source DBMS market.

Dissecting Database Performance: The DBA Corner.
Database Trends and Applications, October 2001.

This installment of The DBA Corner focuses on database performance, breaking the discussion down into three components that must be monitored and tuned to optimize database systems: the DBMS/system, the database, and the application.

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

The second part of this three part article discussing the changing role of the DBA covers the management and administration of procedural database objects such as triggers, stored procedures, and user-defined functions.

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

This first part of a three part article discussing the changes in database administration covers the role of the DBA as databases are hooked up to the Internet.

An Overview of DB2 for OS/390, Version 7.
dbazine.com, August 2001.

IBM released Version 7 of their mainframe DB2 DBMS in late March 2001. This overview examines the new features and functionality available in DB2 V7.

This installment of the on-going eDBA series provides an exploration of e-business's impact on the design process and a discussion of the basics of assuring proper database design.

This article exposes some of the vast sources of information on DBMS software and database administration that are available online.

Relational databases perform better when sufficient computer memory is allocated for their use. This article discusses the four types of memory structures used by DB2 for OS/390 and discusses a solution for intelligently managing memory for DB2's usage.

Throughout the years marketers have proclaimed that many new technologies or techniques will make data somehow irrelevant. This article discusses this odd behavior and tries to explain why data will never become obsolete.

The Database Report: 1Q2001.
The Data Administration Newsletter, April 2001.

Second installation of a regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses primarily on the activities of Oracle, IBM, Microsoft, and Sybase during the first quarter of 2001.

High Speed Transaction Recovery.
Storage, Inc., Q1 2001

As the demand for 24x7 processing increases, DBAs are looking for ways to perform database maintenance tasks with minimal or not outages. This article discusses high availability database recovery techniques to meet this demand head on. 

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

This article discusses database recovery within an e-businesses context. What approaches are available to reduce or perhaps eliminate outages when databases must be recovered.

IT's a Crazy World.
Database Trends, March 2001.

The world of Information Technology (IT) never ceases to amaze. There's always something new and often times some crazy things are passed off as logical and considered common knowledge. This article takes a second look at some misconceptions held within the IT community.

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

For e-businesses new to database design and administration, this article will serve as a primer on implementing DBA services.

LOB Columns vs. VARCHAR and VARGRAPHIC.
Revealnet Pipeline Newsletter, December 2000

A quick review and comparison of new (V6) LOB columns versus DB2's older data types for storing large character (VARCHAR) and graphic (VARGRAPHIC) data.

DB2 User Defined Functions.
Revealnet Pipeline Newsletter, July 2000

A basic introduction to the capabilities and implementation of user-defined functions (UDFs) in DB2 for OS/390 Version 6.

DB2 Triggers.
Revealnet Pipeline Newsletter, March 2000

A basic introduction to the capabilities and implementation of triggers in DB2 for OS/390 Version 6.