Introducing SQL Server 2008 R2 BPA

Die Ankündigung kam schon während der European PASS Conference, jetzt scheint der Download schon einige Tage verfügbar zu sein! Hier der englische Text von Dana Burnell (SQL Server Program Manager). Man beachte die System Requirements beim Download!

My name is Dana Burnell and I am a Program Manager for Microsoft SQL Server. This spring I worked on creating the SQL Server 2008 R2 Best Practices Analyzer (BPA). It was released in mid June. Here is a release announcement: BPA is designed to allow Administrators to validate their SQL Server instances against Microsoft established best practices. It includes best practices validations for SQL Server, SQL Replication, Analysis Services, Integration Services, Reporting Services, and Setup. BPA examines your SQL Server instance with roughly 150 validations of system events, login permissions, SQL Metadata settings, error logs, and reports those items that don’t conform to best practices. For each non-compliant error or warning there are detailed descriptions of the best practice and instructions for becoming compliant. For more information and to download SQL Server 2008 R2 BPA go here:

I am writing to let you know of the existence of the BPA utility. It runs on both SQL Server 2008 and SQL Server 2008 R2.

Thanks Dana for the reminder!