PASS Data Community Summit 2021

Andy Levy

2021-11-10

dbatools, pass-summit, sqlserver, speaking, powershell

Page content

A collection of the resources mentioned in my PASS Data Community Summit session Backup Basics with PowerShell and dbatools, including bonus content!

Resources

dbatools main
dbatools docs
My GitHub repository holding the scripts demonstrated
Bonus Videos will be available at 5:30 PM EST on November 12, 2021:
- Backing up keys and certificates for Transparent Data Encryption
- Installing Ola Hallengren’s Maintenance Solution and scheduling full and transaction log backups

Production Notes

My session was recorded on a Thinkpad T470s using Visual Studio Code and Open Broadcast Studio 27. Input was captured via a Blue Yeti microphone, Logitech C920 camera, Keychron K2 keyboard and Logitech M510 mouse. Lighting provided by the cheapest ring light I could find.

Post-production tasks were performed via iMovie and Handbrake on a 2020 M1 Macbook Air.

Andy is a database administrator, PowerShell fan, former developer, Open Source contributor, RVer, and connoisseur of dad jokes (not in that order). He’s worn a number of IT hats since 1999 before landing in database administration, including web server administration and development, systems integration, and database development. When he isn’t picking queries apart and wrangling unruly herds of databases, he can be found by a campfire, planning the next family camping trip, or mentoring the TAN[X] FIRST Robotics Competition team.