SQLBits 2020

DevOps 101 for Data Folks

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.

DevOps has fundamentally changed the way IT is managed. Those practicing DevOps well aren't just outpacing their competitors, they are annihilating them. With DevOps comes a whole host of new practices, tools and buzzwords. Some roles and tasks have been made redundant, while new opportunities have been created.

We all need to learn to survive in this new reality.

In this session we'll cut through the hype and look at the key concepts and findings from the Puppet State of DevOps Reports, The DevOps Handbook, and Microsoft's work in this space.

We will finish with an overview of an Azure DevOps Services project that automatically tests and deploys the code from a SQL Server Data Tools project in a public GitHub repo.