Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

SQL Server 2008 Administration in Action 1st Edition

4.5 out of 5 stars 23 customer reviews
ISBN-13: 978-1933988726
ISBN-10: 193398872X
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$18.94 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$36.09 On clicking this link, a new layer will be open
More Buying Choices
33 New from $22.59 35 Used from $4.43
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$36.09 FREE Shipping. Only 7 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • SQL Server 2008 Administration in Action
  • +
  • Microsoft SQL Server 2008 Management and Administration
Total price: $67.81
Buy the selected items together

Editorial Reviews

About the Author

Rod Colledge is an independent SQL Server consultant based in Brisbane, Australia. Since 1996, Rod has specialized in the development and administration of SQL Server database systems. His recent work has included the design and implementation of custom transactional replication and log shipping solutions, performance tuning large high-volume databases, and developing procedures for operational maintenance of large database systems. In September 2007, Rod founded sqlCrunch.com, a website specializing in summarizing and categorizing links to SQL Server white papers and best practices.

NO_CONTENT_IN_FEATURE

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Paperback: 468 pages
  • Publisher: Manning Publications; 1 edition (August 28, 2009)
  • Language: English
  • ISBN-10: 193398872X
  • ISBN-13: 978-1933988726
  • Product Dimensions: 7.4 x 1 x 9.2 inches
  • Shipping Weight: 1.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (23 customer reviews)
  • Amazon Best Sellers Rank: #798,142 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Denis Gobo on September 28, 2009
Format: Paperback
I will start by saying that I truly enjoyed this book. The book is written in a casual way and is not filled with tons of code, concepts are explained well and where needed images are included to help you understand it better. I also like the fact that this is not a 1000 page monster which weighs more than my laptop; it is 464 pages and fits nicely in my bag.

This book is filled with best practices and common sense. Each chapter ends with best practice consideration. The 3 page best practices considering security section in chapter 6 is something every SQL Server developer, administrator and especially an accidental DBA should memorize.

The suggested work plan for a DBA is something I needed for a long time; it is there all in one place broken down by daily, weekly and monthly tasks. Besides best practices I found that this book also has the top 25 DBA worst practices.....I guarantee that almost everyone will have a couple of items on that list; now you have a chance to eliminate some of those.

Things that were introduced in SQL Server 2008 are marked with <em>New In 2008</em>, this enables someone with previous experience to quickly jump to those section and focus on the new stuff. Most of the material in this book also applies to previous versions of SQL Server; if you are not on version 2008 yet but will be in a year or so then this is good way to get yourself familiar with the new stuff while implementing best practices for your current environment.

SQL Server administration is not just about SQL Server; you also need to know how the windows operating system itself works, what the different types of RAID are, what kind of memory to get etc etc.
Read more ›
Comment 13 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
If you're looking for a "how to" book, this is not it. Don't get me wrong, there are some step by step instructions scattered throughout the book, but that's not the goal. The goal is "how should I?" This book is designed for DBA's young and old who are trying to get a grasp on SQL Server 2008 or improve their understanding on how to best deploy it. The book succeeds admirably at that goal.

I've been working with SQL Server since 2001 (SQL 2000) and still picked up quite a bit from this book. I also recommend it to anyone who's just getting in to SQL 2008, has maybe just taken a course and is trying to figure out when best to apply [insert feature here].

It's a must have on ever DBA's bookshelf.
Comment 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
At last, someone willing to write an entire book dedicated to good principles and best practices! Not since SQL 2000 High Availability and Kalen Delaney's Inside SQL Server range have I carried a book under my arm everywhere I go like a faithful Jack Russell. Not only does this book hold a strong focus on 2008 but the best practices and thought processes can also easily apply to earlier versions. The book is presented in good physical order just like a clustered index and features a handy non-clustered index at the back for locating specific topics or buzzwords quickly. An unusually engaging read (for a technical book) that had me focussed for 2 days end to end....and I feel I'm definately a better database practitioner after reading this book.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book has some good usefull information that DBAs will be able to use. If it is not complete then it is leading in some good directions. As a SQL Server professional involved since 4.21a was released I found this a good resource for looking at, and learning more about, SQL Server 2008 features. It would be great if there were some updates for more information on the newer SQL Server 2008 R2.

I would have given it 5 stars except for the following:

Too many times I read 'beyond the scope of this book'. There could have been a little more depth added for some of the topics as the book isn't that big.

Used bamboozle badly. He disrespects the many DBAs trying to care about security and do something about it. These days a DBA isn't just involved with SQL. They are involved with virutalization, hardware, Storage, Network, Infrastructure, O/S, and the many different quirky software packages and badly designed databases and SQL code they have to support that they cannot change. Using such a term and so casually labeling DBAs as doing this shows a lack of experience and respect and just adds to what DBAs have to deal with.

I know this is a highly debated topic but it is a fact that many times these days a DBA has to know about more than SQL Server and wear more hats to get the job done. And most of the time it falls to the DBA to work on the security. A good example of this is one of the other books i bought on Amazon: Securing SQL Server: Protecting Your Database from Attackers .

I recommend the book for its good technical content and as a good read for what he covers. The accuracy also seems very good for the information presented.
I am enjoying reading the book and working through using the examples and code.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
The majority of my technical books fall into the skim and gather dust category. NOT THIS BOOK! This book strikes that rare balance of being readable, practical, and a bargain all at the same time.

Readability is high because of the transitions from subject to subject. There are no fantastic leaps of faith when it comes to explaining how things work. Everything builds on something previously said and College does a great job reminding the reader about material covered in earlier chapters. The pacing of the material is good and doesn't bog down in technical details. College also points out some excellent white papers for more in-depth knowledge.

The book is practical for the wealth of best practices listed throughout the book. I don't know how many times I had those "ohhh, I wish I knew this back then" type moments. In addition to the best practices, College clearly explains the multitude of SQL Server settings in a responsible DBA fashion. Meaning, while a feature *might* improve performance you still have to consider the overhead. Good stuff.

Finally, this book is a bargain because it includes a free ebook version. I did the majority of the code examples and they all worked!

Insofar as any omissions and errors, I would have liked to have seen some coverage on troubleshooting a virtual sql server instance. Also, the link to the stored procedure, track_waitstats_2005, doesn't work properly. However, these things don't detract at all from the excellence of this book.
Comment 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

SQL Server 2008 Administration in Action
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: SQL Server 2008 Administration in Action