Tim Mitchell
Follow Tim Mitchell on Twitter  Like Tim Mitchell on Facebook  Subscribe on YouTube  Connect on LinkedIn  Subscribe to the Data Geek Newsletter

Data Quality

DQS Domain Validation Rules

DQS Domain Validation Rules

A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to fields (domains) to describe what makes up a valid value.  In this brief post, I’d like to walk through the concepts of domain validation and demonstrate how this can be implemented in DQS. Domain validation essentials Let’s ponder domain validation…


No Picture

Colorado Speaking Tour

Next week, I’ll be making a swing through central Colorado on a working vacation of sorts.  I met up with Marc Beacom when I went up to Denver to speak at their SQL Saturday in September, and he mentioned that they have three user groups (Boulder, Colorado Springs, and Denver) that meet on three consecutive nights each month.  My love…


The Numbers Don’t Lie… Except When They Do

There are few things more reassuring for a data professional than having clean, consistent data to back up critical business decisions.  The numbers don’t lie, or so they say.  But can the right data lead to wrong conclusions?  Sadly, yes, and I suspect that it happens more often than we’d like to admit. Recently, as part of a large hospital…


No Picture

Slacking and data quality (in that order)

Well, I almost missed blogging for the entire month of June.  I’m sure that this fact didn’t go unnoticed by both of the people who read my blog…  I’m working on a major data conversion and am in a mad dash to finish converting and validating years of healthcare and financial data, and unfortunately my free time (including the time allocated…