Discover the power of PowerShell and dbatools for database administration in this comprehensive conference talk. Explore how a late adopter of PowerShell found immense value in dbatools for daily DBA tasks. Learn through practical demonstrations covering automatic restore testing, custom log shipping solutions, efficient migration processes, and streamlined upgrades and patching. Gain insights into dbatools' functionality, including Docker integration, module management, and SQL Server interactions. Dive into advanced topics such as credential handling, Azure storage integration, and metadata management. Master error handling techniques and backup strategies to enhance your DBA toolkit and boost productivity.
My Romantic Relation with Powershell Generally - and with dbatools Especially
PASS Data Community Summit via YouTube
Overview
Syllabus
Introduction
What is dbatools
Demos
Famous Last Words
Docker Pull
Docker Volumes
Docker Create
Docker Start
dbatools
dbatools as a module
update dbatools
connect to containers
database
SQL credential
Object return
New dbalogin
Password
Cleaning up my storage container
Credentials
Shared Access Signature
Create Credential
Force Credential
Backup to URL
Timestamp Format
DBA Migration
What if
Copy DBA Login
DBA Tools Error Handling
Creating a Metadata Database
Getting the Last Full Backup
Taught by
PASS Data Community Summit
