Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
summary
Shows concrete dbatools PowerShell commands: standing up two SQL Server containers in seconds, creating persistent SMO connections, taking morning full plus differential backups and migrating with three lines of code (full, diff, restore), and restoring multiple databases from Azure Blob using a SAS credential and get‑dba‑backupinformation to build the restore sequence. Demonstrates invoke‑dba‑balance‑dbfiles to rebalance four added NDFs, creates an AG in ~30 seconds, and uses Pester tests to detect configuration skew; scanning blobs can take ~9 minutes over Wi‑Fi.
AI-written summary · about
chapters (21)
- 0:00Introduction to DBA tools
- 1:04Managing SQL at Scale
- 2:06Resources and Session Goals
- 4:00Persistent SQL Connections
- 6:12Automating Backup and Restore
- 7:25Docker and Credential Demo
- 10:48Instance Discovery Methods
- 12:54Simple Backup and Restore
- 14:29Database Migration Techniques
- 18:01TDE Considerations
- 19:08Azure Blob Storage Restores
- 24:06Database File Management
- 26:41File Balancing Techniques
- 28:55Building Availability Groups
- 33:31AG Database Addition
- 35:35Syncing Server Level Objects
- 38:47Security and Login Syncing
- 41:50Configuration Management
- 43:51Testing with Pester
- 46:15AI in SQL Management
- 49:46Wrap Up
related talks
50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights- 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
44mAnthony's Favorite dbatools cmdlets and Use Cases
01h 37mdbatools for Systems Engineers and Accidental DBAs
20mSQL Server 2022 migrations with dbatools- 20mSQL Server 2022 migrations with dbatools
39mDatabase DevOps with Containers
56mDeploying Docker for Database DevOps Dominance