Even with the introduction of big data and streaming data systems, the traditional star schema used in many data warehouses still has plenty to offer. In this talk we will look at some design patterns, tips and tricks to make loading and querying your data simpler, faster, and more reliable.

In this demo heavy presentation we will look at:
  • Using durable keys to simplify slowly changing dimension implementation where both historical and current context is required
  • Using inferred members when loading fact tables for increased resiliency
  • Where to use Columnstore indexes
  • Making sure statistics are up to date for better query performance
  • Design patterns for making SSIS more resilient to bad data
(no tags)
The video is not available to view online.