Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]
2022-10-24 (first published: 2019-07-10)
5,520 reads
In the ninth level of this stairway, learn how to add security to the tabular model.
2022-06-22 (first published: 2020-03-11)
8,196 reads
In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.
2021-10-06 (first published: 2018-07-11)
19,612 reads
2020-10-28 (first published: 2020-10-14)
5,547 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
5,203 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
14,961 reads
The recent blog post on PASS.org announces that Microsoft has renewed its sponsorship of SQLSaturday events. They are even, at the own discretion, sponsor individual events with more money...
2019-08-03
20 reads
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2019-05-01
4,459 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
168 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
28 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers