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
One typical data warehouse or BI problem is keeping the code dynamic and consistent over multiple environments. Say that you have a BI solution and in said solution you have two databases, Stage and DataModel. Every day you truncate and… 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
Today there will be a short post of a semi useful query for you who want to monitor your Agent jobs without looking into the standard reports.