white paper

SSAS Tabular as Analytical Engine

This article describes the pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it.  Read more

white paper

Understanding DAX Query Plans

Understanding DAX query plans is a long process. This paper explains how to capture and read a DAX query plan, helping you to find possible optimizations of your DAX queries.  Read more

white paper

The Many-to-Many Revolution

This white paper explores many different uses of many-to-many relationships in both SQL Server Analysis Services Multidimensional and Tabular models.  Read more

This white paper describes how to use and optimizing DirectQuery with Analysis Services Tabular.  Read more

white paper

Understanding Distinct Count in DAX Query Plans

Distinct Count calculations in DAX are very fast compared to other engines. But when you have a large number of values, performance might be different depending on the query you write.  Read more

white paper

VertiPaq vs ColumnStore Comparison

SQL 2012 gives you two different xVelocity engines, with different capabilities and different scenarios of implementation, the paper will help you choose the right one or, at least, raise your curiosity about performing more tests on your specific scenario.  Read more