Unveiling the magic of CI/CD for SQL Server using GitHub Actions
summary
Shows a working GitHub Actions CI/CD pipeline that builds a DACPAC from a database project (including the new SDK-style project), runs workflows defined in YAML, and deploys either state-based artifacts or migration scripts using dbops PowerShell and DBUp. Explains Runner choices (hosted Ubuntu is cheapest; Windows costs ~2x, macOS much more), secrets via GitHub or Azure Key Vault (the Key Vault action is deprecated), unit testing with tSQLt plus a PSTSQLT test-generator, and live demos that execute successfully.
AI-written summary · about
chapters (16)
- 0:00Session introduction
- 1:01Agenda overview
- 2:23Speaker bios
- 3:53Speaker bios continued
- 5:33Git branching strategies
- 11:25Tools and integration
- 12:12GitHub browser demo
- 16:44GitHub runner configuration
- 20:44SQL Server deployments
- 29:35Migration-based deployment
- 31:37Managing secrets
- 34:18Database unit testing
- 37:05Audience Q&A
- 40:08GitHub actions deep dive
- 42:11GitHub script automation
- 44:03Metrics and conclusion
related talks
49mUnveiling the magic of CI/CD for SQL Server using GitHub Actions
48mConnecting the dots of Azure SQL DevOps
48mCICD with Github Actions
44mCI/CD with GitHub Actions
42mPipelines, IaC and Deployments with Github Actions & Octopus Deploy
56mCI/CD and beyond with GitHub Actions
48mGitHub + Azure: Better Together!
22mAdvanced Azure DevOps With Containers and Pipeline As Code