A new geek love: MSSQL

You know a POSTS >> ADD NEW is actually going to mean something when you have to create a new category for it.  Such is the case with MSSQL.  It started as a requirement to facilitate a growing Access database used on a piece of extensively used software.

So – what’s the next logical step when facing an ailing access db? migrate to sql is what i thought or what i knew to do. Not exactly understanding the underpinnings of SQL – the table, the columns the connection strings the ODBC, the ’sa’ user – NONE OF IT!

Seems ignorant now – or maybe naive – perhaps more of an innocent desire to start somewhere. Ahh.. i like that!

So it started as that – An installation of SQL Server 2005 with Management Studio. What the heck was management studio.. well the name blandly explained what was involved.. but – to what extent i anticipated relying on and utilizing this studio of management was not even a twinkle in my eye.  We’re talking a year ago – and I’d read up on my SQL installation and how to create a new database and how to back up a database but we’re talking truly simpleton tasks at this point – however having grazed over reference material for days – i felt inclined.

A year or so later – here I sit having urges to type a transact-sql query to mine a piece of data out of our precious database. Urges that feel like a 7 or 8 year old yearning to wake up extra early on saturday to watch cartoons or play video games.

Simply amazing.