The Top Four Must-do’s for Measuring the Success of Your Digital Projects

“Tell me about a successful project you’ve run.” “Tell me about a project you’ve been a part of that was not successful. What happened?” These are two very subjective questions that a Digital Project Manager may hear as part of a job interview or that a sales team may...

[Tutorial] 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.  In this post, I will...

[Tutorial] 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...