Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
summary
Demo shows dbatools managing real tasks: persistent SMO connections via Connect-DbaInstance, scanning backup headers with Get-DbaBackupInformation and piping to Restore-DbaDatabase to restore multiple databases from blob in one pipeline, a three‑line migration pattern (morning full, diff, final restore no recovery), adding NDFs then rebalancing data with Invoke-DbaBalanceDatabaseFiles, and creating an AG from code using certificates and seeding backups so it synchronizes quickly — build availability group with certificate auth in code. Tests use Pester to detect config skew.
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
36mUnlocking the Benefits of Database DevOps and Automation
08mDatabase as Code. Not only migrations
48mManaging replication with dbatools