SSAS Tabular – Fact Table Key Columns Datatype Impact

Intro
I’m working on a solution where warehouse uses string codes as the keys for dimensions. Therefore the fact table is...

DAX IF & Switch Statement Performance – Does Order Matter?

Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...

SSAS Tabular – Large Dimension Performance II

What are the limits?

What are the limits?
Of course, as a follow-up to my last article you might ask at least...

SSIS script task successfully executed. Or not?

Issue
Recently we came across an interesting issue. I guess this will not happen often, but I think it’s worth mentioning...