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 used by “insiders” to evaluate the DBA work from… Read more
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 my work?
In DBA world, we love “no news is… Read more
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 use the following example to illustrate the necessity.
As… Read more
Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots different ways, mostly are using undocumented xp_readerrorlog or sp_readerrorlog. Even in PS way, this xp_readerrorlog is wrapped as a sql command in the PS script. Actually, with PS and Regular… Read more
SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to get familiar with SMO. The beautify of PS is its own discovery capacity. This is best described in the Keith Hill’s free ebook (http://rkeithhill.wordpress.com/2009/03/08/effective-windows-powershell-the-free-ebook/). So in short, we… Read more
One challenge in a super-multiple server (say a few hundred servers) environment is to know what sql services (SSRS/SSAS/SSIS/Engine/Agent etc) are installed and what their versions and the startup accounts are.
Case Scenario: (SQL Service Inventory)
We are managing hundreds of physical servers in our environment, most of the servers… Read more
One common surprise I have encountered in almost all my DBA environments is that a sql job that usually runs <x> minutes, sometimes can take <2x> minutes or even more time to finish.
Case Scenario: (Monitor / alert long running sql jobs)
We have hundreds of sql instances supporting many… Read more
As a DBA, sometimes we may need to demonstrate to some stakeholders when a sql server instance was last rebooted, i.e, just to prove the sql instance weekly/monthly availability . I know there are quite a few blogs / posts online talking about how to do this check, such as… Read more
As a DBA in a complex environment, we frequently need to backup various environment information. One of the backups is to script out the configurations / objects, for example, scripting out replication, jobs, policies and policy conditions etc. Almost all of these scripting work can be done via SSMS,… Read more
I have been blogged non-technical topics for too long and it is time for me to return to my favourite technical topics now.
I plan to write seven real-world cases where I feel PowerShell solution is much more efficient than pure T-SQL one, hopefully these cases can stir some… Read more
For the past 5 or 6 years, we have seen lots of innovative products emerged, from smartphone to tablets, from social media to cloud computing. However, I am somehow disappointed with Microsoft for its innovation speed on database administration front. Actually since SQL Server Management Studio (SSMS) was introduced… Read more
One thing lots of DBA teams, esp. the DBA managers, feel uncomfortable is that it is difficult to quantify/log DBA’s workload and as such it is hard to argue to the upper management for more justified budget and human resources. In worst scenario, this will cause the burn-out and…
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few of them in the past 10 years) mostly because of the following two reasons:
1. Lack of operation productivity. What I see from various products is just a common pattern:… Read more
As a DBA, when can you consider yourself as a senior DBA?
If you read online posts, you will find most of the time, a senior DBA is judged by “Do you know this and do you know that?” approach, which to me is subjective and may cause more…
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 even poisoned”, our productivity is surely compromised.
I define “polluted… Read more
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 from the small things. So here I’d like to discuss… Read more
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined by the requirements from management. I had been fortunate to work with a few excellent managers in the past and benefited a lot from their requirements. I’ll share some… Read more
For the past few years, I have seen tens of sql server boxes added in my work environment every year, meaning more complexity and overhead cost in database administration, I gradually come to a “green” design principle with two points.
1. designing administration framework with a “footprint” as small as… Read more
As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers. So after I read the following interesting article a while ago, “8 Ideal Jobs for M.B.A Grads”, I think it is a good topic for a blog.
In the… Read more
I once talked about the DBA team building about 3 years ago, now when I look back, I still believe my original idea is a good start, however, I feel it is not enough, so I’d like to explore some other areas for DBA team building, that is how to… Read more