SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server – DBA productivity and less is more

15 February,2012 by Jack Vamvas

A typical DBA day can include a mixture of Operational, Engineering and Architectural tasks. Whilst maintaining 100% database server availability and acceptable performance levels.

I’m always looking for method to focus my efforts.  Automation, documentation , reporting, monitoring are all ways of simplifying the mountains of information. S

Inspired by the minimalist guide to database administration

My current  Zen List of DBA productivity

1)    Check work email 3 times a day. With the exception of critical systems monitoring emails – which need immediate attention. Remember: if the issue is important enough , people will find you e.g IM & mobile phone

2)   When checking email – take an action on every email :  archive, delete , add to task list, delegate

3)  If I estimate the action to take less than 1 minute – commit the action

4)  Commit to one task at a time.

5)  Focus completely on that task. Leads to less mistakes and attention to the details.

6)  Aim to do less tasks –  with greater  concentration . Focus on solutions – documenting – reusing

7)   Morning ritual : check failed backups, jobs, critical errors in logs. Don’t let problems stack up.

8)  Focus on necessary tasks. Think about what is most important to fulfil the job. As a Production DBA , it could be : availability.

 

 

See Also

SQL Server – Maintaining different environments

Top 10 DBA Tips to develop your competitive edge

 SQL Server DBA Top 10 automation tasks


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer