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
Category: SqlServer
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
Using Visual Studio Templates to Scaffold ‘Framework Stacks’
Any applications developer worth their salt will, even when they have downtime, look for new ways to make themselves more productive whilst retaining their quality
