Continuous Integration for the BI Developer

on YouTube ↗01h 10m

" summary

Shows how to replace manual BI deployments with a reproducible pipeline using Visual Studio SQL Server database projects, SSIS build/deploy tasks, Tabular Editor CLI, and Azure DevOps repos + pipelines (Microsoft-hosted or self-hosted agents). Demo builds two database projects, copies SSIS/Model artifacts, and deploys in ~2 minutes; Azure DevOps Basic (free for 5 users) stores history and triggers CI on commits. Notes tooling limits (schema-compare slows at hundreds of objects, Redgate is faster) and yields per-developer dev databases and fewer hotline firefights.

AI-written summary · about

" chapters (25)

1. 0:00Intro
2. 1:53You are now part of a BI Development team
3. 3:57That's how we roll...
4. 7:55Our TODO and WISH list
5. 10:01Create a DEV Environment Let's change the way we develop in/a database!
6. 10:32SQL Server Data Tools - Database Projects Declarative Database Development
7. 10:57Create a Database Project Create a new project
8. 18:13Common Development Structure One version of the truth (or source code)
9. 23:40Create an Azure DevOps Project
10. 27:09Version Control your work
11. 27:58Next Stop Automation
12. 28:29Automation Checkout/Build / Publish & Deploy
13. 29:14Integration CI
14. 30:24Continuous Delivery - Deployment
15. 31:18Data DevOps
16. 32:32Somebody has to do the work Microsoft-hosted Agents Self-Hosted Agents
17. 34:50Create Pipelines
18. 45:00Automation Checkout / Build / Publish & Deploy
19. 45:39Start small and get bigger
20. 45:58SSIS, SSAS, SSRS
21. 46:29Power BI Automation
22. 47:48Power BI & Azure DevOps
23. 50:25Get smarter
24. 52:00Outlook: Go Global
25. 53:44To wrap up...

" related talks

• 01h 12mAzure DevOps and the SSIS Development LifecycleAndy Leonard · All Things Open 2020
• 53mAzure DevOps and the SSIS Development LifecycleAndy Leonard · Global Summer 2020 Azure Data Fest 2020
• 01h 00mContinuous Integration and Delivery for DatabasesJimmy Bogard · NDC London 2020
• 48mConnecting the dots of Azure SQL DevOpsMuazma Zahid · SQLBits 2023
• 46mA Database DevOps PipelineRob Richardson · Øredev 2022
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 48mGit off my lawn: Mastering Power BI Deployments with Git IntegrationDavid Mitchell · SQLBits 2024
• 46mDatabase CI/CD with Docker Containers and Azure DevOpsChris Taylor · SQLBits 2020