This is one of those, very short, very focused blogs that actually first got me into blogging. It was a
Category: SQL
Generating Large XML Data Files
Just recently I needed some large example XML data files to prepare for some blog content. Now, I thought it
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
Man of Distinct(ion)
Its not often that I learn something new about the fundamentals of SQL. Sure they add to the syntax all
Grouping multiline SQL data using XML
A friend of mine recently asked for help with a bit of SQL he was working on. True, he was
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
Where have you been all my life?
Every once in a while a technology comes along that once you have become accustomed to it you wonder how
Gandalf gives a ‘Bit’ of inspiration
So there I was in Camden High Street (which was weird because I live in Devon) posting a letter and