Category: Best Practices

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...

Understand NOLOCK hint before using this in your transactions\applications – the data you are reading might not be consistent (Dirty Reads) Related posts: Best Practice No-2 Best Practice No.16 Best Practice No.19

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...

Make sure Auto_Shrink is disabled for all Databases on your Production Servers. Related posts: Best Practice No.8 Best Practice No.10 Best Practice No.13 Best Practice No.14 Best Practice No.20

Keep your TempDB Files & all other database files on separate disks. Related posts: Best Practice No.6 Best Practice No.19 Best Practice No.11 Best Practice No.22 Best Practice No.5

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...

set start-up mode of Standalone SQL Services to start automatically. Related posts: Best Practice No.17 Best Practice No.13 SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic*

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...