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…
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…
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…