Brad’s Sure Guide to SQL Server Maintenance Plans by Brad McGehee; Tony Davis

Brad’s Sure Guide to SQL Server Maintenance Plans by Brad McGehee; Tony Davis







Características do item

Estado: Bom :

Livro que não tem aparência nova e que já foi lido, mas está em bom estado. Dano mínimo na capa, incluindo marcas ou manchas de uso, mas sem rasgos ou orifícios. No caso de livros de capa dura, pode não incluir a sobrecapa. Desgaste mínimo da encadernação. A maioria das páginas não apresenta danos, há um mínimo de dobras ou desgaste, grifos ou sublinhados a lápis no texto, sem realce no texto, sem nada escrito nas margens. Nenhuma página faltando. Veja no anúncio do vendedor todos os detalhes do item e a descrição de quaisquer imperfeições. Ver todas as definições de estado– abre em uma janela ou guia separada

Notas do vendedor: A copy that has been read, but remains in clean condition. All pages are intact, and the cover is intact. The spine may show signs of wear. Pages can include limited notes and highlighting, and the copy can include previous owner inscriptions. At ThriftBooks, our motto is: Read More, Spend Less.

Estado do item: Bom Idioma: Inglês
Ano de publicação: 2010 Formato: Livro brochura
Peso: 0.91 lbs Encadernação: Paperback
Product Group: Book Author: Brad McGehee; Tony Davis
IsTextBook: No Editora: Simple Talk Publishing
ISBN:

9781906434342

EAN:

9781906434342

Brad’s Sure Guide to SQL Server Maintenance Plans by Brad McGehee; Tony Davis

Detalhes do produto

Synopsis
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.

Product Identifiers
ISBN-10 1906434344
ISBN-13 9781906434342
eBay Product ID (ePID) 166551847

Key Details
Author Brad McGehee, Tony Davis
Number Of Pages 281 pages
Format Paperback
Publication Date 2010-01-01
Language English
Publisher Simple Talk Publishing
Publication Year 2010

Additional Details
Copyright Date 2009
Illustrated Yes

Classification Method
Dewey Decimal 005.74
Dewey Edition 22



Price : 4.89

Ends on : Ended

View on eBay

Server Maintenance




Leave a Reply

Your email address will not be published.