Practical Maintenance Plans in SQL Server: Automation for the DBA
暫譯: SQL Server 實用維護計劃：DBA 的自動化解決方案

Bradley Beard

Practical Maintenance Plans in SQL Server: Automation for the DBA
  • 出版商: Apress
  • 出版日期: 2016-04-21
  • 定價: $1,330
  • 售價: 8.0 折 $1,064
  • 語言: 英文
  • 頁數: 272
  • 裝訂: Paperback
  • ISBN: 1484218949
  • ISBN-13: 9781484218945
  • 相關分類: MSSQL、SQL

    • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that’s it, but there is so much more that can and must be done to ensure the integrity of your most important company resource – the data you are tasked to manage and safeguard. This book walks even the newest of users through creating a powerful, automated maintenance plan.

Automate your job using SQL Server Agent to leverage the power of Maintenance Plans to deliver real, proactive solutions to common issues. Schedule common tasks such as backups and index rebuilds to run automatically, and get early-warning notifications of impending problems relating to resource usage and query performance. By the time your boss knows to call you about a problem, you’ll have already called him to describe your solution.

 

The large majority of books never really cover the topic of inheriting a database server with multiple live databases; the common thread is that the databases will be created and maintained by the reader forever and ever. In the real world, that scenario rarely happens. Practical Maintenance Plans in SQL Server covers that scenario and provides you with the knowledge and tools needed to get comfortable writing your own maintenance plans for any SQL Server database, whether created by you or inherited.

  • Shows the different tasks that can be run in a maintenance plan.
  • Explains how and why those tasks can be implemented.
  • Provides a roadmap to creating your own custom maintenance plan.

What You Will Learn
  • Implement a completely automated backup maintenance plan
  • Be alerted to performance problems and outages ahead of your boss
  • Learn the different types of database maintenance tasks
  • Plan the workflow of tasks within a maintenance plan
  • Automate your work by implementing custom maintenance plans
Who This Book Is For
 
Practical Maintenance Plans in SQL Server is for any level of database administrator, but specifically it’s for those administrators with a real need to set up a powerful maintenance plan quickly. New and seasoned administrators will appreciate the book for its robust learning pattern of visual aids in combination with explanations and scenarios. Practical Maintenance Plans in SQL Server is the perfect “new hire” gift for new database administrators in any organization.
 

商品描述(中文翻譯)

這本書是為 SQL Server 資料庫管理員設置和維護維護計劃的完整指南。維護計劃往往僅包含備份任務，但為了確保您最重要的公司資源——您負責管理和保護的數據的完整性，還有許多其他工作需要進行。本書將即使是最初學者的用戶也引導至創建一個強大、自動化的維護計劃。

利用 SQL Server Agent 自動化您的工作，利用維護計劃的力量提供針對常見問題的真正主動解決方案。安排常見任務，如備份和索引重建，自動運行，並提前獲得有關資源使用和查詢性能的潛在問題的警告通知。在您的上司知道需要聯繫您解決問題之前，您已經主動聯繫他，描述您的解決方案。

大多數書籍從未真正涵蓋繼承一個擁有多個活躍資料庫的資料庫伺服器的主題；共同的主題是這些資料庫將由讀者永遠創建和維護。在現實世界中，這種情況很少發生。《SQL Server 實用維護計劃》涵蓋了這種情況，並為您提供了撰寫任何 SQL Server 資料庫的維護計劃所需的知識和工具，無論是您自己創建的還是繼承的。

- 顯示可以在維護計劃中運行的不同任務。
- 解釋這些任務如何以及為什麼可以實施。
- 提供創建自定義維護計劃的路線圖。

您將學到什麼
- 實施完全自動化的備份維護計劃
- 在您的上司之前獲得性能問題和故障的警報
- 了解不同類型的資料庫維護任務
- 計劃維護計劃內任務的工作流程
- 通過實施自定義維護計劃來自動化您的工作

本書適合誰
《SQL Server 實用維護計劃》適合任何級別的資料庫管理員，但特別適合那些需要快速設置強大維護計劃的管理員。新手和資深管理員都會因為本書結合視覺輔助工具的強大學習模式以及解釋和情境而感到欣賞。《SQL Server 實用維護計劃》是任何組織中新資料庫管理員的完美“新員工”禮物。

類似商品