Blog

4 Data Warehousing

•7th January 2019

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...

0 Data Warehousing

•28th December 2018

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. ...

Data Warehousing Tip #1 - BI Design Hampshire

0 Data Warehousing

•10th December 2018

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...

2 Replication Performance Tuning

•20th October 2014

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...

4 Replication Performance Tuning

•26th November 2012

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

The impact of having data sitting in the distribution database that doesn’t need to be there can be...

0 Replication Performance Tuning

•8th November 2012

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...

1 2