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
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
03:39 MIN
Automating deployments and leveraging managed services
Cloud-nativeApplications- What’s the buzz about
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
03:02 MIN
A DBA's journey to running SQL Server on Kubernetes
Adjusting Pod Eviction Timings in Kubernetes
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
05:00 MIN
Using the Modern Data Stack and DBT for transformations
Modern Data Architectures need Software Engineering
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
04:09 MIN
Understanding the unique challenges of database DevOps
Database DevOps with Containers
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
04:04 MIN
Key takeaways for building event-driven systems on Azure
Implementing an Event Sourcing strategy on Azure
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
01:55 MIN
Merging data engineering and DevOps for scalability
Software Engineering Social Connection: Yubo’s lean approach to scaling an 80M-user infrastructure
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
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
Unlock Moments
Create a free account to watch a limited number of Moments each month.
Upgrade to PRO for unlimited access to the full archive.
Upgrade to PRO for unlimited access to the full archive.
You have an account? Log in
Featured Partners
Related Videos
39:15Database DevOps with Containers
Rob Richardson
26:53Enjoying SQL data pipelines with dbt
Matthias Niehoff
43:26Develop enterprise-ready applications for Microsoft Teams with Azure resources on modern web technologies
Markus Möller
48:05Branch your database like your code: How schema changes and pull requests go hand in hand
Johannes Nicolai & Lilli Seyther-Besecke
56:19Plan CI/CD on the Enterprise level!
Pawel Piwosz
51:13Demystifying DevOps—Pros, cons, dos & don'ts
Thomas Fuchs, Waleed Arshad & Frank Dornberger & Idir Ouhab Meskine:
34:00Implementing continuous delivery in a data processing pipeline
Álvaro Martín Lozano
46:06CD2CF - Continuous Deployment to Cloud Foundry
Dominik Kress
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.
Rocken AG
Remote
DevOps
Ansible
Terraform
Continuous Delivery