Monthly Archives: December 2014


Exam Prep 70-463: SSIS Connection Managers

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 […]


Tookbox context

Exam Prep 70-463: Introduction to SSDT

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: Columnstore Indexes and Partitioning

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 Today we’re continuing the […]

Partitioning - after switch