Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Sixty-Second Guide to becoming a SQL Server DBA

By RBarry Young,

Surprisingly on of the more frequent forum questions here at SQLServerCentral is from technical professionals who either by choice or circumstance now find their career direction on the path to becoming a SQL Server DBA, but don't know how to learn the skills that they will need, Well, look no further, because in sixty seconds or less, the following guide will show you how to go about learning the DBA skills that you will need.

First

Get SQL Server Developer Edition, either 2005 or 2008. It has all of the features of Enterprise Edition, but you can get it for $65 or even less. If your employer wont buy it for you, then pay for it yourself.

Second

Familiarize yourself with BOL (Books Online, SQL Server's Help system). Even without your own SQL Server installation, you can still use BOL free at MSDN's website (both 2005 and 2008). BOL will be your best friend throughout your career as a DBA.

Third

Try to get your company to send you to training. This is hugely helpful, so keep coming back to it as often as your boss will tolerate it.

Fourth

Start to study for the certification exams. Not those "cheater" aids, they're worthless if you really want to learn the material. Instead get the Microsoft study guides, and the self-paced learning kits for the exams. Don't worry if you don't know any of the answers at first, just study through them and learn the answers.

Finally

Simultaneously with four, above, start to follow the forums here, or at Ask.SqlServerCentral.com. Try to figure out the correct answer to each question (in "Administration") by using BOL and your SQL Server (try stuff out). If you cannot figure it out, don't worry, read the answer(s) in the thread and then try to implement them yourself. Read BOL and try to understand why it's the correct answer. If you don't understand why then ask questions.

Total article views: 16333 | Views in the last 30 days: 3
 
Related Articles
FORUM

70-445 Questions and answers

70-445 Questions and answers

FORUM

SQL Server Interview Questions And Answers

This Topic I want to initiate for SQL Server Interview Questions and Answers which people faces in t...

BLOG

Get Your SQL Server Questions Answered at ASK.SQLServerCentral.com

While the SQLServerCentral.com forums have always been a popular way to get your SQL Server questi...

BLOG

Answer - Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)

Question :-  How many non clustered indexes are possible in a table in SQL Server 2008R2 1) ...

BLOG

Answers To DBA Interview Questions

Here are your answers to the questions from last week You should get some variation of what I have ...

Tags
administration    
dba    
learning    
skills    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones