SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer

Microsoft has released wonderful tool SQL Server 2008 R2 Best Practices Analyzer. I have previously used this tool and found it quite helpful. Here is the latest version which you can download from MS site.

Microsoft SQL Server 2008 R2 Best Practices Analyzer

However, I received quite a few emails that users are not able to install it after downloading this tool. There is nothing wrong with this tool but there are two prerequisites which are needed. I am additionally listing the download link to all of them here with.

Microsoft Baseline Configuration Analyzer 2.0

Microsoft PowerShell 2.0

Reference: Pinal Dave (http://blog.SQLAuthority.com)

6 thoughts on “SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer

  1. Hi Pinal,

    I have already installed SQL server 2005 in windows 7 operating system, Now I have install SQL server 2008 R2. Installation has been completed. but I can’t see “SERVER NAME” in connect to server dialog box of management studio.

    I think problem is due to SQL Agent is not started, I tried to start SQL server Agent, but I can’t start. It gives error.

    I had tried to find solution in blogs and etc…, but I can’t find any solution that is helpful.

    Thanks in Advance.

    Regards,

    Haresh

    Like

  2. Pingback: SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts Journey to SQL Authority with Pinal Dave

  3. Pingback: SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial Journey to SQL Authority with Pinal Dave

  4. I downloaded the tool and am trying to connect to one of our development SQL servers to test this out before using it on produciton.

    I installed it on my client – should it be on the SQL server for which I am trying to gather information?

    When I do try to connect to one of the development servers from the software on my client I get an error. Does the software need to be on the SQL Server for which I am trying to gather information?

    Thanks
    Daria B
    DBA

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s