Grade yourself as a good SQL Server DBA
The other day I was evaluating myself as how I'm doing as a dba. I'm not going to write down my scores but in my opinion, to be good your should come near something like this:
| Database administration |
10 |
No discussion here, you have to excel in administration |
| Installation |
9 |
You might as well be good at it as this is a rather small domain to master |
| DTS |
9 |
|
| SSIS |
9 |
|
| ETL concepts |
7 |
|
| Clustering |
8 |
Not everyone deals with clustering but one day they will |
| Security |
10 |
Both Windows and SQL Server security and security concepts in general |
| VB.NET |
7 |
Important in SQL Server 2005 |
| SQL |
9 |
|
| T-SQL |
9 |
|
| SSRS |
6 |
Athough a typical DBA does not develop reports but setting up SSRS in SQL Server 2000 can be quite difficult |
| SSAS |
5 |
|
| VBScript |
9 |
|
| Hardware |
9 |
|
| XML |
7 |
We won't get rid of it anymore |
| ERD |
9 |
|
| Disaster Recovery |
10 |
|
| Performance troubleshooting and tuning |
10 |
|
So what's your score?