October 27, 2014

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 2

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 2-01

  In part 1 of this article, I outlined how a data steward – a person who is responsible for data quality and typically not on the IT staff – would create a collection of rules that can be used to automate data cleansing and address verification http://blog.rbaconsulting.com/automating-data-cleaning-and-validation-with-dqs-and-ssis-part-1/ .  In… Read More


October 21, 2014

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 1

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 1-01

Automating Data Cleaning and Validation with DQS and SSIS, Part 1   I have been doing some work with SQL Server Data Quality Services (DQS) in preparation for SQL Saturday in Salt Lake City (https://www.sqlsaturday.com/349/eventhome.aspx ).  Part of my code demo involves validating addresses using MelissaData Address Check.  Address data… Read More


October 16, 2014

Mobile Moments at MIMA Summit 2014

Mobile Moments at MIMA Summit 2014-01

I attended the MIMA Summit this week in Minneapolis.  It was an energizing day of sessions and keynotes by a who’s who of the digital space today. One thread that seemed to permeate the talks was the concept of “moments.” Moments are those opportunities when you have the user’s attention. … Read More