Yearly Archives: 2014

Exam Prep 70-463: SSIS Connection Managers

This entry was posted in BI and tagged connection managers exam prep SQL Server SSIS on by

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 SSDT

This entry was posted in BI and tagged exam prep SQL Server on by

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 entry was posted in BI and tagged 70-463 exam prep SQL Server on by

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

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

This entry was posted in BI and tagged 70-463 exam prep SQL Server on by

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