Automate your DBA tasks with dbatools and dbachecks

2022

TL; DR

Let us show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed modules dbatools and dbachecks. Join Jess Pomfret and Rob Sewell, two of the dbatools in a Month of Lunches authors and learn how effective dbatools and dbachecks can make you. We will show you the skills, scripts and tricks that we have learned with dbatools and dbachecks and tell you how they have rocketed our careers

Session Details

Let us show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed modules dbatools and dbachecks.

Join Jess Pomfret and Rob Sewell, two of the dbatools in a Month of Lunches authors and take your dbatools and dbachecks skills to the next level or be introduced to dbatools and learn how effective it can make you. We will show you the skills, scripts, and tricks that we have learned with dbatools and dbachecks and tell you how they have rocketed our careers

There will be many practical examples of how dbatools and dbachecks can help to save time in DBA administration duties

- Creating Availability Groups
- Syncing Agent Jobs and Logins between replicas
- Finding SQL Instances on your estate
- Working with Central Management Server
- Disaster Recovery
- Backup Testing
- Simple instance migrations
- Complex instance migrations
- Tracking Activity
- Simplify application upgrades with database snapshots
- Working with other community tools with dbatools
- Encompassing dbatools in DevOps
- Validating your estate
- Using dbatools in the cloud (i.e. working with Azure SQL Database)

And much much more

Come and join us for a great day of PowerShell and SQL full of demos and useful solutions that you will be able to take back to your workplace. You will improve your knowledge and skills, see how the modern DBA will work and have fun at the same time.

Who Are You?

You are a DBA, senior or junior, looking after 1 or 100,000 instances, a developer who interacts with SQL Server, an accidental DBA or you have DevOps in your job title.
You are interested in improving your PowerShell skills for SQL Server or reducing the time you and your team spend administering SQL Server.
You have spent 1 day or 20 years working with SQL Server.
You know that you work in a field where automation is king and want to understand more of what is available.
You are interested in learning and improving your automation skillset.

What do you need?

All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.

All scripts and slides will be provided to you. If you wish to follow along with most of the demos you should have access to a machine that can run Docker as we will be demoing with a Dev Container. Alternatively, you may be able to follow along on a machine with PowerShell v 5 or above and a SQL Server 2012 or above instance.

feedback link: https://sqlb.it/?7228

3 things you'll get out of this session

Rob Sewell's other proposed sessions for 2026

Infrastructure as Code for Humans: The Why, the How, and the ‘Please Don’t Click That’ - 2026

What an Automation Nerd Learnt by Automating Their Home (Besides Annoying Their Family) - 2026

Rob Sewell's previous sessions

The DBA in a hybrid environment

Ideal for database administrators, developers, and database reliability engineers, this training day will explore all the skills you need to enable you to manage SQL Server estates spanning on-premises and cloud environments.

Nose-Dive Narratives: Slide Karaoke 2024

Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!

20 mins to git comfortable

In this new world we're all developers! Whether we're writing application code or describing our infrastructure using bicep or terraform we need to keep it safe. Git and source control is our best option for developing on our own and as part of a team… but git is scary! In this 20 min session we'll go through just enough to git you comfortable with source control.

10 Productivity tools in 20 minutes

You are busy, we are busy, everyone is busy. These are the tools that two busy consultants use to improve their productivity. We want to tell you about the tools that we use; that maximise our time, simplify our life, reduce our key strokes and generally make us appear more amazing. So that you can use them too. We have 20 minutes, so we wont go into much detail but we have some good quick stories to tell.

There is a time and a place for everything

There is a time and a place for everything. John and Rob, being consultants, often say "Well, it depends" Lets talk about some of the times when the "rules" may not fit

SQL Notebooks in Azure Data Studio for the DBA

While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.

How To Start Collaborating With A GitHub Repository

Wanted to join with open-source projects but don’t know how? This quick session will give you all that you need to start doing so.

Creating Azure SQL Db Users with an SPN using Azure DevOps

This session will take you through the steps required to build an automated solution to create an Azure SQL Database with a Service Principal and create users and apply permissions

Validate Your SQL Server Estate with Ease Using dbachecks

Learn how you can validate your SQL Server estate with ease using dbachecks

Introduction to Pester-TDD for PowerShell

Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function

Advice and guidance on becoming a speaker or volunteer

Want to become a community speaker or involved in the SQL Community? Don't feel confident enough to try? Need some advice and guidance? We want to help you, we will help you

Jess Pomfret's other proposed sessions for 2026

Automating SQL Server Management with GitHub Actions and PowerShell - 2026

Data API Builder – Create an API for Your Database in Seconds - 2026

dbatools - Wheel of Fortune - 2026

Jess Pomfret's previous sessions

The DBA in a hybrid environment

Ideal for database administrators, developers, and database reliability engineers, this training day will explore all the skills you need to enable you to manage SQL Server estates spanning on-premises and cloud environments.

Managing replication with dbatools

One of the most highly requested dbatools features was for commands to manage replication and now they're here. In this session, we'll run through the available commands and how they can be used to build up and tear down replication.

Anyone can be an alphabet soup ally

Folks that belong to the queer community are often referred to as LGBTQ+, Jess and Linda represent a small portion of the letters within this alphabet soup and they will guide you through some common situations where you can be a good ally. There is no one right answer, but there are ways for you to prepare for certain situations so you know what your best move might be to provide support and allyship. This session will provide tips for people who are new to being an ally and for existing allies who want to add skills to their toolbelt.

I'm here, I'm queer ( Why Representation Matters)

In this 20 minute session we’ll talk about why it matters that ‘I’m here and I’m Queer’. Representation, both at conferences and in the media, is so important not just for us now, but also for the future generations. If you want to know why all this DEI stuff matters, why we need to keep striving to diversify the attendees and speakers at our conferences and events, then this session is for you.

SQL Server 2022 migrations with dbatools

Using dbatools we'll migrate our databases to a shiny new SQL Server 2022 instance.

Keynote by The Community

Ben and Rob have found some wonderful folk to actually do the important parts of the community keynote. on the theme of How to be a nonpassive member of the data community

Introduction to PowerShell

Everything you need to get started with PowerShell.

Migrate databases easily with dbatools

Quickly and easily migrate databases and associated logins using dbatools.

Life Hacks: dbatools edition

dbatools is an open source PowerShell module. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.

Install & Configure SQL Server with PowerShell DSC

Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.