Level: Introductory to Intermediate
Microsoft SQL Server MVP
SQL Server 2014 Enterprise contains two powerful features that can significantly enhancement performance in Data Warehousing systems: the Columnstore index and In-Memory optimized tables. In this presentation, I'll cover these 2 features, their benefits and limitations as I walk through an actual Data warehouse implementation. We'll also look at some common patterns in the Kimball Data Warehouse methodology (slowly changing dimensions, fact table loading, etc.) and how to implement them. If you are looking to start a data warehouse project with SQL Server 2014 Enterprise, this session is for you!
You will learn:
- How Columnstore indexes can provide significant performance gains
- How In-Memory optimized tables can provide significant performance gains
- Common Data Warehouse patterns and how to implement them using SQL Server