On-line Reference Books for SQL DBA

Question

On-line Reference Books for SQL DBA

Victor Joseph Nishant

SSC Enthusiast

Points: 137
More actions
January 8, 2008 at 2:59 am

#119526

Hi,
I'm a new SQL DBA. I'm right now handling databases in both 2000 and 2005 versions. I would like to know how to get hold of good study or training material on the net which i can download and use as reference for my job role.
Also, just to set my expectations....I would like the study material to start off from scratch of SQL DB concepts and other administrative related topic.
Please let me know if you need further details regarding my role.
Thanks and Regards,
Victor.

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

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

Animal Magic SSChampion Points: 13964 More actions · Answer 1

Books on line is an excellent reference for all thing SQL. Online references your best bet are these forums, theres plenty out there (SQLTeam, SQL Server Performance etc) and of course here, where you will get more "real life" answers rather than the "this is how it should work theory stuff"

In terms of books for SQL 2000 "Inside Sql Server 2000; Karen Delaney" is an excellent book which is a good overview of everything except replication and also goes into detail on most subjects.

Victor Joseph Nishant SSC Enthusiast Points: 137 More actions · Answer 2

Hi,

Thank you for your reply. More than SQL 2000, i would like reference material for SQL 2005. Could you kindly help?

Thanks and Regards,

Victor.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

The 2005 books online are excellent, and I strongly recommend the Inside SQL Server 2005 series, from Solid Quality Learning.

First one (Storage engine) was written by Kalen Delaney

Next 2 (T-SQL Querying and T-SQL Programming) by Itzik Ben-Gan and others

Last one (Optimisation) by Kalen

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 4

Just so you know... Books Online comes with SQL...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 5

Here's a good article with recommendations you may want to look at:

http://www.sql-server-performance.com/articles/dba/self_taught_dba_p1.aspx

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management

Victor Joseph Nishant SSC Enthusiast Points: 137 More actions · Answer 6

Hi All,

Thank you all for your prompt replies. I will indeed check on all the reference links provided by all of you. I am indeed most grateful to each of you for your guidance.

Thanks and Regards,

Victor.

Simon E Doubt SSCarpal Tunnel Points: 4191 More actions · Answer 7

I also found Microsoft's "SQL Server 2005 Administrator's Companion" a great resource. Plenty of great information in there that spans the most important aspects of being a dba.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

The inside SQL Server series are books, not online resources. They are very worth buying though.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736445 More actions · Answer 9

Inside SQL Server is here: http://corporate.books24x7.com/home2.asp

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 10

I still think the admin training course is a good place to start - I'm imagining having the inside sql 2005 books on my desk along with my first experience of sql server - scary!!

I think as a whole sql server has now become such a wide product that starting from scratch must be very difficult. You might find some college courses ( part time/evening ) on more general rdbms technology and concepts.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 11

You're right Colin, the admin course is a good place to start. I took a 5-day SQL course (MS Course 2780B, Maintaining a Microsoft SQL Server 2005 Database) and coupled with all the stuff I was forced to learn on my own it helped immensely in understanding what I was doing and the full potential of the tools at my disposal.

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 12

Steve Jones - Editor (1/8/2008)

Inside SQL Server is here: http://corporate.books24x7.com/home2.asp%5B/quote%5D

Ooohhhhhh........ :hehe:

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass