CI and CD with SSDT

CI and CD with SSDT Part 5 – Going Multi-Platform with SDK-style SQL Database Projects

2024-10-262024-11-11

In this session, we’ll explore how to create and manage SQL database projects across different platforms, focusing on the differences between SDK-style projects and classic SSDT projects.

In this session, you’ll learn:

What are SDK-style SQL Database Projects: Basics and benefits, and how to handle SQL projects on various platforms.
SDK-style vs. Classic SSDT Projects: Key differences and why they matter.
Getting started with SDK-style SQL Database Projects: Step-by-step instructions for various scenarios.

This webinar will give you practical knowledge to make your SQL database projects more flexible and efficient, no matter the platform.

CI and CD with SSDT Part 0 – Database DevOps for Leaders

2024-06-222024-10-24

Until recently, database development often lagged behind application development in adopting modern lifecycle techniques. This disparity leads to inefficiencies, errors, and communication issues between teams, and hurts the organization’s time-to-market capabilities in both the short and long term.

In this session, the prelude for a multi-part series, we’ll focus on the meaning of DevOps in general and DB DevOps specifically, the reasons to implement it or not, the motivations behind it, cost vs benefit considerations, best practices for the management level, and more.

CI and CD with SSDT Part 4 – Troubleshooting Common SSDT Errors

2022-07-042024-10-26

So, you want to implement DevOps for your SQL Server database, huh? So you went ahead and created a SQL Server Database Project in SSDT. Maybe you even have a CI/CD pipeline all ready to go…

But now, you’re starting to see all kinds of errors and problems that you’re not sure how to tackle. Maybe you have some kind of edge case in your target environment. Maybe you need to store something in your project and you don’t know how. Maybe you’re having trouble with your unit tests. Maybe your project can’t even be built properly without getting a bunch of errors.

You’re starting to doubt… Was SSDT even the right choice?? CAN this even be done at all???

In this session, the 4th of a multi-part series, we will learn How To Do It Right. Based on my real-world experience of consulting and mentoring multiple organizations in their implementation of SQL Server DevOps, dealing with common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them.

CI and CD with SSDT Part 3 – SSDT Tools and Features for DB DevOps

2021-02-172024-10-07

Meet SSDT (SQL Server Data Tools), which 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.

In this session, the 3rd of a multi-part series, we will cover the rich tools, features, and concepts in SSDT that allow DBAs to implement a continuous database development lifecycle. We will also learn about solutions to common fears and objections coming from naysayers, common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them.

CI and CD with SSDT Part 2 – SSDT Methodologies for DB DevOps

2021-02-162024-09-26

In this session, the second of a multi-part series, we will cover the concepts and methodologies in SSDT that allow DBAs to work with source control, implement a continuous database development lifecycle, and implement proper change automation.

In this session, you will learn the methodologies and best practices of working with database development lifecycle and change automation (specifically using SSDT), understand the differences between state-based and migration-based deployments, learn how to strategically tackle common edge cases, and more.

CI and CD with SSDT Part 1 – Development Lifecycle Basics for DBAs

2020-04-282024-09-16

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.