Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Best SQL Server Book?

I have been a VB/VBA/Access developer for the past 4-5 years. Now, I'm getting ready to change jobs and work on a project that uses SQL Server 2000 as a backend.

I went to amazon.com to find a book so that I could start some self-teaching but was overwhelmed with the choices. Does anybody have a book that they think is the BEST SQL Server book? I need one that will take me through the basics.

Thanks! :o
Laurel
[444 byte] By [Laurel] at [2007-11-11 7:56:04]
# 1 Re: Best SQL Server Book?
This is a very subjective topic so you can always anticipate varying opinions. It also depends upon where your focus is. Developer? DBA?

Assuming your focus is from a developer's perspective and you haven't worked with SQL Server before, I've paired down the choices to the following:

Teach Yourself Microsoft SQL Server 2000 in 21 Days (http://www.amazon.com/gp/product/0672324695/sr=1-1/qid=1139160484/ref=sr_1_1/102-6531576-8613750?%5Fencoding=UTF8)
Professional SQL Server 2000 Programming (Programmer to Programmer) (http://www.amazon.com/gp/product/0764543792/sr=1-6/qid=1139160254/ref=sr_1_6/102-6531576-8613750?%5Fencoding=UTF8)
Murach's SQL for SQL Server (Paperback) (http://www.amazon.com/gp/product/1890774162/qid=1139160847/sr=1-3/ref=sr_1_3/102-6531576-8613750?s=books&v=glance&n=283155)

I would check here as well for more info:

http://www.windowsitpro.com/Article/ArticleID/14102/14102.html
pclement at 2007-11-11 23:47:25 >
# 2 Re: Best SQL Server Book?
If you'll be using VB for the front-end, I like Bill Vaughn's Hitchhiker's Guide to VB and SQL Server ( http://www.amazon.com/gp/product/1572318481/104-0779618-9671923) and ADO Examples and Best Practices ( http://www.amazon.com/gp/product/189311516X/104-0779618-9671923).
Phil Weber at 2007-11-11 23:48:27 >
# 3 Re: Best SQL Server Book?
SQL Server Bible is a good read - Covers both DBA + Programming topics.
SQL Server Programming by Example is ok to get you up to speed with T-SQL. The book is quite thick but it won't take you long to work your way through it - lots of space devoted/wasted with query output. For beginners it's a good place to start.
Wiseman82 at 2007-11-11 23:49:36 >
# 4 Re: Best SQL Server Book?
Thanks, guys!

Actually, my new boss said, "If you want to do some self-learning before you start, then can I suggest you look into SQL Server Database Administration." but I'll look into each of the books you suggested.

The reason I asked YOU guys is that I don't wanna waste a buncha money on crappy books and I just KNEW you'd know the best ones. :D
Laurel at 2007-11-11 23:50:32 >
# 5 Re: Best SQL Server Book?
I find www.amazon.com ( http://www.amazon.com) to be the best source of book reviews.
Wiseman82 at 2007-11-11 23:51:30 >
# 6 Re: Best SQL Server Book?
Wiseman,

As I stated in my original post, "I went to amazon.com to find a book so that I could start some self-teaching but was overwhelmed with the choices." *I* find the resources here (the other posters) to be the very BEST resources in the "biz"!

L
Laurel at 2007-11-11 23:52:29 >
# 7 Re: Best SQL Server Book?
Theres nothing wrong in asking for book suggestions on this forum. With amazon, when you have a large number of positive reviews for a book title (4/5*) you can be pretty confident that your making a good selection - reading some of the reviews can help you decide if it's the right book for you. It can be time consuming though especially if its a new subject and you dont know where to start - sometimes its better to ask recommendations from experts in the field. Theres nothing stopping you asking for recommendations on the forum and checking out the recommendations on amazon.
Wiseman82 at 2007-11-11 23:53:33 >
# 8 Re: Best SQL Server Book?
It can be time consuming though especially if its a new subject and you dont know where to start - sometimes its better to ask recommendations from experts in the field. Theres nothing stopping you asking for recommendations on the forum and checking out the recommendations on amazon.

....which is why I did both! :)
Laurel at 2007-11-11 23:54:33 >