Best Practice No.24
Disable “xp_cmdshell” where it is not required. If this is required for some admin tasks make sure you disable this
Read moreData platform insights by Sarabpreet Singh Anand
Disable “xp_cmdshell” where it is not required. If this is required for some admin tasks make sure you disable this
Read moreYou should avoid shrinking your database until and unless it becomes unmanageable. Shrinking is a Resource intensive task, Moreover it
Read moreset start-up mode of Standalone SQL Services to start automatically.
Read moreI know this one is very basic but in the recent past I noticed a couple of environments where the
Read moreDon’t keep the System Database files & Windows installation on same disk.
Read moreMany a times I’ve seen that DBAs forget to recycle the ErrorLog of their critical SQLServers. Now I also understand
Read moreSQL Server 2014 CTP1 is out with lots of cool & exciting features, if you’ve not yet downloaded it, you
Read moreWhen choosing service accounts, consider the principle of least privilege.
Read moreDon’t forget to backup System Databases (Master, Model and Msdb) while configuring Backups for your SQL Server Instance.
Read moreAlways keep Data and Log files on separate Physical Disk.
Read more