dbatools for Systems Engineers and Accidental DBAs

on YouTube ↗01h 37m

" summary

Community PowerShell module dbatools claims to automate real DBA work: Start-DBAMigration moves whole instances (databases, logins with passwords, jobs, sp_configure) and demonstrably completes large instance-to-instance migrations; Test-DbaLastBackup restores last full/diff/log chain to verify backups. It runs on PowerShell 3–7 and many OSes, supports SQL 2000+, has ~225 contributors and ~1.5M downloads, wraps many combo commands (Find-DbaInstance, Copy-DbaDatabase/Copy-DbaLogin, Export-DbaInstance, Update-DbaInstance) and shows tools actually working in live demos.

AI-written summary · about

" chapters (30)

1. 0:00Introduction
2. 3:59What is dbatools and why use it
3. 8:37Installing dbatools
4. 13:59SQL Server concerns for non-DBAs
5. 18:16Tips for orgs without on-prem DBAs
6. 22:34Health monitoring checks
7. 25:50First steps after inheriting SQL Server
8. 32:12Finding unknown SQL instances
9. 36:50Connecting to SQL instances
10. 41:29Adding SQL logins and mixed mode
11. 45:05Checking backups and disk space
12. 50:33Creating test DBs and backups
13. 55:08Restoring DBs with dbatools
14. 1:00:27Testing backups with test-DbaLastBackup
15. 1:01:10Exporting instance settings
16. 1:03:19Working with SQL Agent jobs
17. 1:06:33Configuring SQL memory
18. 1:09:01Checking power plans and OS
19. 1:11:10Listing SQL components
20. 1:12:55Managing SQL services and accounts
21. 1:17:10Updating SQL instances
22. 1:19:19Migrating DBs and logins
23. 1:22:33SQL Server with Docker
24. 1:25:01Working with registered servers
25. 1:26:46Configuring dbatools settings
26. 1:27:48Finding orphaned DB files
27. 1:29:35Importing CSV into SQL
28. 1:30:57Encrypting SQL with TDE
29. 1:31:43Certificate management
30. 1:36:36Q&A

" related talks

• 44mAnthony's Favorite dbatools cmdlets and Use CasesAnthony Nocentino · PowerShell + DevOps Global Summit 2023
• 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World InsightsAnthony Nocentino · SQLBits 2022
• 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World InsightsAnthony Nocentino · SQLBits 2024
• 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World InsightsAnthony Nocentino · SQLBits 2019
• 20mSQL Server 2022 migrations with dbatoolsJess Pomfret · SQLBits 2023
• 20mSQL Server 2022 migrations with dbatoolsJess Pomfret · SQLBits 2022
• 08mDatabase as Code. Not only migrationsMaksim Gramin · Percona Community Live 2022
• 48mManaging replication with dbatoolsJess Pomfret · SQLBits 2019