This is one of those, very short, very focused blogs that actually first got me into blogging. It was a very good former colleague of
Category: SqlServer
Rank and File…
Just recently I was asked to make some changes to an existing data warehouse, we needed to add Tender data (that is, how a transaction
Upsert [sic] with SAP Data Services? Don’t cry though….
So, recently I find myself heavily involved with SAP Data Services and data migrations, I know what you’re thinking… thats not real code! And you’re damn
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 complex data warehouse. Its been
Improve Readability using ROW_NUMBER()
What did I ever do without the TSQL Row_Number() functionality. I do remember way back in days of yore (when I had youth, less weight
Case Insensitive Lookups with SSIS
Whilst recently compiling a reasonably complex transformation to bring in some data from an Excel spreadsheet I was left in the situation where I had
