T-SQL Tuesday

This month’s T-SQL Tuesday blog meme is brought to us by Wendy Pastrick (blog|twitter) and the subject is “The Long and Winding Road.”

When I saw this month’s subject, I lunged forward and began to write dropping everything else that I was working on.  Why?  Any chance to incorporate SQL Server with the Beatles is worth the time and effort.  After all, they are the greatest band of all time and if you disagree then you are just going to have to live with being wrong, right?

Many moons ago, well it was actually 1997, I had written some applications in Visual Basic: yes, the old and horribly slow one, you know the one.  But then I discovered Delphi (Object Pascal for the kiddies) and wrote amazing some amazing applications.  I even wrote a few games back then just to prove to myself that I could, they were not horribly great but I felt accomplished and I often wonder where those floppies are so that I could play them again.   Programming was my passion and it felt so amazing to create something from scratch, my own creation, my own Frankenstein: “It’s Alive!”

From there a company noticed some of my freeware applications and offered to move me to Virginia and teach me to write business applications in Progress 4GL for Unix and Windows.  Wait, you are going to train me, mentor me, and pay me double my current salary.  I’m in.  Progress was an amazing product with a very well written SQL-compliant RDBMS that rivaled Sybase, Informix and Oracle only without the marketing hype.  Their claim back then was that they were in over 60% of the Fortune 500.  The problem was that with their Value Added Reseller structure, many vendors would repackage their database as their own (as was allowed if they paid enough for the rights to distribute the product), so many of those companies had no idea that their database was “Powered by Progress.”

My years with the product were amazing learning to write code that would run in Unix, compile and run in Windows and then eventually would become used inside of tags of HTML to deliver data to the web was ground breaking at the time.  I was sure that this was the future, so much so that I became a consultant for the company traveling the globe for two years helping clients with installation, troubleshooting and training.  I drank the kool-aid.  I was pretty sure that with a little marketing they would sink the Oracle juggernaut.

At one company I even administered a SQL Server 6.5 and 7.0 boxes because they had vendor software that required it and I was the database guy for Progress.  I remember thinking how SQL Server was so miniscule compared to Progress.  I remember thinking that they will never make it in this sector.  Well I was wrong about the Xbox, too.

Enter early 2004, I had just successfully completed a fulfilling project and was looking for my next contract opportunity.  The well was dry, there were no opportunities for Progress.  I had a home and a small children and my family did not want to move.  The road had ended that day.  I had to take a job as a systems administrator to make ends meet.  The dream was over.  In the words of the Beatles….

The wild and windy night, that the rain washed away

Has left a pool of tears crying for the day

Why leave me standing here? Let me know the way

Then in 2008, I started a position that was part programmer and part SQL Server DBA.  Prior to this, I contemplated going back to school and leaving the IT field.  But as the Beatles would say…

And still they lead me back to the long winding road

You left me standing here a long, long time ago

Don’t leave me waiting here lead me to your door

The dream had come full circle, I found my new passion:  SQL Server.  It really was my old passion in disguise: DATA!  Hopefully this technology will be the one for many years to come, what do you think?