I was very late to adopt Powershell in my day-to-day work as a DBA. I did some copy/change “programming” with Powershell. But it wasn’t until I got in touch with dbatools that I really understood the power of Powershell. In this session, I will demo some of the reasons I really love Powershell and DBATools.

I will cover a brief overview of DBATools and then jump into some scenarios where DBATools really helped me, including:

  • Automatic restore testing
  • Homecooked log shipping
  • Migration work
  • Upgrades and patching


Magnus Ahlkvist, SQL Server instructor, DBA/Developer consultant Transmokopter SQL AB

Independent database consultant and certified trainer with a passion for chasing that extra millisecond. 20 years of database development and administration but trying to be humble enough to understand that I’m still learning.