Programming Books C Java PHP Python Learn more Browse Programming Books
Brad's Sure Guide to SQL Server Maintenance Plans and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $29.99
  • Save: $7.06 (24%)
FREE Shipping on orders over $35.
Only 2 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
+ $3.99 shipping
Used: Good | Details
Condition: Used: Good
Comment: **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence!
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks) Paperback – January 18, 2010


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$22.93
$18.15 $16.32


Frequently Bought Together

Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks) + Troubleshooting SQL Server - A Guide for the Accidental DBA + SQL Server Execution Plans
Price for all three: $73.92

Buy the selected items together
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle Edition for FREE. Print edition purchase must be sold by Amazon. Learn more.


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: DBA Handbooks
  • Paperback: 288 pages
  • Publisher: Red gate books (January 18, 2010)
  • Language: English
  • ISBN-10: 1906434344
  • ISBN-13: 978-1906434342
  • Product Dimensions: 6.1 x 0.6 x 9.2 inches
  • Shipping Weight: 14.4 ounces (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #1,385,967 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Brad McGehee is an Industry speaker, writer, and consultant on Microsoft SQL Server, specializing in SQL Server performance tuning, clustering, and high availability.He is now Director of DBA Education at Red Gate Software. Brad is a frequent speaker at SQL PASS, SQL Connections, SQL Server user groups, and other industry seminars, and he is the author or co-author of more than 12 technical books and over 100 published articles. He spends what time he has left with his family in Hawaii. He is a Microsoft SQL Server MVP, MCSE+I, MCSD, MCT.


More About the Author

Brad M. McGehee is a MCTS, MCSE+I, MCSD, and MCT (former) with a Bachelor's degree in Economics and a Masters in Business Administration. Brad was a Microsoft SQL Server MVP for 10 years, and has over 18 years SQL Server experience, over 9 years training experience, and has been involved in the IT since 1982.

Brad has been a frequent speaker at SQL PASS, European PASS, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL in the City, SQL Server user groups, webinars, and other industry seminars, where he shares his 18 years of cumulative knowledge and experience.

Since 2007, Brad has presented over 154 presentations to over 10,300 attendees in six different countries.

Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics.

Customer Reviews

3.7 out of 5 stars
5 star
0
4 star
6
3 star
3
2 star
0
1 star
0
See all 9 customer reviews
As a developer who sometimes looks after databases I found this somewhat useful.
A. J. Dixon
Each task the wizard can perform is well explained and there's lots of helpful screenshots to walk the reader through the process.
Mike M
Unless you mentor junior DBA's and you want them to read this book as a starting point.
Brian F. Simmons

Most Helpful Customer Reviews

1 of 1 people found the following review helpful By Mike M on May 11, 2010
Format: Paperback
Brad McGehee's latest book, "Brad's Sure Guide to SQL Server Maintenance Plans", is aimed squarely at inexperienced DBAs, but as there's a lack of starter administrative texts, this is definitely a good thing.

To give my SQL Server background - I have around 10 years development experience on the platform and am a Microsoft Certified IT Professional in SQL Server 2008 Development. However, my administration experience is limited, and I am what Brad would call an "accidental" DBA, i.e. I manage the servers alongside my other daily work.

My company has recently been upgrading its network, and this has involved the addition of more SQL Servers. As we're now starting to see lots of capacity coming through these servers, I decided it was high time I started maintaining the servers properly, and this book seemed like a good place to start.
Maintenance plans are essentially the "easy" way to manage SQL Servers. The book concentrates on the two methods used to create maintenance plans - the wizard and the designer.

The first half of the book is dedicated to the maintenance plan wizard. This is a useful tool that can create plans that run scheduled maintenance tasks. It does have some limitations, and Brad points these out throughout the book. Each task the wizard can perform is well explained and there's lots of helpful screenshots to walk the reader through the process. Crucially, Brad also highlights which tasks should not be performed using the wizard, which is great for those less experienced. The book continually states that if more control needs to be exerted over a particular task, PowerShell or custom T-SQL scripts should be used.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Kevin Languedoc on April 21, 2010
Format: Paperback
One of my peeves is verbose books on technology by publishing companies who assume to offer great value and content by over stuffing their books with a lot of superficial words and pages in my opinion.

A rule of thumb: LESS IS MORE.

If most IT professionals are like me, when I need answers, I don't want to be spending realms of my precious time shifting through endless pages of "page stuffing" to get the information I really need and want. Goodness knows that our project timelines are already too short and expectations are already off the chart.

So that being said, here is what I look for when I start to read a book on technology (How-Tos and Reference books alike), what is it about, what are the facts. This is what I like about "Brad's Sure Guide to SQL Server Maintenance Plan", he is giving me the facts and not the fluff.

For a guy like me who doesn't do a lot of administration, Brad gave me some great advice on how to maintain my databases with little effort. I think this is a must have book for developers who also do maintenance on database servers. I can't speak for DBAs because one I'm not. I didn't even know of some of the topics Brad's wrote about existed like the Maintenance Plans and the Maintenance Designer. He also showed me through his simple and clear examples how to use and write PowerShell scripts. I, like a lot of people in IT, have heard of PowerShell but haven't used it before.

Great job Brad
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Xuegang Huang on April 12, 2010
Format: Paperback
I heard about the author from the well-known "Brad's DBA checklist" on Simple-talk. Surely this book is a well-done job for Brad. Not a lot of people use the maintenance plan. But the book's content is quite enough to be used by those who do (or plan to) use this tool in daily work.

I like the book for these particular reasons.
1. The book describes the maintenance plan wizard and designer in a proper detailed level. It is kind of a "step-by-step" guide for the audience.

2. Brad also mentions a lot of good tips on what are the "must-do" or "must-not-do" things as the maintenance work. This is particular good for junior DBAs.

3. The overall language and presentation of the book is direct and clear. That's like a operational handbook for DBAs.

There are two things that I would like to add. First, one should be clear that maintenance plan can still be used in large organizations with TBs of data in databases. The reason is that there are plenty of "small" databases in such organizations and DBAs for different departments still have plenty of chances to use this tool. Second, I think the book can be a 5-star if a few (real life) case study can be included to make the readers more experienced after learning the basic steps and the technical comments.

All in all, this is an excellent book for DBAs in the early career life. I will suggest the book to my friends.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Michael Garrido on February 27, 2010
Format: Paperback
This book about database maintenance is a good book for a beginner or novice to the craft of maintaining SQL Server databases, maybe not the most exciting subject but too often overlooked when implementing a SQL server based system. Having a good maintenance plan is crucial as a DBA.
The book takes you step-by-step through how-to configure and set up the maintenance necessary, and explaining the differences in different settings. It also explains why some choices are better than others, not into great detail but in a good and easily understandable way.
I felt the book falls a little bit short on the more advanced stuff, so if you're an experienced SQL Server user, this book is not targeted for you. It has links to places for further reading, which was good but I'd liked little bit more on how to use system views and also some power shell scripts etc. I also miss a chapter about, system recovery that could give the reader additional insight to why the different parts of the maintenance plan is important, and also what to do if your production environment crashes and you have to start doing system recovery, but maybe that's not the scope of the book.
So, to wrap it up. This is a beginner's/novice book or a book to complement you additional SQL server literature, which takes you through the stuff you need to do to configure and maintain your SQL server environment.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

What Other Items Do Customers Buy After Viewing This Item?