Data Warehousing and Dimensional Modeling

Data Warehouse Fundamentals and

Kimball Group

Data Warehouse Toolkit Collection

Best Practices for Data Warehousing with SQL Server 2008

Data Warehouse Maturity Level http://sharepoint/sites/bpdcxstg/SQLCAT/Documents/Tier%201%20DW%20Toolbox/Data%20Warehouse%20Maturity%20Model.pptx


Data Loading Performance Guide: This guide covers bulk loading design patterns and best practices. It also talks about how the TPCH ETL World Record was achieved. A MUST READ for every Microsoft data warehouse ETL developer.

Data Quality Services and Master Data Management

Microsoft Master Data Management

Check out all the good free videos on the upcoming SQL Server brand new Data Quality Services features to learn both the “What and How” of this addition to SQL Server.

SQL Server 2008R2 Data Quality and Master Data Management: free ebook from Solid Quality Mentors at


There are multiple ways to manage Microsoft BI metadata, impact analysis, dependency analysis and lineage. A current option fan favorite is the low cost BI Documenter by Pragmatic Works: BI Documenter works with the full BI stack – database, SSIS, SSAS, SSRS – with versions 2005 and up. It has many nice features such as a metadata editor, object change compare viewer, dependency graphing, workflow and totally automated solution documentation.

Another current option is the Microsoft Metadata 2008 Toolkit at The metadata toolkit tracks data lineage, technical metadata, and performs impact analysis for SSIS, SSAS, SSRS, and SQL. Features include:

-Database Repository to store the metadata

-Stand-alone Dependency Analyzer program to view dependencies

-Report model for ad hoc reporting on technical metadata.

-Reports on impact analysis, dependency analysis, lineage

Additional Metadata Management Resources

SQL Server Metadata Toolkit

Managing Metadata in SQL Server