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
Buy New
$23.37
Qty:1
  • List Price: $29.99
  • Save: $6.62 (22%)
FREE Shipping on orders over $35.
Only 4 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Brad's Sure Guide to SQL ... has been added to your Cart
Add to Cart
Trade in your item
Get a $0.63
Gift Card.
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"
$23.37
$18.15 $16.98

Frequently Bought Together

Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks) + SQL Server Tacklebox Essential Tools and Scripts for the Day-To-Day DBA + SQL Server Backup and Restore
Price for all three: $72.72

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: 9.2 x 6.1 x 0.6 inches
  • Shipping Weight: 14.4 ounces (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Best Sellers Rank: #1,741,561 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.8 out of 5 stars
5 star
0
4 star
6
3 star
2
2 star
0
1 star
0
See all 8 customer reviews
Share your thoughts with other customers

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 Ppg Dinesh Asanka on March 3, 2010
Format: Paperback
If you are a starter or developer who is looking at avenues to become a DBA, this book gives you lot of guidence. Though this book covers only on database maintaince task in SQL Server 2008, this book will cover the most of day-today tasks of a novice DBA.

This book not only describes about databases maintainance task options but also it covers basic concepts and good practices. Those are the valuable components of the book.

Why is I didn't this book for 5 stars will be the next question that you will ask. It is due to follwing reason.

1. Some times I feel there are few palces which are unnessary decribed which are not scope of this book. For example,database mail feature was over described.

2. It would have been better to have FAQ section where lot of people would have been benefitted. As this book targets for novice DBAs, FAQ chapter will help them to quickly find the answers to their hot topics,

3. Things likes, restoring of maintaince plans and backing up are not covered, which I think is a must.
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

Customer Images

Search

What Other Items Do Customers Buy After Viewing This Item?