Sep 052013

Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it to Auto-grow on default setting to avoid performance hit. Transaction Log files cannot take advantage of Instant File Initialization. Related posts: SQL Tip-3 | Don’t Shrink your Database Best Practice No.5 Best Practice No.6 Best [Read More]

Sep 022013

In your backup strategy avoid taking daily backups of your read-only databases, monthly full backup is more than enough. Related posts: Best Practice No.20 Best Practice No.14 Best Practice No.6 Best Practice No.33 Best Practice No.18

Aug 222013

Always use SQL Server Configuration Manager to change Service account for any SQL Related Service. Related posts: Error while opening SQL Server Configuration Manager – Fixed SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic* What all changes require a restart of SQL Service? SQL Server AWE Enabled Option | [Read More]

Aug 152013

Enable “remote admin connections” on all your SQL Servers to be able to take DAC (Dedicated Admin Connection) remotely. Related posts: Best Practice No.13 Best Practice No.15 Best Practice No.24 Best Practice No.8 Best Practice No.26