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.
LVL 5
VIVEKANANDHAN_PERIASAMYAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

barletCommented:
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
0
VIVEKANANDHAN_PERIASAMYAuthor Commented:
I am looking for DBA carrer... so kindly suggest a book for DBA
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

http://www.dummies.com/store/product/Microsoft-SQL-Server-2008-For-Dummies.productCd-0470224657.html

Check the link!

Merry C.
Dalsom.
0
TempDBACommented:
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.
0
VIVEKANANDHAN_PERIASAMYAuthor Commented:
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.
0
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.