-
The VertiPaq engine used by SQL Server Analysis Services Tabular, Power BI, and Power Pivot, is a columnar database capable of incredible performances, both in speed and compression. In this session, we perform a deep dive into the database architecture… Watch now
-
In this session recorded at SqlBits 2022, Marco Russo introduces VertiPaq Analyzer features in DAX Studio and the VertiPaq Analyzer library available in other tools. Watch now
-
Explore the meaning of the VertiPaq Analyzer metrics provided in DAX Studio. Watch now
-
VertiPaq Analyzer provides information about storage structures for a data model in Power BI and Analysis Services. It is fully integrated into the Metrics feature of DAX Studio. Watch now
-
How does the VertiPaq storage engine communicate with the formula engine when executing a DAX query? Watch now
-
SSAS Tabular Video Course
Introduction to Analysis Services: What is Analysis Services?
…the Vertipaq in-memory engine that we will see in a moment. And… Watch now
-
SSAS Tabular Video Course
Introduction to Analysis Services: SSAS Architecture
…”xVelocity”, but now we use the term “VertiPaq” that we will describe later. VertiPaq […] same VertiPaq in-memory column store engine, and the DAX… Watch now
-
SSAS Tabular Video Course
VertiPaq Internals: Segmentation
…of indexes to the dictionary, then VertiPaq can […] presence of data in different segments enables the VertiPaq engine to scan the […] the data in memory in the VertiPaq engine. Now what is the size of one… Watch now
-
SSAS Tabular Video Course
VertiPaq Internals: Segment Configuration
…introduction to the VertiPaq engine. So the VertiPaq engine […] segment size. Unfortunately this setting “VertiPaq\DefaultSegment […] we will see in VertiPaq Analyzer later, we might check… Watch now
-
video course
VertiPaq storage engine: VertiPaq compression
…so important to speak about compression when we speak about the VertiPaq […] So the compression in VertiPaq comes from Dictionary encoding…. Watch now
