Posted by: Colin Smith
old versions, SQL Server 2000
Recently I saw that Paul Randal (Blog | Twitter) posted about reasons that people may still be running SQL Server 2000 and how some people have a poor attitude about it and actually judge others because they are running SQL Server 2000. Wow actually judging people because they are running an old version of SQL Server, that is shocking to me. Anyway, after reading Paul’s Post, I had to post myself as I did not feel that a comment would give me the bandwidth I needed to talk about the subject.
First, I must say that I think it is just crazy to judge someone based on a version of software that another person is running and thinking that they are not a good DBA is just ridiculous. I am lucky and I now work in a shop where we do not have any SQL Server 2000 in the wild but the shop I came from did. I did not really like supporting it as the newer versions of SQL Server have better tools for a DBA to use, but just because something is easier for me does not make it the right fit. If that was the case then I would be running everything in SQL Server 2012 and I would do all my administration via Powershell. That is what is easiest for me but I do not put others down when they say they do not know or like powershell, I certainly disagree but that is OK. I also know that I have many weaknesses in my own skill set that I need to get better at, I mean who doesn’t, so who am I to judge anyone.
I also know that the decision to continue running on SQL Server 2000 is almost never the DBA’s decision. I think that all DBA’s would rather be running a newer version because the newer versions do make it easier to be a DBA. But like Paul points out there are many factors that may contribute to still running that version of SQL Server. In my old shop it was just that we used 3rd party apps from some vendors who are no longer in business so we could not just upgrade the database behind it. And of course, since that environment was so stable, we did not want to invest the capital that it would take to purchase a new app. Also we would just P2V that server and make it a VM. That made it much safer for us to do OS patching and the such since we could snapshot, do what we needed, and if it did not work just revert.
I actually think that being on older versions helped me become a better DBA since we did not have all the DMV’s and some of the other new tools that new versions of SQL bring us.
So do not be a hater. Just be understanding, say wow that sucks, and move on.