Discover how to implement DevOps practices for SQL databases, Analysis cubes, and SSIS packages in this comprehensive conference talk from PASS Data Community Summit. Learn to build and release Visual Studio SSDT projects and Power BI reports using Azure DevOps Pipelines. Explore development practices for tracking code changes in source control while utilizing development databases for T-SQL views and procedures. Understand the benefits of SQL database projects, including compile-time checking and refactoring support. Gain insights into how DevOps practices can enhance code quality by identifying issues early in the development cycle and increase team velocity by streamlining deployments across different environments.
Overview
Syllabus
Azure DevOps Pipelines for BI - Mike Diehl
Taught by
PASS Data Community Summit