About MCDBA (6/7/2006)

 This is the E-mail I received today from an old friend in Canada and I want to share the content and reply with all of you.

 I was exploring in Microsoft website to find more about MCDBA. I was confusing about the new certificate "MCTS" which it's books aren't available yet. I thought you are the best person who can help me. How can I start to study for DBA certificate. As you know, I'm in Canada. Please introduce me the books. I will find them here and start to read as soon as possible. Thanks

Dear Nazanin
Let’s take a look to the role of a Database Administrator. I believe we’d better be more specific and just talk about SQL Server administration.
SQL Server is a service that works with integration with Windows (2000 or 2003) server. So as an efficient administrator one should have a solid knowledge about windows 2003 server. So as a starting point the best place I believe is the book MCSA/MCSE Self-Paced Training Kit (Exam 70-290): Managing and Maintaining a Microsoft® Windows Server™ 2003 Environment, Second Edition. If you have the chance to attend a course, the courses 2274 and 2275 are better choices. If you have a good knowledge of Active Directory it is always considered as a plus, but I believe what you get from these courses out of active directory will be enough.
 Now it is the right time to start with real SQL Server. I assume that as a person who decides on a career in SQL server administration has a good background in SQL language. If so the next step is starting SQL Server administration courses. The courses 2779 and 2780 are decent courses. But anyway considering that now .NET Framework is embedded in SQL Server 2005, it is always expected from a database Administrator to have at least the .NET knowledge to read the .NET code. Consider any course or book that can give you a clear idea about .NET Framework. Worst case scenario, you can take the MS 2559 which I believe it is enough to start SQL Server 2005.

Some Friendly Advices for DBAs
 Don't forget that a Database administrator gets a high salary for almost doing nothing! but gets fired with the FIRST mistake. Make sure you will be quite confident in what ever you read. A DBA must know at least one thing down to the last details which is "
HOW TO RESTORE A DATABASE". Remember for anything you have time to go through the training materials, articles and references and you have lots of free time to do them. But in a case of a database disaster, you will have a very limited time under extreme pressure to have the server up and running in minimum duration to minimize the production down time.
Best of luck
Alireza


Your name:
Email:
URL:
Comments:
 

 -