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

Super(hung out to)Dry

The admission in April 2012 by SuperGroup (the parent company of fashion brand SuperDry), that the entry of a ‘+’ sign instead of a ‘-‘ sign on some forecasting figures, led to its 3rd ‘profit’ warning being issued in 6 months. This led to a revised annual profit shortfall of £8m. Robust business intelligence (BI) […]

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

SQL Server leads the (verti)paq

Over the last few years, many large organisations have very likely been taking a serious look at the Microsoft Business Intelligence product stack. It’s a no brainer to give it a try as in general the licensing is free, but there are other offerings. Some big players out there simply attract attention because of their […]

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

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