Category Archives: data integrity

Diminishing Downtime

Posted on July 16, 2012 by

One of the on-going goals of database administration is to minimize downtime and improve availability. If the DBMS is down, data cannot be accessed. If the data is not available, applications cannot run. And if your applications cannot run, your … Continue reading →

Posted in availability, change management, data integrity, DBA | 2 Comments

An Introduction to Database Design: From Logical to Physical

Posted on November 19, 2011 by

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 modeling effort requires a formal approach to the discovery and identification of … Continue reading →

Posted in data integrity, data modeling, DBA | 9 Comments

Sample DBA Job Posting/Responsibilities

Posted on January 12, 2011 by

I decided to post a sample DBA job posting today. Is this the way you view the role of DBA today? Is this what DBAs do at your site? Anything missing? Would you apply for this job? Respond with comments … Continue reading →

Posted in data integrity, DBA | 9 Comments

Tools to Facilitate Efficient Data Management

Posted on October 13, 2010 by

DBMS software enables end users or application programmers to share data. It provides a systematic method of creating, updating, retrieving and storing information in a database. DBMSs also are generally responsible for data integrity, data access control, and automated rollback, … Continue reading →

Posted in data integrity, DBA, performance, tools | 1 Comment

The Impact of Isolation Level on Locking

Posted on June 8, 2010 by

Choosing the appropriate isolation level will ensure that you enforce the amount of data integrity that is right for your particular application’s needs. Continue reading →

Posted in data integrity, Isolation Level | 5 Comments

Bad Database Standards, Part 4

Posted on May 13, 2010 by

…we need to create standards that control, prohibit, and limit the mass duplication of data… Continue reading →

Posted in data integrity, standards | 3 Comments