Admin Book - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Admin Book

Author

Topic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 11:25:41

What is the best book for SQL Server 2005 administration? For sql programming I assume the best book is professional sql server 2005 by Rob Viera.

I was not able to find a similar book for Administration. Any suggestions?

------------------------
I think, therefore I am - Rene Descartes

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-14 : 11:48:16

SQL 2005 Administrator's Companion seems pretty complete to me:
[url]http://www.amazon.com/Microsoft-Server-2005-Administrators-Companion/dp/0735621985[/url]

Other than that, if you want to take a look at some specific parts of SQL 2005, like Integration services, Notification Services etc. you will have to look for a specific book which satisfies your need.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 11:59:54

Thank you Harsh!

I followed the link. There is only one review for this book! Have you read this book? Is it par with INSIDE SQL SERVER 2000?

------------------------
I think, therefore I am - Rene Descartes

stephe40
Posting Yak Master

218 Posts

Posted - 2007-03-14 : 14:36:22

The only documentation you should need:

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

- Eric

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 14:48:05

That is a good reference material! You can not read BOL cover-2-cover. That will be too heavy , too much time consuming.

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-14 : 15:22:19

quote:
Originally posted by ravilobo

Thank you Harsh!

I followed the link. There is only one review for this book! Have you read this book? Is it par with INSIDE SQL SERVER 2000?

Kalen Delaney has the 2005 book out already:
http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735621055/ref=pd_bbs_sr_1/002-1838247-5031231?ie=UTF8&s=books&qid=1173900081&sr=8-1

Tara Kizer

http://weblogs.sqlteam.com/tarad/

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 15:33:02

I have read this link,

In SQL2K5 the INSIDE SQL SERVER series has been split into 4 books. Two of them have written by ITZIK BEN-GAN they are really good.

One is written by kalen, it is called INSIDE SQL SERVER STORAGE ENGINE. I am not sure whether this is a good book for a DBA.

Unfortunately there are lot of SQL2K5 books with GUI screen shots.

I need a book for administration par with INSIDE SQL SERVER 2000 or PROFESSIONAL SQL SERVER 2000 programming By Rob Vierra. Both are great books.

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-14 : 15:36:59

Inside Microsoft SQL Server 2005 Storage Engine is the 2005 version of Inside SQL Server 2000. Both are written by Kalen Delaney.

This is the book for DBAs!

Tara Kizer

http://weblogs.sqlteam.com/tarad/

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 15:47:34

Okay. Thank you Tara. I will go for it..

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-14 : 16:03:07

I just ordered mine today.

Tara Kizer

http://weblogs.sqlteam.com/tarad/

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 16:15:59

OKAY, I will hold my order for couple of days!
Once you get your copy , read 1-2 chapters and let me know if it is worth buying.

Did you find any other SQL2K5 good books?

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-14 : 16:22:30

I will not be providing a review of this book in the near future. I'm way too busy to do that. I don't need to read a single word from the new book to know that it's the best DBA book. I already know that since Kalen Delaney wrote this one and she also wrote the 2000 version.

I don't have any 2005 books right now. I've been using BOL and the Internet.

Tara Kizer

http://weblogs.sqlteam.com/tarad/

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 16:23:40

Tara, check the link http://www.amazon.com/gp/reader/0735621055/ref=sib_dp_pop_toc/102-8474142-1774555?ie=UTF8&p=S006#reader-link

The book is ONLY abot STORAGE, it doesn't talnk abot SSIS, SSRS, SSAS, service broker , administration.

This may be a good book for architecture but not for administration.

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-14 : 16:31:03

SSIS, SSRS, SSAS are not DBA things! As a DBA, you may be responsible for them but they are not consider database administration tasks.

And yes it is good for DBAs because the book deals with the architecture!

Perhaps you are confused as to what a DBA does.

Tara Kizer

http://weblogs.sqlteam.com/tarad/

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 16:46:08

I am currently attending lot of tech interviews for SQL2K5 DBA. I have been asked bout SSAS, SSRS, SSIS etc.

It is either I am confused or my interviewers are conused! ;-)

------------------------
I think, therefore I am - Rene Descartes

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-14 : 16:46:28

i got the Inside storage engine. It's amazing.
also for a dba you might want to get the query optimization and tuning.
it's also a good read.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-14 : 16:47:45

ravilobo, you're probably interviewing for a dba/dev position

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 16:51:57

Thats correct!
I think there are very few ONLY DBA openings! There is always a overlap..

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-14 : 16:54:15

Agreed that there will be some overlap. You've been asking what the best DBA book is for 2005 and I've told you. You should buy a 2005 development book if you're interested in develoment tasks such as SSIS, SSRS, or SSAS (this is probably a data warehouse task and not development task).

Tara Kizer

http://weblogs.sqlteam.com/tarad/

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-14 : 17:06:21

OKay!

One more question, (This is keeping in mind that Tara is a fan of
Kalen Delaney)

which is the SECOND BEST book for sql server 2005 administration?

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-14 : 17:17:39

quote:
Originally posted by ravilobo

which is the SECOND BEST book for sql server 2005 administration?

SQL Server Books Online

No other books are needed outside of Kalen's book and BOL for DBA stuff!

Tara Kizer

http://weblogs.sqlteam.com/tarad/

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources