0
Your cart

Your cart is empty

Books > Computing & IT > Computer software packages > Database software

Buy Now

Brad's Sure Guide to SQL Server Maintenance Plans (Paperback) Loot Price: R652
Discovery Miles 6 520
You Save: R84 (11%)
Brad's Sure Guide to SQL Server Maintenance Plans (Paperback): Brad M. McGehee

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

Brad M. McGehee

Series: DBA Handbooks

 (sign in to rate)
List price R736 Loot Price R652 Discovery Miles 6 520 | Repayment Terms: R61 pm x 12* You Save R84 (11%)

Bookmark and Share

Expected to ship within 10 - 15 working days

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.

General

Imprint: Red Gate Books
Country of origin: United Kingdom
Series: DBA Handbooks
Release date: February 2010
First published: 2010
Authors: Brad M. McGehee
Dimensions: 156 x 234 x 15mm (L x W x T)
Format: Paperback - Trade
Pages: 290
ISBN-13: 978-1-906434-34-2
Categories: Books > Computing & IT > Computer software packages > Database software > General
Promotions
LSN: 1-906434-34-4
Barcode: 9781906434342

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!

You might also like..

Oracle 12c - SQL
Joan Casteel Paperback  (1)
R1,406 R1,302 Discovery Miles 13 020
A Guide To SQL
Philip Pratt, Hassan Afyouni, … Paperback R1,336 R1,236 Discovery Miles 12 360
Intermediate Access
M. L. Humphrey Hardcover R563 Discovery Miles 5 630
Database Systems: The Complete Book…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R2,189 R1,762 Discovery Miles 17 620
Librarian's Guide to Online Searching…
Christopher C Brown Hardcover R3,124 Discovery Miles 31 240
Enterprise Big Data Engineering…
Martin Atzmueller, Samia Oussena, … Hardcover R5,590 Discovery Miles 55 900
SQL Programming: Java Script and Coding…
Os Swift Hardcover R852 Discovery Miles 8 520
Access 2019 Beginner
M. L. Humphrey Hardcover R653 Discovery Miles 6 530
Amazon DynamoDB Encryption Client…
Documentation Team Hardcover R941 Discovery Miles 9 410
Joe Celko's Data, Measurements and…
Joe Celko Paperback R1,150 Discovery Miles 11 500
Promethean Oracle
Sophia Shultz, Mark Cogan Miscellaneous printed matter R1,034 R823 Discovery Miles 8 230
SQL: 1999 - Understanding Relational…
Jim Melton, Alan R. Simon Paperback R2,102 R1,560 Discovery Miles 15 600

See more

Partners