• subscribe
July 05, 2007 12:00 AM

The More Things Change

SQL Server Pro
InstantDoc ID #96477

I suspect that most of you have heard and used the phrase "The more things change, the more they stay the same." The Internet helped me learn that the original quote by Alphonse Karr was actually "The more things change, the more they are the same." I suspect that Karr would agree that many of the discussions taking place in the IT arena today are the same ones that took place a generation ago and will be taking place a generation from now.

Since attending Tech Ed 2007 a few weeks ago, I've been thinking about the topic of IT generalists versus specialists coupled with the paradigm of information overload as it affects the lives and practices of IT and development professionals. Needless to say, these aren't new topics of discussion. I first broached this topic in the SQL Server Magazine Update commentary Can Generalists Handle Complex IT? on December 9, 1999, just a few months after I started writing the editorial for SQL Server Magazine Update more than eight years ago. You'll see that I compare the modern days (circa 1999) of IT development in which it's impossible to be an expert in everything with the good old days when it was reasonably possible to be somewhat of an expert in a wide number of areas. The following is an excerpt from Can Generalists Handle Complex IT?:

"All that said, here's my nagging concern. Sometimes I worry that the solutions we're trying to build require such a high degree of specialization that people doing the job don't always have an adequate level of expertise to solve the problem properly. I do a lot of troubleshooting and tuning for SQL Server systems. I regularly see my clients and colleagues, whom I consider outstanding IT professionals, make simple mistakes. The mistakes are simple for me to find and fix because I spend a lot of time keeping up on the latest tips and tricks associated with database application tuning. The mistakes aren't always simple for the original developers to avoid because they need to keep on top of so many things as they're working in complex distributed and middleware-oriented architectures.

Back in the days of "Little House on the Prairie," Doc Baker did a good job of handling the medical needs of Walnut Grove. He was a great doctor for the time and knowledge available, but today I'd want to see a top specialist if I needed brain surgery. More and more, what's considered a commonplace solution is the IT equivalent of brain surgery, but more often than not, the IT equivalent of general practitioners still do the work. They might be amazingly skilled and talented doctors, but they're still generalists rather than specialists. The tools are getting better, but they're not THAT good yet. I'm don't know whether this is a serious problem, and even if it is, I don't have a good answer. But still, it worries me now and then."

I wrote that in 1999 but the sentiments are still true today. If anything, the need for IT specialization has grown over the past decade. A stray comment from a Microsoft employee during Tech Ed started my wheels churning on this topic. The Microsoft employee mentioned that he asked attendees at one of his talks "who was waiting to upgrade to SQL Server 2005, until SP1 was out." Surprisingly, more than a handful of folks raised their hands. I guess they needed to get busy starting their upgrade when they learned that SQL Server 2005 SP2 was already available. But I was surprised to learn that some of the attendees in that session who had already upgraded to SQL Server 2005 didn't know that SQL Server 2005 SP2 had been available for months. I'm not interested in discussing whether everyone should upgrade to the latest service pack as soon as it ships, although that discussion would be relevant for future generations, just as it is today. Instead, I'd like to examine the state of affairs that leads us to a situation where seemingly sophisticated SQL Server users, who are bothering to attend Tech Ed, would be running SQL Server 2005 and not even know what service pack is out. Making an informed decision not to upgrade is one thing; not being aware that you had the option to upgrade is another. I decided that the cause of this lack of awareness might very well be a case of information overload, which I've been writing about on and off for close to a decade. When discussing information overload, I've commented on the fact that the never-ending supply of high-quality information available on the Internet and from other sources leads to an interesting paradox. The answers are out there, but there are so many darn answers that it's hard to figure out what the "right" answer is. I observed that sometimes this leads to a "head in the sand" conclusion of deciding to do nothing because there's so much information to mull over.

Are we getting to the point that "head in the sand syndrome" keeps people from even knowing that a new service pack is out? I sure hope not. But I suspect that this problem will only intensify as the trend continues for companies to have dedicated DBAs in lieu of a team of developers who share responsibility for SQL Server and let network administrators perform backups. I wonder if columnists talked about this back in the mainframe days. I'm sure columnists will still be talking about this problem a generation from now--after all, the more things change, the more they stay the same.



ARTICLE TOOLS

Comments
  • Tom
    5 years ago
    Jul 16, 2007

    Good article, good comments, great analogy using the physician angle. That analogy really nails the topic; generalists are just as necessary as specialists. The generalists help you figure out what specialist is needed. A colleague once advised me "you can do anything, but you can't do everything." True words.

  • Brian
    5 years ago
    Jul 05, 2007

    While I don't disagree with you that specialists are essential and necessary, I do believe that generalists are essential and necessary as well. Generalists can sometimes see the whole picture in ways that individual specialists can't. For instance, someone who has a good fundamental understanding of the network, system administration experience, a basis in application development and the APIs/assemblies as well as expertise in the database layer may be able to troubleshoot issues that have four disparate teams are all pointing fingers at each other over. A good team is a mix of both types.

    The lack of knowledge on a service pack is an awareness issue. It would be interesting to see how many SQL Server DBAs aren't aware of the latest service pack levels. While I'm sure (I hope?) the percentages would be significantly lower, I think we'd find they'd be higher than they should be.

  • MICHAEL
    5 years ago
    Jul 05, 2007

    Spot on. It's impossible to be an expert in everything IT nowadays.

  • THOMAS
    5 years ago
    Jul 05, 2007

    This is a great topic. In our environment, the term generalist is embraced whereas, specialist is discouraged. We have a couple of guys responsible for all things SQL Server (3+ terabytes and 40+ servers) including the majority of development. Since development imporves the business, SQL administration takes a backseat. SQL Server basically runs itself and really good hardware makes up for more than a few problems. Needless to say, we have looked at SQL2005/2008 but have no plans to upgrade because we can't afford the time and training away from development. It seems like generalist is great, as long as nothing catches fire. That said when something does go wrong we still get the call.

You must log on before posting a comment.

Are you a new visitor? Register Here