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
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.
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
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
One of the main conference themes (Transforming IT) is coming out strong at this year’s SharePoint Conference. I Just attended a great session on the Access Apps for Office 365 and SharePoint 2013. This is a game changer for many Information Workers as it provides IW’s the ability to literally… Read More
A big theme this year at #SPC14 is the Transformation of IT; we are on the cusp of another shift in IT (e.g. by 2015 35% of IT expenditures will be controlled outside of IT) and the cloud is coming (by 2020 30% of data will be in the Cloud).… Read More