Archive | ETL RSS feed for this section

A Time dimension starter kit

I am currently working on a data warehouse project for Lush Fresh Handmade Cosmetics. They are based in Poole, Dorset in the United Kingdom and have around 900 stores worldwide. Lush make extensive use of QlikView and have a very good business intelligence capability. Recently they featured in a press release from QlikView that reviews […]

SQL Relay 2013R2 – Cardiff

I was very pleased to be able to deliver my Star Schema Primer presentation to members of the SQL Server community at the Cardiff leg of the excellent SQL Server Relay 2013R2 event last Wednesday (13.11.2013). There was an excellent turn out and the sun was shining. Go Wales. Thanks very much to the organisers. The […]

SQL Santa London

Today I had the very big privilege of delivering my Star Schema Database Primer presentation at the SQL Santa 2012 event, held today at Microsoft in London. The free event, put on by the SQLFAQ group, sold out two weeks prior to the date. A sure sign of the increasing popularity and usage of Microsoft […]

Star Schema Primer

Tonight I was privileged to be able to make my first presentation within the SQL Server community at the monthly SQL Server Southampton user group. The tagline of the presentation was “the core principles of the Star Schema database, used for decision support solutions and as the bedrock for Analysis Services cubes and the new […]

Developing SSIS solutions on OS X : Part2 – Equipment and software list

(Part 1 – Introduction) Here is my ideal kit list; MacBook Pro 15″ SSD or Momentus hybrid drive Optional conversion of DVD bay to a second HD bay Apple Thunderbolt Display (or similar external monitor) The software that you will need does depend on whether you are operating as an independent consultant or whether you […]

RTFM and the Software Dummy

Developing software is a rewarding career, but at times it can be tedious and very frustrating. The ability to debug your own code and that written by others is crucial. As those of us working in IT know, from the outside we are all bunched together, but within the industry the skillsets today are extremely […]

Developing SSIS solutions on OS X : Part1 – Introduction

I need to state from the outset that this series of articles is not intended to sway anyone into choosing the Apple platform for SSIS development. Nor do I wish to enter into any debate about Apple hardware versus Windows based hardware. Been there, done that and I regularly lose on many fronts. If you […]

Luxury (pronounced look-shoe-ree)

For those of you reading this in the US, the pronunciation of ‘luxury’ in this manner evokes memories of Derek & Clyde’s comedy skit of the same name (careful they are rude). My old friend Wolly has got in touch to let me know that Monty Python created the original ‘Luxury’ concept in their ‘Four Yorkshiremen’ […]

ETL origins

I landed my first programming job at Mitsubishi Motors in Australia, in 1988. To my very good fortune they were transitioning from VSAM to DB2 and SQL/COBOL. As a trainee programmer I showed an early proficiency for SQL and after one year of programming I ended up in the newly formed Data Services Group as […]