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
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.
Hi all! This week we will have a look at an easy and convenient way to get around those situations when you have been a good developer and used you constraints. (As you should.) However, for some reason you need… Continue Reading
So this is my first post in a while so I though we could look at two useful SSMS customizations that I use somewhere around 20-150 times each day. (Yes, those figures are directly correlated to the length of my… Continue Reading