RSS Feed

Rookie Mistakes: Installing Everything


October 13, 2009 by Mike Hillwig

Prior to my coming to my current company, somebody had a great love of installing all SQL services on every server where SQL was installed.

This is such a pet peeve of mine, and frankly, it’s a rookie mistake. In my environment, almost all of our applications are off-the-shelf apps with minimal customization. Today I was looking at a web-based app that is an intranet type of collaboration application. The server had Reporting Services, Integration Services, Analysis Services, and Notification Services installed. This particular application barely makes use of the database services and is database agnostic. We could run this thing on Oracle or MySQL. It’s not going to need Reporting Services, and it certainly won’t need Analysis Services.

Extra services mean extra CPU and memory utilization. While it’s not much, these little things add up. And in case of the rare bit of malware that hits SQL server, only software that’s installed can be exploited.

In a perfect world, we would have an understanding of what our servers will be doing before installing the database server. Then we would install only what’s needed. Better yet, in my environment, the vendor’s installation instructions would specify what services to install. If SSRS, SSAS, SSIS, or SSNS aren’t mentioned, there probably is no need for them.

My boss might say “We might need them some day.”  He’s right. We might need them some day. And when that day comes, we can install them. Until then, we don’t.


  1. Needed to write you the bit of observation to finally thank you so much yet again over the beautiful basics you’ve documented on this site. It is so incredibly open-handed with you to deliver without restraint all that some people would’ve distributed for an electronic book to make some dough for themselves, most importantly now that you could possibly have tried it if you desired. These smart ideas additionally worked to be a good way to be aware that many people have similar dream really like my own to see many more with regard to this condition. Certainly there are millions of more pleasant periods up front for individuals who scan your blog.

  2. Superb site you have here but I was wanting to know if you knew of any discussion boards that cover the same topics talked about here? I’d really love to be a part of online community where I can get suggestions from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Thanks!

  3. see this says:

    I have been checking out some of your posts and i can claim pretty clever stuff. I will make sure to bookmark your site.

  4. Good web site! I really love how it is easy on my eyes and the data are well written. I’m wondering how I might be notified when a new post has been made. I have subscribed to your RSS feed which must do the trick! Have a great day!

Leave a Reply

Your email address will not be published. Required fields are marked *