Blog

Data Warehousing Tip #9 – Test at Volume

My next tip is to test your BI solution with the volume of data that you are expecting. ...
Read More

Data Warehousing Tip #8 – Make it better

In this article I’ll discuss making your data warehouse better.  I’ll admit that this is a pretty obvious...
Read More

Data Warehousing Tip #7 – How I build a time dimension

In this article I’m going to show you how I build my time dimensions.  There are lots of...
Read More

Data Warehousing Tip #6 – Use a consistent unknown member key

In this article I’ll be discussing the benefits of using a consistent unknown member key across your data...
Read More

Data Warehousing Tip #5 – Use surrogate keys

My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables. Surrogate...
Read More

Data Warehousing Tip #4 – Trust your instinct

My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if...
Read More

Data Warehousing Tip #3 – Build thin slice

My third data warehousing tip is to build thin slice.  Deliver subsets of valuable functionality. Get feedback and...
Read More

Data Warehousing Tip #2 – What your data warehouse should be

I’ve seen data warehouses that nobody trusts, or are just too complex for end users to report on. ...
Read More

Data Warehousing Tip #1 – Store fact data at the leaf level

My first data warehousing tip is to store fact data at the leaf level. If you aggregate your...
Read More

Reducing the size of the distribution database & improving transactional replication performance: Part 3

The final (and much delayed) part of this series focuses on the choice between replicating stored procedure calls...
Read More

Reducing the size of the distribution database & improving transactional replication performance: Part 1

In this series of blog posts I will looking at issues regarding the size and performance of the distribution...
Read More