Alex is a Data Platform MVP who loves DevOps.

He's has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He's most proud of helping Skyscanner develop the ability to deploy 95 times a day. Alex has worked with clients on every continent except Antarctica - so he's keen to meet anyone who researches penguins.

A keen community member, he helps organise Data Relay and he created speakingmentors.com. He blogs at workingwithdevs.com, speaks wherever they'll let him and manages the DLM Digest quarterly email: a report on the latest database DevOps news/tutorials. He was awarded his first MVP award in 2017.

He's quite fond of nutella. And otters. (Not together.)
Alex Yates has submitted 4 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.
100% demos: We will create a new public repository in GitHub, script out a database using SSDT, and set up an automated Azure DevOps Services Release Pipeline to deploy our source code to Azure.
Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and PsDatabaseClone.
Moving to a safer release cadence, based on smaller, more frequent deployments, normally requires deployments to occur while the systems are running. That’s scary. In this session we’ll discuss how to do it safely.

Sessions

Previous Sessions

Write SQL unit tests with tSQLt and automate them with VSTS.
Provision dev databases quickly and easily using containers and clones
Alex_Yates1231041.jpg