Best Practices

Make sure you configure SQL Server to run on a NON Default port.

Keep Backup and Database files on separate disk to avoid single point of failure.

Keep VLF Count in check for all your transaction log files. Too many VLFs can cause slow DB Recovery &

Use Set NOCOUNT ON for all Batches, Stored Procedures and Triggers to reduce Network traffic for SQL Server.

Grant Granular access whenever possible to avoid providing elevated access.

The KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent

Disable xp_cmdshell unless it is absolutely required.