A Sample DBA Job Posting
The job of a Database Administrator, or DBA, is constantly changing and adapting to the technologies used to manage data…
Data Articles
The Case Against Slowly Changing Dimensions, Part Two
In Part 1, I showed that SCDs inadequately live up to their stated purpose. They are intended to provide history…
Why You Should Care About Data Governance
Does your company have a formal agenda to govern your data as a strategic asset? Does somebody in your organization…
Developing a Return on Investment
This article addresses the concept of developing a Return on Investment (ROI). It does so by first defining the ROI…
Back to the Future
While I was presenting recently at a seminar called “Data, the vital organization enabler,” I hosted a session…
Service Level Requirements (SLR) as the Origin of the SLA Content
You have a customer with a signed Service Level Agreement (SLA) and a good relationship with them. This is a…
Data Modeling is Data Governance
The name of this article is the name of a Real-World Data Governance webinar that I will be giving in…
Social Media and “The Right to Be Forgotten”
Do you want all of your personal information to be available to whomever wants to search on Google, Facebook, LinkedIn…
The Case Against Slowly-Changing Dimensions, Part One
I believe that Ralph Kimball’s fact-dimension pattern is one of the most important and powerful data design patterns ever discovered.…
The Meta-Data Fiasco
The terms meta-data and metadata have been used, misused, and abused to the point that the real meaning is totally…