Anthony's Favorite dbatools cmdlets and Use Cases
summary
Uses the community dbatools PowerShell module to automate real tasks: Connect-DbaInstance to reuse connection objects, Backup-DbaDatabase and Restore-DbaDatabase to seed and migrate stacks of backups (demonstrates ~1 GB/s restore throughput from a Docker-hosted SQL Server), Invoke-DbaDbBalance to rebalance data across five files for parallel restores, copy cmdlets to sync logins and jobs, and Pester tests plus Set-DbaMaxMemory for config drift detection. Builds an AG in minutes and shows databases come online synchronized.
AI-written summary · about
chapters (13)
- 0:00dbatools for DBAs
- 4:12dbatools superpowers
- 8:23Connecting to SQL Server
- 11:12Inventorying SQL Server
- 13:16Restoring databases
- 16:07Pre-seeding restores
- 20:03Backups with Azure Blob
- 23:53Balancing data files
- 28:08Availability groups in containers
- 33:47Copying logins
- 37:16Configuring SQL Server
- 40:46Pester for validation
- 41:47Q&A
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
01h 37mdbatools for Systems Engineers and Accidental DBAs- 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
44mMy romantic relation with Powershell generally and DBATools especially
36mSQL Server Configuration with dbatools & dbachecks
48mManaging replication with dbatools
46mLift and Shift with dbatools - Azure SQL Managed Instance edition