Archive | General RSS feed for this section

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

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

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

The DBA’s addiction

I confess. I have an addiction. Recently I have observed the symptoms in a work associate (also a DBA). I cautiously broached the subject with him and he confessed with a big leering grin on his face. Absolutely hooked. The particular vice I refer to is the marvelleous hard disk drive. They are wonderful things, […]

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

Getting started

I hadn’t given much thought to blogging about data architecture until recently. I attended a course run by SSIS expert, Andy Leonard, called Zero to SSIS. He is part of the US based company Linchpin People and I really like their community support ethic. I have delivered training courses before and this last year I have been managing […]