BI

So this week I thought we should have a look at one of the many ways to build a date dimension. With that said I want to stress that most of this is borrowed/stolen from the great mssqltips. The changes… Continue Reading →

For me, working mainly with BI, the MERGE operator is by far one of the most useful ones. Since a lot of the work in a data warehouse is to store data in a structured and organized way the MERGE… Continue Reading →