[Automise Professional Edition]
The Microsoft SQL Server Best Practices Analyzer is a free tool, provided by Microsoft, which lets you test for the implementation of many common SQL Best Practices.
The SQL Server Best Practices Analyzer Action allows you to verify those Best Practices from within Automise.
Specify the SQL Server Best Practices Analyzer installation directory from the SQL Server tab in the Options.
BPA Repository Location
The BPA Repository is a database which contains your Best Practices Groups (created with the Microsoft SQL Best Practices Analyzer application.) Specify the SQL Server Instance, database name, and authentication options for the Repository database.
Server
Specify the MS SQL Server to use. Clicking "View List" will attempt to locate any SQL Servers on the network.
BPA Repository Database
The name of the best practices repository database.
Use integrated security
Uses a trust connection where a username and password are not required. The current user does require domain access to the specified SQL server and instance.
Username
The username to use connect to the SQL server with.
Password
The password that matches the supplied username to connect to the SQL server.
Best Practices Groups to execute
Specify the Best Practices Groups you wish to check against. Again, these are defined inside the Microsoft SQL Best Practices Analyzer application. If you are specifying more than one Best Practices Group, specify each on a new line. At present you cannot execute Best Practice Groups associated with SQL Servers which require SQL authentication (Windows authentication only.) This is a current limitation of the Microsoft command line tool.
Action fails if any groups fails to...
The action can be set to fail if any group fails to pass compliance or (optionally) partial compliance.
Log SQL BPA Operations to msbpa.log
If this option is checked, the analyzer will log its behaviour to msbpa.log inside the 'log' directory of the Best Practices Analyzer directory. Each Best Practices Group also generates a log file in this directory, regardless of whether or not this option is checked.