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.
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.
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!
Download Slides Deck
This session was delivered at the following events:
- PASS Global Hebrew Virtual Chapter (November 28, 2019)
- Data Platform Meetup Israel (February 3, 2020)
- Data Weekender Europe (May 2, 2020)
- PASS Application Development Virtual Group (August 27, 2020)
- Data Geeks Virtual Saturday (South Florida) 2021 (August 7, 2021)
- PASS Data Community Summit 2021 (November 10, 2021)
- DBA Fundamentals Group (March 21, 2023) (YouTube Recording)
- Data TLV Summit (November 2, 2023, Israel)
- Microsoft DBAs Club (September 15, 2024, Hebrew) (YouTube Recording)
Interested?
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!