Overview
Explore the integration of SQL Server Data Tools (SSDT), Docker, and Azure DevOps in database development and deployment processes. Learn how to modernize database deployments by implementing Continuous Integration and Continuous Deployment practices, automating builds and deployments using SSDT and Azure DevOps. Discover techniques for automated testing with tSQLt and Docker, and gain insights into handling tasks that require manual intervention. Understand the benefits of SSDT, the importance of Data Definition Language, and how to leverage Visual Studio for database projects. Dive into build pipeline examples, Azure DevOps overview, and strategies for improving and troubleshooting your database development workflow. Address common challenges such as naming artifacts and managing linked server references while ensuring your application developers stay in sync with database changes.
Syllabus
Introduction
Sessions
Cloud Virtual Group
Past Summit
Past Summit Discount
Virtual Groups
Questions
Session Title
Thanks Jason
Dan
Whats on Deck
Why SSDT
DevOps
Data Definition Language
SSDT Sequel Server Tools
SSDT Visual Studio
Docker
Azure DevOps
Unit Testing
Why Unit Testing
Unit Tests
Build Pipeline
Build Pipeline Example
Build Pipeline Overview
Azure DevOps Overview
Summary
Improvements
Troubleshooting
QA
Naming artifacts
How to overcome linked server references
What are you trying to get a buildable
Taught by
PASS Data Community Summit