Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks)

3.5 avg rating
( 8 ratings by Goodreads )
 
9781906434342: Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks)
View all copies of this ISBN edition:
 
 

In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer. Table of Contents * Chapter 01: Why is Database Maintenance Important? Chapter 02: Before you Create any Maintenance Plans Chapter 03: Getting Started with the Maintenance Plan Wizard Chapter 04: Task Scheduling Chapter 05: Check database Integrity Task Chapter 06: Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08: Reorganize Index Task Chapter 09: Update Statistics Task Chapter 10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup Task Chapter 12: Define Back Up Database (Full) Task Chapter 13: Define Back Up Database (Differential) Task Chapter 14: Back Up Database (Transaction Log) Task Chapter 15: Maintenance Cleanup Task Chapter 16: Using the Maintenance Plan Designer Why read this book? Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don't have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly. The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering: * The intent of each task and why it's important * How to configure each task and what all the options mean * Scheduling considerations: when and how often should you run the task? * Customizing and extended your Maintenance Plans using the Designer Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA. At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate.

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.

Buy New View Book
List Price: US$ 29.99
US$ 20.18

Convert currency

Shipping: FREE
From United Kingdom to U.S.A.

Destination, rates & speeds

Add to Basket

Top Search Results from the AbeBooks Marketplace

1.

Brad M. McGehee
Published by Red Gate Books, United Kingdom (2010)
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Paperback Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Red Gate Books, United Kingdom, 2010. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****.In his new book, Brad s Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a required minimum level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer. Table of Contents * Chapter 01: Why is Database Maintenance Important? Chapter 02: Before you Create any Maintenance Plans Chapter 03: Getting Started with the Maintenance Plan Wizard Chapter 04: Task Scheduling Chapter 05: Check database Integrity Task Chapter 06: Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08: Reorganize Index Task Chapter 09: Update Statistics Task Chapter 10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup Task Chapter 12: Define Back Up Database (Full) Task Chapter 13: Define Back Up Database (Differential) Task Chapter 14: Back Up Database (Transaction Log) Task Chapter 15: Maintenance Cleanup Task Chapter 16: Using the Maintenance Plan Designer Why read this book? Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many accidental DBAs out there whose job it is to maintain them. Often, they find that they don t have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly. The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering: * The intent of each task and why it s important * How to configure each task and what all the options mean * Scheduling considerations: when and how often should you run the task? * Customizing and extended your Maintenance Plans using the Designer Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA. At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate. Seller Inventory # AAV9781906434342

More information about this seller | Contact this seller

Buy New
US$ 20.18
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

2.

Brad M. McGehee
Published by Red Gate Books, United Kingdom (2010)
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Paperback Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Red Gate Books, United Kingdom, 2010. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****. In his new book, Brad s Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a required minimum level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer. Table of Contents * Chapter 01: Why is Database Maintenance Important? Chapter 02: Before you Create any Maintenance Plans Chapter 03: Getting Started with the Maintenance Plan Wizard Chapter 04: Task Scheduling Chapter 05: Check database Integrity Task Chapter 06: Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08: Reorganize Index Task Chapter 09: Update Statistics Task Chapter 10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup Task Chapter 12: Define Back Up Database (Full) Task Chapter 13: Define Back Up Database (Differential) Task Chapter 14: Back Up Database (Transaction Log) Task Chapter 15: Maintenance Cleanup Task Chapter 16: Using the Maintenance Plan Designer Why read this book? Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many accidental DBAs out there whose job it is to maintain them. Often, they find that they don t have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly. The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering: * The intent of each task and why it s important * How to configure each task and what all the options mean * Scheduling considerations: when and how often should you run the task? * Customizing and extended your Maintenance Plans using the Designer Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA. At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate. Seller Inventory # AAV9781906434342

More information about this seller | Contact this seller

Buy New
US$ 21.38
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Brad M. McGehee
Published by Red Gate Books (2010)
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Red Gate Books, 2010. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781906434342

More information about this seller | Contact this seller

Buy New
US$ 17.40
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

4.

McGehee, Brad M.
Published by Red gate books
ISBN 10: 1906434344 ISBN 13: 9781906434342
New PAPERBACK Quantity Available: 15
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)
Rating
[?]

Book Description Red gate books. PAPERBACK. Condition: New. 1906434344 BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|0.91. Seller Inventory # OTF-Y-9781906434342

More information about this seller | Contact this seller

Buy New
US$ 19.13
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

5.

McGehee, Brad M.
Published by Red Gate Books 1/18/2010 (2010)
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Paperback or Softback Quantity Available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Red Gate Books 1/18/2010, 2010. Paperback or Softback. Condition: New. Brad's Sure Guide to SQL Server Maintenance Plans. Book. Seller Inventory # BBS-9781906434342

More information about this seller | Contact this seller

Buy New
US$ 23.17
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

6.

Brad M. McGehee
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Quantity Available: 5
Seller:
ReadWhiz
(Portland, OR, U.S.A.)
Rating
[?]

Book Description Condition: New. Seller Inventory # ria9781906434342_ing

More information about this seller | Contact this seller

Buy New
US$ 26.05
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

McGehee, Brad M
Published by Red gate books (2010)
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Paperback Quantity Available: 10
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Red gate books, 2010. Paperback. Condition: New. Seller Inventory # INGM9781906434342

More information about this seller | Contact this seller

Buy New
US$ 22.76
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

8.

Brad M. McGehee
Published by Red gate books (2010)
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Softcover Quantity Available: 1
Print on Demand
Seller:
Rating
[?]

Book Description Red gate books, 2010. Condition: New. This item is printed on demand for shipment within 3 working days. Seller Inventory # GM9781906434342

More information about this seller | Contact this seller

Buy New
US$ 23.95
Convert currency

Add to Basket

Shipping: US$ 3.51
From Germany to U.S.A.
Destination, rates & speeds

9.

Brad M. McGehee
Published by Red Gate Books (2010)
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Red Gate Books, 2010. PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # LQ-9781906434342

More information about this seller | Contact this seller

Buy New
US$ 16.19
Convert currency

Add to Basket

Shipping: US$ 11.75
From United Kingdom to U.S.A.
Destination, rates & speeds

10.

Brad McGehee
Published by Red Gate Books
ISBN 10: 1906434344 ISBN 13: 9781906434342
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description Red Gate Books. Paperback. Condition: New. In his new book, Brads Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a required minimum level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781906434342

More information about this seller | Contact this seller

Buy New
US$ 28.21
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book