17 Jun

Best Practice No.13

If you have to use Profiler on your production SQL Servers – filter as much as you can, configure profiler from a remote machine and do not save the profiler trace on the same production box. Rather prefer using server-side trace.
Note: Profiler is deprecated now, start using Extended Events – they are very light weight.

13 Jun

Best Practice No.12

Rebuild can certainly remove Fragmentation but if the page count is less than 1000 pages, Rebuild is not required.

10 Jun

Best Practice No.11

Configure your anti-virus to exclude all your Database related files namely (mdf, ndf, ldf, trn, bak, log, tuf and other files)

6 Jun

Best Practice No.10

Keep Guest account disabled for all your User Databases.

3 Jun

Best Practice No.9

Provide appropriate Fill Factor while creating\rebuilding Indexes to avoid\minimize fragmentation.

30 May

Best Practice No.8

Make sure Auto_Close is disabled for all Databases on your Production Servers.

27 May

Best Practice No.7

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

23 May

Best Practice No.6

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