The in-memory chapters mission is to enable the SQL server community to take full advantage of the new in-memory features.
Next Meeting

Tue, Aug 18 2015 16:00 UTC


Inside xVelocity in-memory engine (VertiPaq) for Power Pivot, Power BI and Analysis Services Tabular

RSVP: https://attendee.gotowebinar.com/register/7301440373130769154

Inside xVelocity in-memory engine (VertiPaq) for Power Pivot, Power BI and Analysis Services Tabular

Power Pivot, Power BI, and SQL Server Analysis Services Tabular models are based on the xVelocity in-memory analytics engine, also known as VertiPaq. This engine is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine. We will use special tools to quickly read how data is compressed and stored in memory. At the end, You will learn common and useful techniques to increase the compression ratio and obtain better performances from your data model.


Marco is a business intelligence consultant & trainer. He has extensive experience with BI solutions & has worked with Analysis Services since 1999, & Power Pivot since its beta release in 2010. He has written many white papers about the usage of Microsoft BI technologies. He has authored "Microsoft Excel 2013: Building Data Models with PowerPivot," "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model," "Expert Cube Development with SSAS Multidimensional Models," & "DAX Patterns”