Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
summary
Demonstrates dbatools doing real work: standing up two SQL Server containers in seconds, keeping a persistent SMO connection with Connect-DbaInstance, migrating databases by taking a morning full plus a differential and restoring to a target in three lines of code, scanning blob backups with Get-DbaBackupInformation and piping them into Restore-DbaDatabase, rebalancing added files by rebuilding clustered indexes with Invoke-DbaBalanceDataFiles, creating an Availability Group in ~30 seconds with certificate auth, and syncing logins with preserved SIDs; all demos run and produce the expected restores, AGs and configuration checks.
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
36mUnlocking the Benefits of Database DevOps and Automation
39mDatabase DevOps with Containers