SQL Server Journey with SQL Authority

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.

Twitter: http://twitter.com/pinaldave
Facebook: http://www.facebook.com/home.php#/profile.php?id=654862451
LinkedIn: http://www.linkedin.com/in/pinaldave
SQLAuthority Feed: http://feeds2.feedburner.com/SQLAuthority
SQLAuthority Email: http://www.feedburner.com/fb/a/emailverifySubmit?feedId=872428

Search@SQLAuthority: http://search.sqlauthority.com/
Job@SQLAuthority: http://jobs.sqlauthority.com
Resume:

You can hire me through my company, read the details of here.

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

Pinal at Home Office

Reference : Pinal Dave (http://blog.SQLAuthority.com)