Lets start the month with some best practice’s.

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer will allow you to scan your sql server instance and will report potential issues.There is a error area and warning area which will give detailed explanation of the issue.

Looking at this report will help you to fix potential problems.

Best practice analyzer works with Microsoft Baseline Config Analyzer and baseline config analyzer is used to scan the instance.

Recently when I scanned instance,I got the below report which quickly helped me to fix some potential issues.

Just give a look at the error part.You should never see this in PRODUCTION environment!