SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...

6/23/2010

Download SQL Server 2008 R2 Best Practices Analyzer

2:08 PM  , , , ,  No comments

Recencly Microsoft has released the Best Practices Analyzer (BPA) for SQL Server 2008 R2. BPA is a tool which helps Administrators to audit there local and remote SQL Server instances sagainst system events, logins, permissions and metadata for recommendation if it doesn't follow MS best practices for SQL Server.

But, you have to have pre-requsite installed on your system before you install BPA for SQL Server 2008 R2, they are:

Note: There are some issues reported related to installing, you may find the work around by Adam W. Saxton and in the Insturction section.

Read More