SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones

Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.

First let us go over 9 Best Practices List.

1. Auto Shrink runs at regular interval (30 mins) in background of SQL Server and it is cause performance dropping fragmentation. It should be turn off.
2. All the statistics should be updated at regular interval.
3. Compressed backup should be used instead of regular backup as it improves speed and performance. Restoring compressed backup is faster than regular restore.
4. Always take full database backups along with differential and log backups. Log backups can be very much useful for point-in-time recovery.
5. Pay attention to “Activity Monitor” – a new feature which displays current activity of a) Process Time, b) Waiting Tasks, c) Database I/O, d) Batch Requests/Sec.
6. Control the configurations as well enforces policies using Policy Based Management.
7. Utilize new datatypes DATE and TIME instead of conventional DATETIME.
8. Keep database updated with latest SPs and Cumulative Updates.
9. Use Dynamic Management Views to figure out longest running queries as well most popular queries.

I really had great time at Microsoft MVP Summit 2009 at Seattle, you can read about my trip to Seattle here. I have recently updated my resume with my latest activities.

Social Media is new thing and I am really enjoying to be part of it. Twitter, LinkedIn, Facebook, Feedreader are my latest interests. Here is my web presence in social media.

Best thing about my job is I can work from office as well as from home office. Find me in action at home office.

Reference : Pinal Dave (https://blog.sqlauthority.com)