Monthly Archives: April 2014

Surrogate Keys or Natural Keys?

If you’ve worked with relational database systems for any length of time you’ve probably participated in a discussion (argument?) about the topic of today’s blog post… surrogate keys. A great debate rages within the realm of database development about the use … Continue reading

Posted in data, data modeling, Data Quality, database design | 7 Comments

The Problem with Prediction

Predicting the future is a messy business. I try to avoid making predictions about the future of technology for many reasons. First off, nobody can see into the future, no matter what some fortune tellers say. Secondly, technology changes quickly … Continue reading

Posted in books | 5 Comments

The Ethical DBA?

Today’s posting is a re-blog of a post I wrote several years ago for another blog (that has since been discontinued). But I think the subject matter is important enough that it warrants re-blogging… So I touched it up and … Continue reading

Posted in DBA | Tagged | 1 Comment

Ten Steps to Minimize Data Risk During an Acquisition

Merger and acquisition activity continues to be a constant in today’s fast-paced, ever-changing world… and those of us who work in the field of IT and data management are likely to be involved in an acquisition, perhaps multiple times during … Continue reading

Posted in auditing, backup & recovery, compliance, data, data availability | 1 Comment