October 27, 2014

Automating Data Cleaning and Validation with DQS and SSIS, Part 2

  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

Automating Data Cleaning and Validation with DQS and SSIS, Part 1

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

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


September 3, 2014

The Mobile World Is Flat…Mostly

Last week at the end of an interview, a candidate asked about my thoughts on flat design. Though unspoken, I think this question typically presumes allegiance to one of two camps. You’re either a flat person or aligned with everything else (and there’s a lot of everything else that is… Read More


August 18, 2014

Any Port Is a Storm…Potentially

If you are looking at extending an existing application to mobile or from one platform to another, you probably have a lot of competing pressures. Time and cost are high on the list and you can’t be faulted for trying to be quicker and more efficient. But there are other… Read More