Best Practice Analyser (BPA) introduced in SQL Server 2008 R2
SQL Server 2008 R2 Best Practices Analyzer (BPA) was released in mid June. Here is a release announcement: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/06/19/sql-server-2008-r2-best-practices-analyzer-is-now-available.aspx 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: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

It runs on both SQL Server 2008 and SQL Server 2008 R2.

Chris

Published Saturday, August 28, 2010 11:50 AM by Testas

Comments

# TI SPACCO LA FACCIA – SCONTRO NUCLEARE CHICCO TESTA-DOTT. TOZZI – COMINCIAMO BENE.avi | Baby Bouncer ??? Fisher-Price Babygear Baby Bouncers@ Sunday, August 29, 2010 3:53 AM

Pingback from  TI SPACCO LA FACCIA – SCONTRO NUCLEARE CHICCO TESTA-DOTT. TOZZI – COMINCIAMO BENE.avi | Baby Bouncer ??? Fisher-Price Babygear Baby Bouncers