Inside the VertiPaq Engine

Dive deep into the VertiPaq engine's architecture and functionality in this comprehensive 1-hour 10-minute conference talk from PASS Data Community Summit. Explore the columnar database used by SQL Server Analysis Services Tabular, Power BI, and Power Pivot, known for its impressive performance in speed and compression. Discover how VertiPaq stores information, gaining valuable insights into its inner workings and learning optimal data warehouse modeling techniques. Examine common and effective methods to enhance compression ratios and boost performance in Tabular data models. Cover topics such as row and column storage layouts, querying techniques, value encoding, hash encoding, Run Length Encoding (RLE), segmentation, processing phases, calculated columns and tables, query parallelization, hierarchies, memory usage, and materialization strategies.