Rob Sewell

Information & Communications Technology

PowerShell Azure DevOps Azure Arc Data Services Azure Bicep Bicep Infrastructure as Code

Exeter, England, United Kingdom

A SQL environment for test or how we provided a dbatools training day at SQLBits using devcontainers

In March Jess Pomfret and I gave a Training Day for 5 million* attendees about dbatools.

For those that dont know, dbatools is the most popular SQL Server open source PowerShell module and has used blog posts from many of the SQL community as inspiration for over 900 million* commands written by over 4tn* contributors.

As we did not know even right up till the day whether we would be delivering together or separately, in person or remotely, we decided to put our demo into a repository and deliver it from a controlled environment (two containers) using GitHub Actions, Docker Hub and VS Code.

We learned some things along the way and had some fun also and we shall share this all with you.

Whilst this is about dbatools, PowerShell, containers, Pester and some fun. It will also show you how you can create a SQL Server environment which will enable you to repeatedly run demos, allow others to run the same code as you.

* It is highly likely that some numbers may have been exaggerated

Rob Sewell

Be-Whiskered Maker of Things

Rob was a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people make things. He is a Cloud and Data Center MVP and a Data Platform MVP, co-leader of Data South West UK User Group and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and PowerShell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, he is often out riding his bike as his eyes are not good enough to play cricket any more

He has a fabulous beard

Rob's full speaker profile