Learn dbatools in a Month of Lunches: Automating SQL server tasks with PowerShell commands (Paperback)

Lemaire, Chrissy, Sewell, Rob, Silva, Cláudio

  • 出版商: Manning
  • 出版日期: 2022-07-07
  • 定價: $2,160
  • 售價: 9.5$2,052
  • 語言: 英文
  • 頁數: 400
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1617296708
  • ISBN-13: 9781617296703
  • 相關分類: MSSQLPowershellSQL
  • 立即出貨 (庫存 < 3)




If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine--all in just one month!

In Learn dbatools in a Month of Lunches you will learn how to:

Perform instance-to-instance and customized migrations
Automate security audits, tempdb configuration, alerting, and reporting
Schedule and monitor PowerShell tasks in SQL Server Agent
Bulk-import any type of data into SQL Server
Install dbatools in secure environments

Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective--and efficient--than you ever thought possible. In twenty-eight lunchbreak lessons, you'll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

About the technology
For SQL Server DBAs, automation is the key to efficiency. Using the open-source dbatools PowerShell module, you can easily execute tasks on thousands of database servers at once--all from the command line. dbatools gives you over 500 pre-built commands, with countless new options for managing SQL Server at scale. There's nothing else like it.

About the book
Learn dbatools in a Month of Lunches teaches you how to automate SQL Server using the dbatools PowerShell module. Each 30-minute lesson introduces a new automation that will make your daily duties easier. Following the expert advice of dbatools creator Chrissy LeMaire and other top community contributors, you'll learn to script everything from backups to disaster recovery.

What's inside

Performing instance-to-instance and customized migrations
Automating security audits, best practices, and standardized configurations
Administering SQL Server Agent including running PowerShell scripts effectively
Bulk-importing many types of data into SQL Server
Executing advanced tasks and increasing efficiency for everyday administration

About the reader
For DBAs, accidental DBAs, and systems engineers who manage SQL Server.

About the author
Chrissy LeMaire is a GitHub Star and the creator of dbatools. Rob Sewell is a data engineer and a passionate automator. Jess Pomfret and Cláudio Silva are data platform architects. All are Microsoft MVPs.

Table of Contents
1 Before you begin
2 Installing dbatools
3 The dbatools lab
4 A gentle introduction to dbatools commands
5 Writing to SQL Server
6 Finding SQL Server instances on your network
7 Inventorying your SQL estate
8 Registered Servers
9 Logins and users
10 Backups
11 Restore
12 Snapshots
13 Install and update SQL Server
14 Preparing for disaster
15 Performing your first advanced SQL Server instance migration, part 1
16 Performing your first advanced SQL Server instance migration, part 2
17 High availability and disaster recovery
18 PowerShell and SQL Server Agent
19 SQL Server Agent administration
20 Creating and working with SQL Server Agent objects
21 Data masking
22 DevOps automation
23 Tracing SQL Server activity
24 Security and encryption
25 Data compression
26 Validating your estate with dbachecks
27 Working in the cloud
28 dbatools configurations and logging
29 Never the end


如果你使用 SQL Server,dbatools 是一個救星。這本書將向你展示如何使用這個免費且開源的 PowerShell 模組來自動化幾乎所有你能想像到的 SQL Server 任務 - 只需一個月的時間!

在《一個月的午餐學習 dbatools》中,你將學習到以下技巧:

- 執行實例到實例和自定義遷移
- 自動化安全審核、tempdb 配置、警報和報告
- 在 SQL Server Agent 中安排和監控 PowerShell 任務
- 將任何類型的數據批量導入 SQL Server
- 在安全環境中安裝 dbatools

這本書由一群專家作者撰寫,包括 dbatools 的創建者 Chrissy LeMaire。《一個月的午餐學習 dbatools》教授你一些技巧,讓你比你想像的更有效率和高效。在二十八個午餐時間的課程中,你將學習到 dbatools 的最重要用例和其核心開發人員最喜歡的功能。通過使用這個強大的工具來穩定和標準化你的 SQL Server 環境,並通過構建自動化、警報和報告來簡化你的任務。

