Search Results for data quality

Key Change

I love music.  In fact, I like to think that I’m a student of music – although anyone who has heard me sing karaoke would agree that I’m far from having mastered it.  I’ve got a taste in music that is as diverse as anyone I know.  I enjoy tunes from multiple genres spanning decades of time, and I often…


Join me at the PASS Summit

It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting in SQL Server.  It couldn’t possible have been 8 months since we were attending after-party events together, stopping by the Tap House for a beer, or closing down Bush Gardens with some spectacular SQL Karaoke.  Yet here were are, getting…


DQS Composite Domains and Value Combinations

As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working with data domains, DQS composite domains, and rules. In that exploration, I’ve found some behavior that might not be expected when performing cleansing operations against a knowledge base containing a composite domain. In this post, I’ll outline the expected data…


DQS Validation Rules on Composite Domains

In Data Quality Services, composite domains can be created to associate together two or more natural domains within a knowledge base.  Like natural domains, composite domains can also contain one or more validation rules to govern which domain values are valid.  In my last post, I discussed the use of validation rules against natural domains.  In this post, I’ll continue…


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…


Shameless Plug: Vote For My Sessions!

Have you voted yet for my sessions your favorite sessions for SQL Rally?  If not, this is a friendly reminder to hop on over and vote now.  You have to have a PASS login to vote, but don’t worry – it’s free to get one and takes about 2 minutes. Out of the 60 total sessions to be presented at…


In 2012, It’s Me and Vanilla Ice

Like many others, I’m planning a few changes for my life for next year.  I’m a believer in finding one’s own way, while still abiding the advice of the wise.  Often called upon for inspirations are the timeless words of Confucius, the inspiring speeches of Martin Luther King, the controversial yet insightful analyses of Sigmund Freud, and the various authors…


SQL PASS Summit 2010, Keynote Day 2

The second day of the SQL PASS summit has already started in unique fashion.  Today is #sqlkilt day, and there are a dozen or more guys and gals dressed in fine Scottish attire.  Bill Graziano, executive VP of finance for PASS, was playfully booed when he took the stage for having worn pants on kilt day.  Bill took the time…


ETL Antipattern: Failure to Test and Validate

“If it compiles, it works.” – An unemployed developer Building ETL processes is quite easy. Building ETL processes that deliver accurate results as quickly as possible is substantially more difficult. Modern ETL tools (including my personal favorite, SQL Server Integration Services) make it deceptively easy to create simple load process. That’s a good thing, because an easy-to-understand front end shortens…


Personal Touch: An Argument Against Automation

At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest sushi restaurant. The exterior could be described as tasteful minimalistic: there are no big signs, no flashy advertising, and the word “fancy” would never be used to describe it. Inside, it is a small space, seemingly purposeful in its meager…