Businesses large and small trust RBA’s experience and expertise to create, optimize and manage infrastructure solutions that fits the unique demands of their business today and keep pace with their changing needs.


March 7, 2016

Moving to the Cloud: Debunking the Illusion of Risk

William_blog_title

Even with all of the information available today about the “Cloud,” many companies still fear migrating their mission-critical applications to the Cloud, or deploying new ones to the Cloud. In this article, we challenge three common areas of concern. Physical Access is Critical In traditional “on-premises” environments, software generally runs on a… Read More


November 2, 2015

SQL Server 2005 End of Support: Now What?

SQL Server 2005 End of Support-02

On April 12, 2016 Microsoft will end extended support for SQL Server 2005.  This means no more bug fixes, no patches and no support. On April 13, CIO’s everywhere will come to their DBA’s desk, eyes bulging in panic, when they realize this lack of support puts them out of… Read More


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


June 2, 2014

[Tutorial] A Few Thoughts on PowerBI

I recently had an opportunity to present at a Microsoft technology roadmap event here in the Denver area on PowerBI.  In preparing for this presentation I had to take a stroll down memory lane… well more like a memory dark alley where monsters I’d rather forget are still lurking. Back… Read More