Personal Development

ABC The best trait of a SQL DBA

Have you ever wondered what the best trait all super SQL DBAs possess? Well I will tell what the best trait is and an easy acronym to remember it.

I had a conversation with one of my colleagues we talked about the different DBAs and System Admins in the company both past and present and he asked me what I had learned having met them all.

It was an easy answer and I replied my ‘ABC.’ He looked perplexed and then I told it him what it stood for.

ABC = Always Be Checking.

As a DBA I see myself as the protector of the data and liaison between users, developers and system admins to ensure that everyone is happy.

The only way I can do that is to follow the ABC.

Check backups

Check SQL jobs

Check database mirroring

Check SQL Logs

Check for unused indexes

Check SA password

Check index suggestions and liaise with developers to implement them and maximise their potential

Check with application managers that users are having a good experience connecting to the database

Etc

Along the DBA journey there are many problems which you will face and many of them can be fixed at source by following the ABC mantra.

If you don’t want to follow the ABC mantra then you will always find yourself reacting to situations rather than managing them.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.