Interesting article about the upcoming Data Quality Services feature in Denali. It’s worth mentioning, as it’s very similar to the Data Quality Control system that I developed (with a little inspiration from my friend) for our current data mart.
In short, what I do is run a series of data quality tests on the data every time it loads. These can then be flagged for follow-up by end-users, thus increasing the overall quality of the data in the data mart.
While the feature-set is not nearly as complete as the Microsoft version, it’s fun seeing something you worked on reflected in Sql Server.