購買印刷版書籍還包括 Manning Publications 提供的 PDF、Kindle 和 ePub 格式的免費電子書。

對於 SQL Server DBA 來說,自動化是提高效率的關鍵。使用開源的 dbatools PowerShell 模組,你可以輕鬆地從命令行在數千個數據庫服務器上執行任務。dbatools 提供了超過 500 個預建命令,以及無數用於大規模管理 SQL Server 的新選項。沒有其他類似的工具。

《一個月的午餐學習 dbatools》教授你如何使用 dbatools PowerShell 模組自動化 SQL Server。每個 30 分鐘的課程都介紹了一個新的自動化功能,讓你的日常工作更輕鬆。遵循 dbatools 的創建者 Chrissy LeMaire 和其他頂級社區貢獻者的專家建議,你將學會從備份到災難恢復的所有腳本。

- 執行實例到實例和自定義遷移
- 自動化安全審核、最佳實踐和標準化配置
- 管理 SQL Server Agent,包括有效運行 PowerShell 腳本
- 批量導入多種類型的數據到 SQL Server
- 執行高級任務,提高日常管理效率

對於管理 SQL Server 的 DBA、意外 DBA 和系統工程師。

Chrissy LeMaire 是 GitHub 明星和 dbatools 的創建者。Rob Sewell 是數據工程師和熱衷於自動化的人。Jess Pomfret 和 Cláudio Silva 是數據平台架構師。他們都是 Microsoft MVP。

1 開始之前
2 安裝 dbatools
3 dbatools 實驗室
4 dbatools 命令的簡單介紹
5 寫入 SQL Server
6 在網絡上查找 SQL Server 實例
7 盤點你的 SQL 資產
8 註冊伺服器
9 登錄和使用者
10 備份
11 恢復
12 快照
13 安裝和更新 SQL Server
14 為災難做準備
15 執行第一個高級 SQL Server 實例遷移,第一部分
16 執行第一個高級 SQL Server 實例遷移,第二部分
17 高可用性和災難恢復
18 PowerShell 和 SQL Server Agent
19 SQL Server Agent 管理
20 創建和使用 SQL Server Agent 對象
21 數據遮蔽
22 DevOps 自動化
23 追蹤 SQL Server 活動
24 安全和加密
25 數據壓縮
26 使用 dbachecks 驗證你的資產
27 在雲端工作
28 dbatools 配置和日誌記錄
29 從未結束


Chrissy LeMaire is a dual Microsoft MVP, awarded for her work with both SQL Server and PowerShell. She is an international speaker and the creator of the popular PowerShell module, dbatools. She has over 20 years of IT experience and currently works for General Dynamics Information Technology at NATO Special Ops HQ in Belgium.

Rob Sewell is a passionate automator who has been recognized as an MVP by Microsoft. He is a keen community contributor as an event organizer, speaker and open-source contributor.

Cláudio Silva is a database professional, automator, and contributor of the open-source PowerShell module dbatools.

Jess Pomfret is a SQL Server Database Engineer and a Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell.


Chrissy LeMaire是一位雙重Microsoft MVP,因其在SQL Server和PowerShell方面的工作而獲得該獎項。她是一位國際演講者,也是廣受歡迎的PowerShell模組dbatools的創作者。她擁有超過20年的IT經驗,目前在比利時北約特種作戰總部的General Dynamics Information Technology工作。

Rob Sewell是一位熱情的自動化專家,並獲得了Microsoft的MVP認可。他是一位積極的社群貢獻者,擔任活動組織者、演講者和開源貢獻者。

Cláudio Silva是一位資料庫專業人士、自動化專家,也是開源PowerShell模組dbatools的貢獻者。

Jess Pomfret是一位SQL Server資料庫工程師和Microsoft MVP。她從2011年開始使用SQL Server,喜歡性能調優和使用PowerShell自動化流程的解決問題方面的工作。