Reporting from BPA

How do you use Reporting Services with the Best Practices Analyzer? This has
been mentioned in this group, but there is nothing in the help file.
TIA
Dean
Have a look at Chapter 6 of the readme by default in C:\Program
Files\Microsoft SQL Server Best Practices Analyzer\docs. The demo reports
can be found in C:\Program Files\Microsoft SQL Server Best Practices
Analyzer\reports. These should give you an idea of how you can write your
own. The actual schema of the BPA database is not too cryptic so it's fairly
easy to find the info you're after. With the commandline support also you
can see that it's fairly trivial to automate the process of scanning your
databases/trace files and ggenerating compliance reports for your specific
best practices. Hopefully a later release will allow writing your own custom
rules and make this an extremely powrful tools for DBA's and developers
alike (assuming they can agree on what's best practice!)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dean" <Dean@.discussions.microsoft.com> wrote in message
news:B27F321A-11B1-4ABD-896A-2775461A4ACF@.microsoft.com...
> How do you use Reporting Services with the Best Practices Analyzer? This
> has
> been mentioned in this group, but there is nothing in the help file.
> TIA
> Dean