What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era of Agile development, DevOps, DataOps, and other weird buzzwords, we the DBAs gotta learn to keep up. It’s time to add our monstrous database into the continuous integration pipeline. But first, we need to know what we’re getting into and need to familiarize ourselves with the terms and methodologies of the world of software development lifecycles.
Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD: SSDT comes with an answer for all.
But before we can dive into SSDT, we must all be on the same page and understand the terms and methodologies used in the world of software development lifecycles. After all, with the power of SSDT, we the DBAs also become a part of this world!
In this session, the first of a multi-part series, we will learn what is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that each DBA must familiarize themselves with before integrating with the software development lifecycle.
Download Slides Deck
This session was delivered at the following events:
- PASS Global Hebrew Virtual Chapter (November 28th, 2019)
- Data Platform Meetup Israel (February 3rd, 2020)
- Data Weekender Europe (May 2nd, 2020)
- PASS Application Development Virtual Group (August 27, 2020)
- Data Geeks Virtual Saturday (South Florida) 2021 (August 7th, 2021)
- PASS Data Community Summit 2021 (November 10)
If you want me to deliver this session at an event that you’re organizing, whether it’s an online or venue event, please fill out the form below. Thanks!