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)
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.
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
Great video with great explanation. Waiting for more to come.
Thanks a lot
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