SQL Server Administration & Maintenance, Fast Focus

SQT04 Fast Focus: Automation for the DBA: Embrace Your Inner Sloth


1:30pm - 1:50pm

Level: Introductory

William Durkin

Data Architect

DData Masterminds

DBAs and sysadmins never have time for the fun stuff. We are always restoring a DB for a dev or setting up a new instance for that new BI project. What if I told you that you can make all that time consuming busy-work disappear?

In this session we will learn to embrace the power of automation to allow us to sit back and relax..... or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work.

Along the way we will see that we can benefit from the wide world of automation expertise already available to us and avoid re-inventing the wheel, again!

You will learn:

  • PowerShell for DBAs = epic efficiency gains
  • Open source + Microsoft = friends now! Use OSS for MS enterprise environments
  • DevOps + DBA = DataOps. The future of DBAs is (near) zero Admin work and all about Architecture and Automation