Work Item / Issue Reference

AB#40316

GitHub Issue: #<ISSUE_NUMBER>

---

Summary

This pull request adds support for testing against SQL Server 2025 across Windows, macOS, and Linux CI pipelines. It introduces new matrix configurations, installation steps, and test/benchmark execution for SQL Server 2025, ensuring the project is validated on the upcoming SQL Server release as well as existing versions.

CI Pipeline Enhancements for SQL Server 2025:

Windows pipeline updates:

• Added a new matrix entry for SQLServer2025 with Python 3.14 to the Windows pipeline, alongside the installation and setup scripts for SQL Server 2025 Express, including database and user creation steps. [1] [2]
• Configured test execution and code coverage collection for SQL Server 2025, mirroring existing steps for SQL Server 2022.
• Updated AdventureWorks2022 database restore and performance benchmarking steps to also run for SQL Server 2025. [1] [2]

macOS and Linux pipeline updates:

• Added matrix entries and logic to run tests against SQL Server 2025 Docker images on both macOS and Linux, in addition to SQL Server 2022. [1] [2]
• Updated Docker commands to use the matrix-provided SQL Server image, supporting both 2022 and 2025 images.

General improvements:

• Enhanced test result publishing to include the SQL Server version in the run title for better traceability.

Other minor changes:

• Updated the git rm and git checkout commands in the ADO sync pipeline to exclude the .gdn directory from removal and checkout, preventing accidental deletion of required files.