SQL Server : Back to School

In my current role about a third of the databases I look after are on SQL Server. The University as a whole has more SQL Server than Oracle, but most of the key systems are on Oracle and that is what my department work on.

I’ve been working with SQL Server since version 7.x, but it has never been a primary focus of mine. As a result, I am an “adequate” SQL Server DBA, but if I ever come to you asking for a job as a SQL Server DBA, press that button on your desk that opens the trap-door under my feet. 🙂

A couple of days ago I had a message from a colleague in another team, asking me if I could take a look at a performance problem on a SQL Server database that sits under SCCM. Cue panic, cold sweats, paranoia, fear of being “found out” etc. 🙂 A few seconds later I gathered myself and thought, what would I do if this were an Oracle database? With that safety blanket firmly in hand, I plugged through the process like I would on Oracle (turn it off and on again 🙂 ) and a bit later everything was OK. It was a little bit random, but we got there.

Yesterday I got another call about the same system. A little better prepared this time, we walked through some stuff and I think we have a better understanding of the issues now. It’s not so much a SQL Server problem as a SCCM problem, in my opinion that is. 🙂

Anyway, during the process I was repeatedly asking Uncle-Google about stuff and regularly came across information by Thomas LaRock, either directly or by people quoting or pointing to his material. I was already aware of Thomas after being introduced to him online a long time ago by Jeff Smith, when he pointed out that Thomas became a Microsoft MVP on April 1st, the same day of the year I became an Oracle ACE. 🙂

So this overly long and random post is basically saying, “Thanks Thomas for putting out quality material on the interwebs!”, and if you are a SQL Server DBA, check out his blog! 🙂