Good Book for SQL Developer

Question

Post reply

Good Book for SQL Developer

Yelena Varshal

SSC-Dedicated

Points: 34286
More actions
December 14, 2004 at 4:12 pm

#59752

Hello,
What is your opinion on the best book on SQL Server Development? (not Administration)
Would it be "Inside Microsoft SQL Server 2000" ? Someone I know needs to cover different areas from TSQL to DTS to good database application design. Level - medium to high, he is already supporting SQL Server and applications for several years and was supporting other RDBMS apps before that, but wants to know more.
Yelena

Regards,Yelena Varsha

Viewing 15 posts - 1 through 15 (of 17 total)

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

TriggerMe SSChampion Points: 11752 More actions · Answer 1

Try "Profesional SQL Server 2000 Programming" from Wrox.

Kindest Regards,

Chris McGuigan SSC Veteran Points: 210 More actions · Answer 2

I agree!

"Professional SQL Server 2000 Programming" from Wrox has been invaluable to me.

Regards

Chris

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

If this Wrox book is that by Louis Davidson, I would have a close look at in the book shop first. One might think different on it.

For me, I really love the Ken Henderson Guru's stuff. Kalen Delaney is always a must-have. Apart from this, you'll find that good book are rare.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Chris McGuigan SSC Veteran Points: 210 More actions · Answer 4

The Wrox book I'm on about is by Robert Vieira.

As a rule I tend to go with O'Reilly books, but the Wrox one was at my work already and I've not found a need to find another one.

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

I use..

Inside SQL Server 2000 (MS Press)

Mastering SQL Server (Sybex)

SQL Server 2000 The Complete Reference (Database Professional's Library)

Each of these has a different and better feel/read on different subjects which is why I have the 3. 1 is good for day-day, 1 for OLAP, 1 for odd ball stuff.

I would sit down in the book store and read different chapters from a bunch of the different books and pick the ones that you like to read.

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Scott Arendt SSCrazy Eights Points: 8218 More actions · Answer 6

The Wrox book by Viera is the one I use. I chose it because of recommendations and wasn't disappointed.

Regards,

Scott

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 7

Hello,

Thanks to all for the advices, highly appreciated.

I myself read "Inside Microsoft SQL Server 7" by Ron Soukup and Kalen Delaney when it came out, I had a good 6.5 book before that, but I did not read Kalen's 2000 version of the book. I took SQL 2000 Microsoft class and was somewhat dissappointed because I expected more of the new and complicated stuff in the class versus generic knowledge, but maybe it was just my wishful expectations. I read Microsoft training materials for 70-029 and 70-229, they were OK.

I also found very good chapters on the Relational theory in one of the Microsoft Access books that someone loaned me years ago, don't rememmber the title of the book. I found a lot of helpful theretical topics on database application architechture in the Microsoft training materials when preparing to the exam "70-300 Analyzing Requirements and Defining Microsoft .NET Solution Architectures " For example a good whatie paper by Terry Halpin "Object-Role Modeling (ORM-NIAM) I use mostly BOL myself, but in this case I needed some systematically organized reading with good overview of the features for someone.

Yelena

Regards,Yelena Varsha

Frank Kalis SSC Guru Points: 111183 More actions · Answer 8

Hm, wasn't aware that you're also looking for books on the theory behind. For this topic, you might want to google for books by Jim Melton, Chris Date et al. But that's rather academical stuff at times. However, always good to read when you can't get to sleep.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 9

Frank,

Yes, you are right. I was not looking for the theoretical books in my initial request because it was not for me.

But I myself and someone else I know will certainly read the books you recommended. I am heavily in theory and architecture on one end and administartion on the other end (if you can believe it) leaving the actual development that comes in between to others. Or at least trying to do that. I do some VB and WMI development instead.

Yelena

Regards,Yelena Varsha

Markus Lofstrom SSC Rookie Points: 35 More actions · Answer 10

I have looked at dozens of T-SQL books and few are really great. Here's my list:

Professional SQL Server 2000 Programming by Robert Vieira

The Guru's Guide to Transact-SQL by Ken Henderson

SQL Puzzles & Answers by Joe Celko

A few others have useful sections. My focus is on T-SQL development, of course. Not so much admin or theory or "inside."

Thanks,

Markus Lofstrom

herb walles Say Hey Kid Points: 692 More actions · Answer 11

I really like this book.

http://www.bookpool.com/.x/3b9ypa4by8/sm/1893115828

Pretty good book for the programmers who want to move toward more advanced stuff

Joseph Ackerman SSC-Addicted Points: 438 More actions · Answer 12

Yelena,

I agree with previous posters regarding the Viera book from Wrox. It got me up to speed quickly and did a good job of explaining the what, how and why of developing working applications on SQL Server.

Dave-3000 SSCertifiable Points: 6186 More actions · Answer 13

I agree with Herb on Advanced T-SQL for SQL Server 2000:

"http://www.bookpool.com/.x/3b9ypa4by8/sm/1893115828

Ken Henderson's "Guru" books are also very helpful. Inside SQL Server 2000 gives good explanations on what is happening under the covers. Sometimes that's what you need to figure out that SQL Server is really doing what you told it to do, and you shouldn't have done that!

There is no "i" in team, but idiot has two.

Ashish Doshi SSC Enthusiast Points: 163 More actions · Answer 14

Always used BOL...

Nothing else required for SQL Server....