The reality of today’s Business Intelligence solutions is that on-going integration Total Cost of Ownership (TCO) is often 3-10x the cost of the original implementation. This is due to a combination of factors including: data quality issues, the lack of a master data foundation and worst practices when implementing data integration solutions. The day to day costs of supporting sub-optimal data integration solutions often result in less resources for strategic initiatives and ultimately employee burnout.

This first part of this session reviews Data integration today, common worst practices and how to replace them with best practices. The remainder focuses on how to combine best practices with the Master Data Services and Data Quality Services components of SQL Server 2012 to produce data integration solutions that minimize on-going TCO.

Larry Barnes is a Principal Architect with BlueMetal Architects and has been working with SQL Server since it first shipped in 1989. Larry is well known within the Microsoft BI community, has deep expertise across the entire Microsoft BI stack, with a particular focus on Data Integration. His ETL Framework (etlframework.codeplex.com) has been well received by the user community.


About Larry Barnes

Larry has been a developer, architect, consultant, trainer, author, practice director and fellow during his 30+ years in the industry. Larry joined Microsoft in 1995 to focus on Business Intelligence and Data Warehouse solutions that leverage the Microsoft platform. During this period he co-founded the popular “Bob and Larry” Developer Workshops. Larry joined Avanade in 2000 and founded Avanade’s global BI practice. Larry retired from Avanade in 2006 as their BI Fellow.

Larry has also been very active as an author and presenter and has published multiple books and articles on SQL Server; most recently as the lead author on Microsoft EDW Architecture, Guidance and Deployment Best Practices. Larry has presented at many Microsoft conferences including PDC and Tech-Ed. Larry has been involved in databases and data integration for decades and was also a founding member of the ODBC standard’s committee.