Sebastian Wolff
Automated MS SQL Server database deployments with dacpacs and Azure DevOps
#1about 2 minutes
The challenge of managing hundreds of distributed SQL databases
The core problem was automating deployments across nearly 400 highly customized SQL Server databases on different environments and servers.
#2about 3 minutes
Solution design using dacpacs and Azure DevOps pipelines
The solution involves extracting a database schema into a dacpac, managing it as code in a Visual Studio project, and deploying it via Azure DevOps.
#3about 3 minutes
Implementing the deployment pipeline in Azure DevOps
The pipeline uses MSBuild for building artifacts and WinRM for deployment, with libraries and task groups for reusable, configurable steps.
#4about 12 minutes
How dacpac deployments work with SQLPackage.exe
A dacpac deployment uses SQLPackage.exe to compare the dacpac model with the target database, guided by a publish.xml profile, to generate and apply an update script.
#5about 7 minutes
Handling limitations like multi-environment support
The lack of built-in multi-environment support for objects like users and logins is managed using pre- and post-deployment scripts with SQLCMD variables.
#6about 2 minutes
Advanced customization with deployment contributors
You can extend the deployment process by writing custom C# code using additional deployment contributors to modify SQLPackage behavior, such as ignoring specific objects.
#7about 8 minutes
Q&A on cloud services, dacpac use cases, and PowerShell
The Q&A covers choosing cloud providers, scenarios where dacpacs are not recommended, the use of PowerShell scripts, and handling relational constraints during deployments.
Related jobs
Jobs that call for the skills explored in this talk.
Matching moments
03:47 MIN
Applying software engineering practices to data pipelines
Enjoying SQL data pipelines with dbt
03:39 MIN
Automating deployments and leveraging managed services
Cloud-nativeApplications- What’s the buzz about
03:02 MIN
A DBA's journey to running SQL Server on Kubernetes
Adjusting Pod Eviction Timings in Kubernetes
05:00 MIN
Using the Modern Data Stack and DBT for transformations
Modern Data Architectures need Software Engineering
04:09 MIN
Understanding the unique challenges of database DevOps
Database DevOps with Containers
04:04 MIN
Key takeaways for building event-driven systems on Azure
Implementing an Event Sourcing strategy on Azure
01:55 MIN
Merging data engineering and DevOps for scalability
Software Engineering Social Connection: Yubo’s lean approach to scaling an 80M-user infrastructure
04:11 MIN
Applying a Git-like workflow to database schema changes
Branch your database like your code: How schema changes and pull requests go hand in hand
Featured Partners
Related Videos
39:15Database DevOps with Containers
Rob Richardson
26:53Enjoying SQL data pipelines with dbt
Matthias Niehoff
44:40Enabling automated 1-click customer deployments with built-in quality and security
Christoph Ruggenthaler
48:05Branch your database like your code: How schema changes and pull requests go hand in hand
Johannes Nicolai & Lilli Seyther-Besecke
25:41Developer Tools for Microsoft Azure
Radu Vunvulea
43:26Develop enterprise-ready applications for Microsoft Teams with Azure resources on modern web technologies
Markus Möller
56:19Plan CI/CD on the Enterprise level!
Pawel Piwosz
43:28Tomorrow's cloud data platforms - fully managed database-as-a-service (DBaaS)
Gregor Bauer
Related Articles
View all articles
.gif?w=240&auto=compress,format)
From learning to earning
Jobs that call for the skills explored in this talk.
PRODYNA SE
Düsseldorf, Germany
Intermediate
Senior
Terraform
SYSKRON GmbH
Regensburg, Germany
Intermediate
Senior
.NET
Python
Kubernetes
h + p hachmeister + partner GmbH & Co. KG
Bielefeld, Germany
Intermediate
Senior
Java
Python
Angular
