August 11, 2011 by Mike Hillwig
Yes, I blame Brent Ozar.
A little more than two years ago, I started following a few people on Twitter who knew about SQL Server. I must have been looking for answers to some particular problem. One of those people was Brent Ozar (twitter | blog). The other was Tom LaRock (twitter | blog). And I started reading their blogs religiously. And I learned a ton. One of the things I learned from both of them was that there is an entire community of SQL Server people out there who are willing to help younger DBAs develop their skills. And they don’t ask for much in return. I’ve tried to contribute what I can to that community.
In most major cities, there is a local user’s group of SQL Server users and they get together regularly to discuss particular topics (Free training!) In metro Boston, we have a great group run by Adam Machanic (twitter | blog). And that’s where I got to meet both Brent and Tom, who have spoken at our local group. And along the way over the past two years, everywhere I go, I have met people I learn from. It’s not because they’re getting paid for it. It’s because they’re just as passionate about SQL Server as I am. And they love to talk about it just as much as I do.
There is so much to learn, and every time I hear someone speak at an event, I learn tons. That’s when I started asking myself a question: What can other people learn from me? I’ve not been a DBA my entire career, and I haven’t been focused solely on SQL Server until very recently in my career. I’ve had the title of DBA for over five years, but I’ve continued to manage applications and servers, not just databases. A few months ago, I spoke at SQL Saturday Boston about my experience virtualizing SQL Server at my previous employer. I had a good story to tell, but I’m not the most knowledgable person on the subject, and there are certainly people who know more than me. But my audience gave me some great feedback.
Three weeks ago, I started a new contract position and it hit me. I’m working with and for two really good DBAs. My boss’ boss knows a ton about SQL Server, and she’s a brilliant woman. I was sitting in her office last week and we were talking about the environment. She was telling me about performance problems due to transaction logs having too many virtual log files. I have to admit that I had never heard of a VLF until then. She asked what I thought of the environment so far. That’s when I have an epiphany. I was telling her that the current process of creating a new maintenance plan on each new server for backups, transaction log backups, index maintenance, updating statistics, and the like weren’t going to scale. Sure, it works today with three production servers. But at ten, fifteen, or even twenty servers, that’s going to be incredibly difficult. You see, I do have something to bring to the table. Somehow, she trusted that I knew what I was talking about and said “Make it scale.” They’re planning on adding countless SQL Servers in the coming months and need every process to be repeatable and scalable. I’m working on replacing every maintenance plan with a SQL Agent job that has a script that can be repeated on every server.
I’ve worked in IT operations most of my career. I’m a nut for automating manual processes. If I have to do something more than twice, you’d better believe that I’m going to look for a way to automate that process so that it can either be done in less time or be done by a junior staff member, such as a help desk technician. And that’s the stuff I’m good at. Oh, and I’m a complete nut for consistency in my servers. I believe that’s the key to stability in an environment. We manage by rules and not exceptions.
For the past week, I’ve been reading up on master/target relationships with the SQL Server Agent. There isn’t a whole lot out there, and it seems perfect for the environment I’m managing. And this environment is just screaming for policy-based management. That’s something I have to learn.
Saturday, I’m speaking at SQL Saturday 79 in Ft. Lauderdale, Florida. I’m not a bad speaker and I want to get a lot better. That’s my opportunity to give back to the community, and this is what I have to teach other people.
Over the past two years, Brent has become a friend and mentor, and I take every opportunity I can to hear him speak or just to hang out with him. As I was looking for a new position, I had someone in the SQL Server community who could help me once again with some pretty good advice.
What’s next for me? From Three to Three Hundred Servers: Making Your SQL Server Environment Scale. Look for that at the next SQL Saturday in Boston.