Category Archives : BI


Exam Prep 70-463: Installing Master Data Services

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly Changing Dimensions Fact tables and measures Intro to columnstore indexes Columnstore indexes and partitioning […]


Exam Prep 70-463: Introduction to Master Data

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly Changing Dimensions Fact tables and measures Intro to columnstore indexes Columnstore indexes and partitioning […]


Exam Prep 70-463: Executing packages in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly Changing Dimensions Fact tables and measures Intro to columnstore indexes Columnstore indexes and partitioning […]

Executing a package using SSMS

Sad trombone

Exam Prep 70-463: Deploying projects in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly Changing Dimensions Fact tables and measures Intro to columnstore indexes Columnstore indexes and partitioning […]


Exam Prep 70-463: Logging in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly Changing Dimensions Fact tables and measures Intro to columnstore indexes Columnstore indexes and partitioning […]