There’s a running joke in my house to do with bats, the 3rd eldest of my girls is a teeny
Punchlines and Context
It was 7 o’clock, a fine Sunday evening in the early Autumn with the sun now behind the horizon. I
Live and learn – Part 4,235
Here we are again, back again with the bane of all programmers lives:- Dates! and I’m not talking about the
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
Lookup Date Values in DTS package
I recently came to extend some DTS packages that we have implemented for a client to include a LOT of
Trust Issues
Earlier this week I came across an issue with regards to one of our sites that integrates with SAP Business
Bring Out ‘Yer’ Dead
For any Python fans out there you’ll be well aware of the ‘Bring out yer Dead’ scene from the Holy
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