SQL DownUnder CodeCamp 2007 – Top ten DBA mistakes (18)

Session-18

Topic: Top ten DBA mistakes

Kelvin Kline – SQL Server MVP

Mentioned about the free seminar hosted by Quest software on SQL server in Melbourne on 16th October 2007:

http://www.quest.com/events/listdetails.aspx?ContentID=6220&site=&prod=&technology=&prodfamily=&loc=

 

Some common mistakes: Unverified Backups, Insufficient error notification, Ignorance of internals, Unknown scalability requirements, No baselines or benchmarks, Query tuning ignorance.

 

Top 10 of the session:

10. Server and application ignorance

9. Fire-fighter and script pusher modes : DBA’s excel when they add value to business process and business performance, DBA’s frequently get stuck in the rut of solely fighting fires and/or pushing out scripts.

8. Wrong feature for the job

7. Multi Server Management

6. Too much GUI

5. No troubleshooting methodology

4. Inadequate automation

3. Untested change management

2.Unsupervised scheduled job

1. Inadequate preventive maintenance

 

Tools from Quest Software to prevent / help avoid the above mistakes:

Spotlight on SQL server enterprise

Change Director for SQL server

Performance analysis for SQL server

LiteSpeed for SQL server

Toad for SQL server

Capacity Manager for SQL server

October 16, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences

Leave a Reply

You must be logged in to post a comment.