SQL Code Testing Pipeline by Paul Ou Yang

Session Title: SQL Code Testing Pipeline
Speaker: Paul Ou Yang

Abstract: Imagine you write SQL code that must be compatible with the 5 latest versions of SQL Server: 2012, 2014, 2016, 2017, and 2019. Manually testing your SQL code in each version is going to be time consuming and perhaps neglected. This is where automation comes in. Using ARM templates, Azure DevOps, Pester and PowerShell, test environments can be easily created and destroyed when new versions are released. This session will help you automate the testing and ensure that your SQL code will run efficiently in any version. Demos planned include: – Using ARM templates to create multiple SQL VMs – Working with PowerShell to deploy SQL scripts – Testing SQL execution with Pester – Orchestrating the tasks with Azure DevOps pipelines.

#DevOps #PowerShell #Pester #SQL #Azure