-
Many people are looking for books about Analysis Services Tabular. Today there are two books available and they complement each other: Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model by Marco Russo, Alberto Ferrari and Chris Webb Applied… Read more
-
A data model for DAX has three numeric data types: integer, floating point, and fixed decimal number. This article describes them and explains why the fixed decimal number should be used instead of the floating point in most scenarios. Read more
-
After many conferences and travels, this summer I had some time to write and prepare new sessions for the next wave of conferences. In reality I am just doing that, even if I already restarted traveling for consulting and training.… Read more
-
SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. I think that also Microsoft does not know (and cannot know) the exact number of users. For this… Read more
-
The second year of the pandemic is coming to a close and despite the many uncertainties, we are all striving to push forward and look ahead. For sure, it is a good moment to see what happened in the DAX… Read more
-
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
-
The default memory settings for Analysis Services Tabular might be less than optimal. This article describes why this might happen, and guides you choosing the right configuration. Read more
-
Hardware and virtualization settings have a big impact on Analysis Services Tabular performance. This article describes best practices for the most important settings to check. Read more
-
The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and… Read more
-
If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models. This is the simplest way… Read more