Category Archives: Operation Productivity

Reliably Drop A Database In T-SQL Script

  I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I think I have a solution, which at least I cannot prove it not working so far. 1: USE master; … Continue reading

Posted in Administration, Operation Productivity | Tagged | 2 Comments

Database Administration KPIs – 2/2

In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to evaluate DBA work performance from business perspective. However, I believer there should be some qualitative KPIs that can be best … Continue reading

Posted in Operation Productivity | Tagged | 1 Comment

Database Administration KPIs – 1/2

  As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way, what criteria would I hope to be used by others (my manager / clients / peers etc) to evaluate … Continue reading

Posted in Operation Productivity | Tagged | 7 Comments

Procedural Justice In Database Administration

  According to Wiki, Procedural Justice (PJ) means: Procedural justice is the idea of fairness in the processes that resolves disputes and allocates resources. To me, this concept of PJ should be introduced to database administration domain as well, I’ll … Continue reading

Posted in Operation Productivity | Tagged | Leave a comment

Improve DBA Operation Productivity – Part Two

As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our productivity is limited by our capability bandwidth to process the information received. However, if this information is frequently “polluted or … Continue reading

Posted in Operation Productivity | Leave a comment

Improve DBA Operation Productivity – Part One

  I define DBA operation productivity as the total positive values brought to the work environment by a DBA in a unit of time. How to improve productivity is really a big topic, but every big task can /should start … Continue reading

Posted in Operation Productivity | Leave a comment