A Deep Dive in SQL Server 2012 Data Warehousing

In SQL Server 2012, we get strong support for data warehousing (DW). From previous versions we know there has been a lot of effort put in DW enhancements: star join optimization through bitmap filters, known from SQL Server 2008, table partitioning and basic window functions known from SQL Server 2005, indexed views, known from SQL Server 2000, and more. In SQL Server 2012, we get advanced window functions. Besides that, we get columnstore indexes. Columnstore indexes use the VertiPaq engine, storage engine developed by the SQL Server Analysis Services (SSAS) team. In this session, we are going to introduce these features and show how they can be useful in a data warehousing scenario. We are also going to explain the theoretical background for these features.
Presented by Dejan Sarka at SQLBits X
  • Downloads
  • SpeakerBIO

    Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database & business intelligence applications.  Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of thirteen books about databases and SQL Server. Dejan Sarka also developed many courses and seminars for Microsoft, SolidQ and Pluralsight.

    http://sqlblog.com/blogs/dejan_sarka/default.aspx http://sqlblog.com/blogs/dejan_sarka/rss.aspx
  • Video