database – Proud Salopian

So, recently I find myself heavily involved with SAP Data Services and data migrations, I know what you’re thinking… thats not

Coping with Large Dimensional Workflows

I have recently been working on a third tranche of ETL work for a client which is basically a reasonably

A friend of mine recently asked for help with a bit of SQL he was working on. True, he was

What did I ever do without the TSQL Row_Number() functionality. I do remember way back in days of yore (when