The Wonders of Modern SQL Server Administration

19 Sep 2019
12:00pm - 1:30pm PDT

Join us at noon for lunch.
Featured presentation will start at approx 12:15pm.

Presentation: The Wonders of Modern SQL Server Administration

Ever been tired of doing the same action over and over again? Chaining together RESTORE DATABASE sequences from the backup files? Wrapping statements into dynamic T-SQL to collect information from remote instances? Migrating multiple databases to a different server(s)?

Surprisingly, each of the tasks above - tasks that require a lot of manual effort and attention to details - can be done with writing just a few lines in a Powershell console! During this session you will see by yourself how easy it is to automate mundane processes using collective knowledge of SQL community. The session will introduce dbatools Powershell module that was written by DBAs for DBAs, and will showcase many regular DBA tasks converted to a concise scripting language:

  • Backup/restore databases
  • Environment healthchecks
  • Configuration
  • Maintenance
  • Database migrations
  • And many more!

Speaker: Kirill Kravtsov

DBA for more than 10 years, Powershell enthusiast and major dbatools contributor. I'm also a huge fan of DevOps mentality and an active Jenkins user, which left me with no choice other than using and developing tools that automate most of the aspects of the database management.

In my free time I enjoy travelling, playing video games, heavy metal music and many more.

Contact: Janice Gerbrandt, Organizer,

Registration for this event has passed

19 Sep 2019
12:00pm - 1:30pm PDT

Google Calendar

  • Fort Tectoria, Shaw Boardroom 777 Fort St, Victoria, BC