Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.  Read more...

The other day at a conference, the subject of data degradation/corrosion arose. The speaker at the conference said that data in a database degraded or corroded over time. The statement was made as if degradation over time applied to all databases. I found this blanket statement to be misguided. Indeed, I think that data does degrade in some databases, but not all.   Read more...

The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.  Read more...

The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.  Read more...

The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.  Read more...

The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.  Read more...

Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)  Read more...

Got a new database you know nothing about? Here's my basic proposal on how to find interesting tables in it.  Read more...

David Loshin describes the benefits of the combination of the bottom-up aspects of data profiling with a top-down analysis phase for establishing criteria for data quality management.   Read more...

Find available keys when merging two tables with duplicate keys.  Read more...

Enhanced model performance comes from extracting as much information content as possible… relative to the specific performance metrics you are using to measure success.  Read more...

This article outlines 15 principles of ROI development for data quality (DQ) projects that can be leveraged across any industry.  Read more...