Aug 122013
 

Apply Password policy on all SQL Server logins (along with password expiration if possible) to avoid any security compromise. Related posts: Best Practice No.18 Best Practice No.6 Best Practice No.9 Best Practice No.3 Best Practice No.27

Aug 052013
 

Always change the Page_Verify Database Option to Checksum after you migrate it to SQL Server 2005 or higher. Checksum is default for databases created on SQL Server 2005+. Related posts: Best Practice No.14 Where are my system databases? Best Practice No.20 Best Practice No.7 SQL Server Management Objects (SMO)

Jul 252013
 

Disable “xp_cmdshell” where it is not required. If this is required for some admin tasks make sure you disable this post completion of the activity to reduce surface area. Related posts: Best Practice No.1 Best Practice No.4 Best Practice No.18 Best Practice No.12

Jul 182013
 

Don’t keep the System Database files & Windows installation on same disk. Related posts: Best Practice No.6 Best Practice No.19 Best Practice No.11 Best Practice No.5 What do you mean by Principals? (with respect to SQL Server)