The world is full of information. So much so that we may believe there’s nothing left to write or do. As I try to get back to blogging more frequently I find myself wondering what to write about. It’s not to say my day is not full of lots of things to do. The question I was asking myself is why should I write these things when the world already has great writers and great information out there?
The answer of course is simple. Question Everything.
Ask any of the experts in a field of study and they will tell you one of the best ways to learn a new topic is to present on it. You force yourself to learn about what you’re presenting so that you are prepared for it. Now don’t get me wrong I use the scripts available out in the community all the time. I suggest them to clients and to fellow DBA’s. I am not advocating re-inventing the wheel. They are no doubt an essential tool in helping to make our lives easier and better.
Just because you get the perfect script to meet your needs doesn’t release you from responsibility from what it does. If you install a new script on your servers and it slows things down or has a negative side effect that the original designer didn’t mention or you didn’t realize, then your boss is not going to blame that on the person or blog you got the script from. They will blame you for releasing it into the environment.
So what should you do? Well as the person using the script you should read what the person who designed it wrote about it. Most of the time the designer of the script will detail what it does in blog posts or in some sort of documentation if by chance it doesn’t have that then dissect the script and figure out what it does. I prefer to take apart a script myself so that it forces you to learn how to read other’s code and how to figure out what it is doing which to me is an essential part of being a DBA. We rarely get things in the format we expect. Unfortunately many people don’t think like a DBA.
For the Senior/Master/gurus out there don’t just hand your new guys scripts and say run this and it will do what you need. Perhaps tell them you have a script that does what they need and here are the ways you did it perhaps the new guy can find a new better way. This teaches them and guides them at the same time. A good example of this is Quest’s new Perfmon counter poster. You have a lot of information at your fingertips but don’t just look at the benchmark numbers and assume that’s what works for all situations make sure to benchmark your own servers and find out what numbers are right for your situation. As I read through this new poster this weekend I realized there was some things I could change in what I was tracking to give me more information about my server.
If your one of the ones out there writing the scripts THANK YOU! I applaud anyone that has put something out there for others to use and that has helped make our lives a little easier. Keep up the good work and keep doing what you’re doing.