Rittman Mead - Delivered Intelligence

I have a love hate relationship with query tuning. Part of me enjoys the challenge, the solving of a puzzle, but on the other hand there is that naked fear of failing to meet a customer’s expectations. I prefer the type of problem where I am told the business objective of the query and then [...]

A couple of weeks ago I posted an article asking whether dimensional modelling was suitable for all types of reporting, even operational, and I got the largest amount of feedback that I’d ever received for an article. The article was in response to a project I was working on where this question had come up, [...]

A quick test to see if I can post again (and whether my RSS feed is updating).

One of our customers recently had an interesting database design problem. The customer has a fact table that contains transactions at a customer level. Each customer should only be able to see their own transactions, but also needs to see totals at a customer category and all customers level that includes all customers, not just [...]

We are currently putting the final stages of a DW migration for one of our customers to bed – they have a small DW (just over half a terabyte) on old and unsupportable equipment – it was good stuff when it is was new, but now… Like all conscientious developers we insist on a full [...]