• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

Suggestion to buy good book

Hello Experts,
Please help me in buying good basic hands on MS SQL book.

I have come with below book name.
Microsoft SQL Server 2008 R2 Unleashed
SQL Server 2008 Query Performance Tuning Distilled
Please suggest your opinion.
It could be great if the book has steps by steps example with explanation.

acperkins: I like to get your suggestion.
3 Solutions
My personal suggestions are the following 2 books.

1. Beginning Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer)
2. Inside Microsoft® SQL Server® 2008: T-SQL Programming
I am looking for DBA carrer... so kindly suggest a book for DBA
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

SQL SERVER 2008 for dummies! It a good start from nothing to mid know...


Check the link!

Merry C.
You have lots of them. Check out them and the way you want to go. Most of them are like feature specific, but the first few will work out well. it will be better if you can specify particular area of expertise:-

Microsoft SQL Server 2000 by Kalen Delaney (though it is old, but I like it a lot).

SQL server 2008 administration in action by Rod Colledge

Microsoft SQL Server 2008 Management and Administration by Ross Mistry

Microsoft SQL Server 2008 Bible by Paul Nielsen

Beginning SQL Server 2008 Administration by Robert Walter, Grant Fritchey, Carmen Teqlienti

Professional Microsoft SQL Server 2008 Administration by Brian Knight, Ketan Patel, Wayne Snyder, Ross LoForte,  Steven Wort

Microsoft SQL Server 2005 Administrator's Companion by Edward Whalen, Marcilina Garcia, Burzin Patel, Stacia Misner, and Victor Isakov.

Professional SQL Server 2008 Internals and Troubleshooting By Christian Bolton, Justin langford, Brent Ozar, James Rowland-Jones, Steven Wort.

Microsoft SQL Server 2008 Internals by David Campbell

Note:- It will be good if you prepare for the certification exams. You can learn while preparing for test. The test materials for certificate preparation is good.
I like to concentrate on below chapter with very good query examples ,along with simple real time scenario
1.      locks mechanism
2.      Security Management
3.      Performance Tuning Troubleshooting steps & Issues
4.      Error Handling Measures
5.      Most known mistakes and resolution steps for those errors
6.      Distribution SQL database
7.      SQL profiler
8.      Configuring and managing SQL clustering
9.      SQL service broker and troubleshooting performances
10.      SQL architecture
11.      Concept of Virtual logs

I have order for the book "SQL Server 2008 Query Performance Tuning Distilled". Comments on this book.
Mark WillsTopic AdvisorCommented:
It is a good book.

I quite like Grant Fritchey's writing. While it is great for query performance (read that carefully), there is another companion book about server performance from a hardware perspective (and understanding what the hardware is about) : http://www.amazon.com/SQL-Server-Hardware-Glenn-Berry/dp/1906434638/ref=pd_sim_b_13

Both books were reviewed by Brent Ozar and you can see them online at amazon.com

And when you do look at those books, have a look at the companion packs. They normally group the "popular" buys together so you can see the best combo's that way.

For example one of Brent Ozar's own books : http://www.amazon.com/Professional-Server-2008-Internals-Troubleshooting/dp/0470484284/ref=pd_sim_b_6

The type of topics you have listed can get pretty involved pretty quickly. So, you will most likely find the need for a couple of other books along the way.

Have a look at some of those links from the other experts. They do give you some pretty good ideas.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now