Want to be a real DB.

Question

Want to be a real DB.

Paul Hoang

SSC Rookie

Points: 45
More actions
July 12, 2005 at 12:03 pm

#88104

Hello Everyone,
I used to support servers, now I have a chance to work on DB career. Know a little of SQL 2000, IIS. I need your expertie, what should I start to learn, or book that I can study to become a real DB.
Thank you all.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

First thing would be the job name : it's called DBA (administrator). Books recommendations shall follow from other users .

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 2

Start with MS Inside SQL Server 2000.

Other books to read: Sit at local bookstore. Grab books about SQL. Whichever ones don't put you to sleep and hold your interest buy.

Good Hunting!

AJ Ahrens

webmaster@kritter.net

philcart SSC-Forever Points: 47794 More actions · Answer 3

And don't forget our ever reliable friend Books Online

--------------------
Colt 45 - the original point and click interface

Matt DeWitt SSC Rookie Points: 39 More actions · Answer 4

Ken Henderson wrote some excellent SQL Guru books. Find them and live by them.

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 5

There are some articles here as well on DBAs

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

Paul Hoang SSC Rookie Points: 45 More actions · Answer 6

I like to thank you all for support, information, and couraged.

You all are the best of the best.

Paul.

SQLBill SSC Guru Points: 51440 More actions · Answer 7

Paul,

You can get the MS SQL Server Books On Line from this MS website:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

TinaW SSC-Addicted Points: 456 More actions · Answer 8

When I was first starting my career as a DBA the two books that I thought were the most useful in a practical sense were:

SQL Server 2000 Fast Answers for DBAs and Developers

by Joseph Sack

Microsoft SQL Server 2000 Unleashed (2nd Edition) by Ray Rankins, et al.

Kindest Regards,

TW

Greg Charles SSC-Forever Points: 45403 More actions · Answer 9

Also, to be a "real DBA", you have to get some experience in addition to reading.

Greg

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 10

In addition to what everyone has suggested (and the experience thing is the biggest and most important), I'd add the book: Database Administration by Craig S. Mullins. It's not specific to any platform or DBMS, but instead concentrates on what's needed to establish a database administrator and DBA team, knowledge, processes, best practices, sources of information, etc. It's a good read and very informative.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jhklink Mr or Mrs. 500 Points: 582 More actions · Answer 11

I personally would advise you into reading the SQL Bible by Alex Kriegel. It covers more than the standard "Microsoft" covered material. It encompases Microsoft, Oracle, DB2, Sybase and some other smaller database softwre.

It will make you a more rounded DBA...unless you WANT to look at the world only through the "Microsoft" point of view.