Need advice for new DBA

Hi All, I'm working as a S/W support engineer. I would like to become a SQL DBA. I'v worked with Back-Up/Restore, DTS, Creating Databases in sql 2000 server. I'm planing to join SQL Server 2008 courses & certification. Pls advice on this.

more ▼

asked Jan 08, 2010 at 01:12 PM in Default

Sasikumar gravatar image

21 1 1 1

(comments are locked)
10|1200 characters needed characters left

8 answers: sort voted first


Read books, blogs, magazines, Books OnLine, and everywhere else. Immerse yourself in it.

First though...

Ask yourself a few questions.

Why does SQL interest you?
What aspects of SQL have you curious?
Are you really good at problem solving?
Are you a self-starter?
Can you keep a lot of acronyms straight?
Do you have any O/S background?
What is your programming background?
Are you a capable VBscripter or PowerShell coder?
Are you responsible and ethical?
Can you serve many masters (with a smile)?
Can you explain obscure technical concepts in plain language?
Are you prepared to entertain a liftime of learning?
How are your math skills?
Do you roll up your sleeves and dig deep?
Do you see operations, data warehousing, application, or achitecting as your support role?

The big thing is to be sure that this is the path you want to follow and not a flavour-of-the-month pursuit. If you try you may find that it becomes incredibly rewarding, but it isn't for everybody. Sometimes the expectations will not match reality - be prepared for that.

Certification is a "nice to have" but it depends on your organization... and if you intend to stay there. As long as you approach certification as an I'm doing this for me instead of an I want a piece of paper exercise you are on your way. For me the knowledge and inner workings has always come first, the certification is just a nice by-product.

more ▼

answered Jan 08, 2010 at 02:11 PM

Blackhawk-17 gravatar image

11.9k 28 31 37

I agree with everything you said, but also remember that there are organizations that want you to have that piece of paper.
Jan 08, 2010 at 02:13 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left

Brent Ozar has some good pointers on his site and here, as does Brad McGehee on his site

more ▼

answered Jan 08, 2010 at 01:25 PM

Kev Riley gravatar image

Kev Riley ♦♦
54.3k 47 49 76

(comments are locked)
10|1200 characters needed characters left

I second both Matt's and Kev's suggestions, those are some very good places to read. But there are a couple of things I think are worth emphasizing.

First, be careful about what courses you take. Some are certainly very good, but I think most of them are a waste of money. You are better off if you can find an experienced DBA to mentor you, but even if you can't a combination of reading books, reading internet articles (both http://www.sqlservercentral.com and http://www.simple-talk.com are fantastic), and most importantly testing things on your own is much better and much cheaper than taking a course.

Second, you probably will and should focus first on the practical aspects of learning how to use SQL such as learning actual T-SQL, SSMS, SSIS etc, but if you want to be good you should eventually go back and learn the theoretical underpinnings as well. It can be useful to know how the indexes work behind the scenes at times and even if you do not normalize to 3NF it is good to know what it is and how to do it if you need to.

And finally, learning another scripting language in addition to T-SQL can be very helpful. I am a big fan of Python (including IronPython) personally, but PowerShell is also popular and there are also many other fine choices. As an administrator, there are advantages to having a good scripting language handy.

more ▼

answered Jan 08, 2010 at 02:12 PM

TimothyAWiseman gravatar image

15.6k 21 23 32

(comments are locked)
10|1200 characters needed characters left

You should read the answers to this question.

more ▼

answered Jan 08, 2010 at 01:23 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

(comments are locked)
10|1200 characters needed characters left

..and apart from reading from the exellent sources suggested, install your own copy of SQL Server express, or the eval version, so that you can play around with it and test the things you read about. Atleast for me that helps with remembering what I read.

more ▼

answered Jan 11, 2010 at 06:26 AM

Steinar gravatar image

1.7k 3 4 6

I think its worth paying for the developer eddition, especially if you have the enterprise eddition at work, but I fully agree with the concept.
Jan 13, 2010 at 08:39 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 08, 2010 at 01:12 PM

Seen: 1996 times

Last Updated: Jan 08, 2010 at 01:12 PM