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
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
Sometimes the data is not what you want it to be. Or rather the quality is not what you want it to be. What I am referring to in this case is when you have a primary key and you… Continue Reading