15
Jul
Best Practice No.21
When choosing service accounts, consider the principle of least privilege.
When choosing service accounts, consider the principle of least privilege.
Don’t forget to backup System Databases (Master, Model and Msdb) while configuring Backups for your SQL Server Instance.
Avoid using SELECT * FROM <Table_Name>, try to use only the required Columns & Rows – if possible.
Change the recovery model of your databases to SIMPLE where you don’t need point in time recovery and don’t wish to configure Transaction log backups also (Testing Databases etc.)