15 Jul

Best Practice No.21

When choosing service accounts, consider the principle of least privilege.

11 Jul

Best Practice No.20

Don’t forget to backup System Databases (Master, Model and Msdb) while configuring Backups for your SQL Server Instance.

8 Jul

Best Practice No.19

Always keep Data and Log files on separate Physical Disk.

4 Jul

Best Practice No.18

Avoid using SELECT * FROM <Table_Name>, try to use only the required Columns & Rows – if possible.

1 Jul

Best Practice No.17

Configure start-up mode of your cluster SQL Services to Manual.

27 Jun

Best Practice No.16

Try not to place user data on Primary File-group.

24 Jun

Best Practice No.15

If you are using Fill Factor don’t forget to enable Pad Index.

20 Jun

Best Practice No.14

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