Skip to content

Add CI pipeline for multi-version SQL Server testing#665

Merged
erikdarlingdata merged 3 commits intodevfrom
feature/ci-pipelines
Feb 16, 2026
Merged

Add CI pipeline for multi-version SQL Server testing#665
erikdarlingdata merged 3 commits intodevfrom
feature/ci-pipelines

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • sql-tests.yml: Matrix CI testing on SQL Server 2017/2019/2022/2025 (parallel, fail-fast: false)
  • Regenerates DarlingData.sql from current branch via Merge-All.ps1 before testing
  • Installs all procedures and verifies all 9 exist via OBJECT_ID checks
  • test_help_output.sql: Validates @help = 1 for all 9 procedures
  • test_basic_execution.sql: Default execution for 6 safe procedures (sp_PressureDetector, sp_PerfCheck, sp_HealthParser, sp_LogHunter, sp_IndexCleanup, sp_QuickieStore)

What this catches

  • Procedure installation failures on any supported SQL Server version
  • @help = 1 output regressions
  • Default execution errors (memory pressure, XML parsing, DMV access)
  • DarlingData.sql staleness (regenerated from source each CI run)

Closes #664

Test plan

  • 9/9 help tests pass locally against sql2022
  • 6/6 execution tests pass locally against sql2022
  • Merge-All.ps1 regeneration verified (produces valid 1.77MB file)
  • Verify GitHub Actions matrix runs 4 SQL Server versions independently

🤖 Generated with Claude Code

erikdarlingdata and others added 3 commits February 16, 2026 15:45
- sql-tests.yml: Matrix testing on SQL Server 2017/2019/2022/2025
- Regenerates DarlingData.sql from current branch via Merge-All.ps1
- Installs all procs and verifies 9 exist via OBJECT_ID checks
- test_help_output.sql: Validates @help=1 for all 9 procedures
- test_basic_execution.sql: Default execution for 6 safe procedures

All tests verified locally against sql2022 (9/9 help, 6/6 execution).
See issue #664 for details.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
…t apt repo

- Health check: grep errorlog instead of sqlcmd (works across all container versions)
- Install sqlcmd: skip repo setup if Microsoft repo already configured (Ubuntu 24.04)
- Increase health retries from 10 to 15 for slower container starts

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
sp_PerfCheck reads the default trace file which does not exist in Docker
containers. Move to help-only testing (already covered in test_help_output.sql).

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 3677cd4 into dev Feb 16, 2026
5 checks passed
@erikdarlingdata erikdarlingdata deleted the feature/ci-pipelines branch February 16, 2026 21:31
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant