August 2010 - Posts

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

Posted by Testas | 1 comment(s)