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 (https://blog.sqlauthority.com)

Best Practices, SQL Scripts
Previous Post
SQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer
Next Post
SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

Related Posts

6 Comments. Leave new

  • 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.

    • anupvarier
      May 9, 2011 9:35 pm


      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.

  • Givn for all

  • Harit PAtel
    May 7, 2011 3:52 pm

    Great video with great explanation. Waiting for more to come.
    Thanks a lot

  • Tirtha Kumar
    May 20, 2011 12:21 pm

    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…

    • funkymallam
      May 23, 2013 12:33 am

      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


Leave a ReplyCancel reply

Exit mobile version