SQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

Yesterday I presented on the subject Check SQL Server Health using Best Practices Analyzer. There was great response to the session. Many asked me if the session is recorded so they can watch it later on. Absolutely, the session is recorded and you can watch it at your convince. Not only you can watch the session online but can also download the same and watch it while traveling or on your Windows Phone.

Video of Check SQL Server Health using Best Practices Analyzer

If you want to download the resources which I have used in this presentation here is the link of the same:

Download BPA resources

Do let me what you think of the same. If you like it, let me know and I will have more videos like the same.

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

About these ads

7 thoughts on “SQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

  1. Hi Pinal ,

    I am facing a problem after installing this tool .I am not able to scan my sqlserver with the tool . When i run the scan i am continoulsy getting the following error
    “Login does not exist on SQL Server OR Login is not a member of the Systems Administrator role” .
    I have a login who has every right of my sqlserver .But even after having such , i am still not able to run the tool.

    • Rajesh,

      You need to make sure the account with which the tool is ran is sysadmin.

      Ex : You login to domain FAREAST with ID SAM,then SAM should be having SA rights for SQL Server.

  2. in a database three tables are link with a main table. in this condition i want to insert a value in main table and then and then others three table will be update by using one query on MySql. plz help me…

    • There are several was in which you can achieve this. I suggest you create an after insert trigger on the main table that will update the other tables

  3. Pingback: SQL SERVER – Watch Online and Download – Inside of Next Generation SQL Server – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer Journey to SQLAuthority

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