SQL Server 2008 Administration in Action [Paperback]

Rod Colledge (Author)

Book Description

Publication Date: August 28, 2009 | ISBN-10: 193398872X | ISBN-13: 978-1933988726 | Edition: 1

SQL Server 2008 Administration isn't a standard SQL Server tutorial-there are dozens of those to choose from. Instead, this book breaks down the role of "SQL Server Administrator" into its key focus areas and tasks and details the techniques and best practices that make an administrator effective. In this book, a reader can quickly identify a task and find the best practice associated with it. For example, a reader looking for information about indexing would find step-by-step procedures for identifying and dropping unused indexes, creating missing indexes, selecting the appropriate clustered index, and so forth.

Each technique is presented in a clear, straightforward style and in the order of the typical lifecycle of a SQL Server system. This allows a reader to easily open the book at the appropriate page and focus on what you need to know for each specific situation.

While most techniques will work for all versions of SQL Server, this book is current for the recent final release of SQL Server 2008.

Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

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.

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 (21 customer reviews)
• Amazon Best Sellers Rank: #282,631 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Most Helpful Customer Reviews

11 of 11 people found the following review helpful

5.0 out of 5 stars Loved this book September 28, 2009

By Denis Gobo

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. reading SQL Server 2008 Administration in Action does a good job explaining all these things, there are links to resources where you can find more detail about a particular subject and there are also links to tools that might be helpful creating the optimal server for your SQL Server installation

I would recommend this book to anyone who has to manage SQL Server, it doesn't matter if the machines are already up and running or if you still have to install everything. The people who will benefit the most from this book are the accidental DBAs; these are the people who never managed a server before but because the company decided to downsize they became the DBA and it is only a matter of time before something happens.

The material in this book will make your job easier; it will make you a better administrator and why not invest in yourself by getting this book?

6 of 6 people found the following review helpful

5.0 out of 5 stars "Code Complete" for SQL Server Administration November 7, 2009

By C. Harrison

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.

5 of 5 people found the following review helpful

5.0 out of 5 stars Practioners Guide August 25, 2009

By Peter J. O'Gorman

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.