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

Columnstore storage structure

Exam Prep 70-463: Intro to Columnstore Indexes

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 SQL Server 2012 introduced a new way of […]


Exam Prep 70-463: Just the facts, ma’am

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 Today we’re exploring fact tables in more depth.  If you’ll recall fact […]

The InternetSalesFact fact table in the AdventureWorksDW2012 database

The DimCustomer dimension table in AdventureWorksDW2012

Exam Prep 70-463: More about Dimensions

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 Today we’re going to review dimension tables in more depth.  As I stated last time, dimension tables […]


Exam Prep 70-463: Tables and Schemas

Well, the PASS Summit has come and gone and it was *awesome*.  What a difference from my first Summit experience, when I went to every session I could and then went back to the hotel.  This time around there was something going on every evening and I made the most of it.  I think the […]

The Snowflake schema starts to add complexity