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


August 22, 2012

Windows Azure Virtual Machine Endpoints

Prior to June Windows Azure had been strictly a Platform-as-a-Service, or PaaS, environment which presented numerous challenges to those interested in running their existing applications in Microsoft’s data centers. In working with a number of clients I often found that the effort and cost required to make existing applications capable… Read More


August 21, 2012

Windows Azure Lessons Learned – Running Multiple Web Sites

Having worked with the Windows Azure Platform since 2008 it’s easy to forget some of the initial hurdles I ran into and assume that others won’t have the same challenges. Of course, any time you assume anything you risk being wrong. Rather than assume you won’t run into the issues… Read More


August 20, 2012

Making Your Windows Azure SQL Database Even More Secure

The only secure computer is one that’s unplugged, locked in a safe, and buried 20 feet under the ground in a secret location… and I’m not event too sure about that one. – Dennis Huges, FBI The only truly secure system is one that is powered off, cast in a… Read More