- 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: 23 customer reviews
- Amazon Best Sellers Rank: #1,784,946 in Books (See Top 100 in Books)
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.
To get the free app, enter your mobile phone number.
SQL Server 2008 Administration in Action 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Customers who viewed this item also viewed
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.
Showing 1-8 of 23 reviews
There was a problem filtering reviews right now. Please try again later.
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.
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.
As has been mentioned in other reviews, this book is not going to teach you how to code the syntax, and it is not going to get you from zero knowledge to certification. Unless you are a very experienced DBA, you are familiar with the features that your job requires, and maybe a few more. If you suddenly need to pick up soemthing new, this book is very useful. Also, while SQL Server 2008 has been out for barely a year and a half as I write this, not many shops have done a lot with it yet. So you can get up to speed quickly, instead of using 2008 just like you did with 2005, or even 2000. And in this day on 'getting more done with less', the book is a good way of getting your skills up-to-date.
I wonder if Mr. Colledge is working on a 2012 version of the book!