This is one of those, very short, very focused blogs that actually first got me into blogging. It was a
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
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
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
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
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
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