Just over a month of DBA-ness and I’m still alive. What have I learned and where am I at?
As far as learning goes I’m into my 2nd reading of SQL Server 2008 Administration In Action, this time putting it all into practice and letting the theory really sink in. I have a few other books that are on their way from Amazon that I can’t wait to get stuck into as well. In 2 weeks I’ll be off on a 1 week course Maintaining a Microsoft SQL Server 2008 Database, this should really be a refresher for me and hopefully involve more lab work and possibly meeting up with other DBAs.
I’ve had a play around with the work environment. Had disk drives run out of space, troubleshoot locking issues, analyse index usage stats, looking into fixed database roles and reading up on partitioning tables. I’m lovin’ it to say the least.
I’m lucky I’m in a position where I can spend time reading the blogs or watching presentations of SQL people who I also follow on twitter (@jsauni/sql). I recently watched Brent Ozar speak on Using Perfmon and Profiler to capture performance metrics which was a great source for knowledge, tools, techniques and reasoning/understanding. Check it out if you can.
