The Reluctant Production DBA—or I’m a Big Girl Now.
I’m a Big Girl now. Not in the Christina-Hendricks- from- Mad- Men sort of way (well maybe in that way too, but I digress), but in the Not –afraid- of- Servers- Networking- and –Maintenance-Tasks sort of way.
You see, I’ve been doing ETLS and programming for databases for ten years now, but I’ve always been much more comfortable inside the query tools rather than outside of them. Outside is the scary realm of consoles, networking, users and permissions. I didn’t completely avoid them. I knew enough to do my job, but I must admit I was EXTREMELY grateful that the disks, logs, backups and maintenance tasks were not my responsibility. Although this made me happy in the sense of “avoiding that which makes us uncomfortable” it did leave me with a bit of a Pinocchio complex. I was convinced, and rightly so, that I would never flourish as a DBA until I sucked up my fears and did some learning.
So five months ago I took a leap into a job where I would be the first and only DBA. Google, SQLServerCentral, and MSDN all became my lifelines as I forced myself through the transformation from a “Development DBA” to a “Development DBA Who Doesn’t Suck at Production Work Either”.
And I’ve learned some awesome stuff. Installations? Bring it. Disk Configurations? I’m not scared. Maintenance and Backups? Sure. Reindexing and Updating Statistics? Whatever it takes. Transaction Logs? They’re my bitches. SANs? I’ll never be without one again. Virtualizing a SQL Server? I’ll get back to you. Niedermeyer? He’s a dead man. (sorry that last one is not really relevant, but I was rolling).
So here we go. I’ve got more to blog about now than I ever did. I’m a big girl now. Where’s my lollipop?