DevOps for Your Relational Database Foundations

Overview

Explore DevOps practices for relational databases in this NDC London 2021 conference talk. Learn how to effectively manage changes to database structure and programmable objects, track modifications, and implement a seamless deployment process from development to production. Discover tools and techniques to integrate SQL Server databases into your DevOps workflow, making them first-class citizens alongside your source code. Gain insights into version control for databases, creating update packages, and achieving complete automation across multiple environments. Through demonstrations, understand how to leverage Visual Studio, SQL Server Database Projects, and Azure DevOps to streamline your database development and deployment processes.

Syllabus

Introduction
What is DevOps
Journey not destination
People and process
Technological win
SQL Server
Model Approach
Migrations
Considerations
Demo
Visual Studio
SQL Server Database Project
Import Options
Connection Properties
Database Catalog
Database Snapshot
Properties
Publishing
Data Tools Operations
Version Control
Pipelines
Create Pipeline
Build Pipeline Options
Continuous Deployment