Click and Clone – SQL Relay 2015

I had the privilege of being selected to deliver my latest presentation at SQL Relay 2015. Week one was Nottingham and Reading. However, I joined the relay in week two on Monday at Microsoft London and continued through to Bristol, Cardiff and finishing in Birmingham. All the event locations were very well attended by members of […]

The BI Trinity

UPDATE: I had the honour of presenting “The BI Trinity” again last week, this time to the SQL Supper group based in London. I really enjoyed the informal setting and the group. Thanks for the questions and really sorry I had to rush for my train to get back the Isle of Wight. As it […]

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 […]

Transitioning from Reporting to BI Solutions

A couple of weeks ago I had the pleasure of delivering a 2nd presentation to the Microsoft SQL Server community via the excellent SQL Relay 2013R2. The event, very well organised by Christopher Taylor (@SQLGeordie) and Michael Robson (@HeyMiky), was held at St James Park, home of  Newcastle United. What an excellent venue, for football […]

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 […]

Should you bite the hand that feeds you?

Jamie Thompson is an MVP, but more to the point he is a very experienced SSIS developer and a prolific contributor to the SQL Server community. Surely this is why he was awarded an MVP by Microsoft. His recent blog post on GeoFlow (an add-in for Excel that delivers 3D visualisation and story telling) has […]

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 […]

Data Scientists are GO

Was Brains of the Thunderbirds a “data scientist” as well as a genius engineer? If not, which member of the Tracey family designed the world wide data capture system for monitoring disasters & crimes and the necessary analytics system for selecting from that feed the mission for the next episode? International Rescue might have started […]

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 […]