Looking for a book on SQL Server that doesn't suck
In the spirit of being a developer and not a programmer ( http://software.ericsink.com/No_Programmers.html ), I'm finding myself doing lots of non-.net-programming things at my new job at a small startup. One of those things is managing the development SQL Server database, and writing stored procedures and stuff like that. I found a lot of good, basic info on a number of different web sites, and of course I can ask the senior developer here some of my questions.
I agree with inside SQL2000.
I use SQL Server 2000 Programming by Robert Vieira. Lots of good examples, and he explains when to use certain techniques. It doesn't really delve into the admin side of things too much, as it's designed for programmers. ie - if you want to learn performance tuning, look elsewhere.
>>My only complaint is his picture is on the front, the spine, >>and the back. It's kinda unnerving.
Inside Sql Server 2000
I can't recommend an MS SQL specific book, but for general SQL, the best book I've ever seen is "SQL For Smarties".
Brad Wilson (dotnetguy.techieswithcats.com)
SQL for Smarties by Joe Celko will teach you to think in sets. Inside SQL Server 2000 by Karen Delaney will teach you how the server works internally. The Guru's Guide to Transact-SQL by Ken Henderson (or one of his two other Guru books) will teach you how to write stored procedures, as well as plenty of other useful things.
Another recommendation for Delaney's Inside SQL Server 2000. Her books on SQL Server 7 and 2000 are probably some of the most informative and detailed books on SQL Server out there.
I was wondering if I should mention Smartie's, kudos to Brad
Both of Henderson's "Guru's Guide..." are very good.
"Inside SQL Server 2000 by Karen Delaney"
imnkd (I am not Kalen Delaney)
Fog Creek Home