HASSUG Meeting – 04/13/10 – Recap

For the first time in a while, I attended the Houston Area SQL Server User Group meeting and I am glad I did. Especially since I walked away with a free (signed) copy of the book SQL In A Nutshell.

The speaker was Kevin Kline (@kekline) and the topic was The Top 10 Mistakes on SQL Server.

High Points Gleaned

10.  Disks – Thinking space not IO (insufficient I/O, poor choice of RAID type, not enough spindles, etc.)

09.  Ignorance – As an IT professional you should know how SQL Server works at an “internals” level.

08.  No trouble-shooting methodology

07.  Going with the defaults – Autogrow/autoshrink on DB’s, default filegroups, etc.

06.  Security as an afterthought – SQL attacks are the #1 hack on the internet today.

05.  Inadequate automation

04.  Wrong feature or technique for the job

03.  Apathy without change management

02.  Inadequate preventative maintenance

01.  Backups <> Recovery

Links

• Kevin Kline’s Blog
• White Paper for Top 10 Mistakes on SQL Server
• SQL Server Pedia
• Quest Software

Announcements

May Meeting: TUE 5/11 @ 11:30AM – How to Protect SQL Server with DPM 2010 – Presenter: Javier Calvillo, Microsoft

Special Meeting: TUE 5/18 @ 6:30PM – Essential Database Maintenance – Presenters: Kimberly Tripp & Paul Randal, SQLSkills

July Meeting: TUE 7/13 @ 11:30 – Topic TBD – Brent Ozar

–

^..^