Summary
GitHub Copilot reviewed PR #3885 and identified 4 compatibility issues that need fixing:
1. sp_BlitzWho: Require SQL Server 2016 SP2+ minimum build
ExpertMode unconditionally references sys.dm_exec_query_stats columns (last_dop, min_dop, max_dop, last_grant_kb) that aren't available before SQL Server 2016 SP2 (build 13.0.5026.0). Add a build number check to the version gate to block pre-SP2 builds of SQL 2016.
2. sp_BlitzCache: Check database compatibility level 130+ up front
STRING_SPLIT is used for parsing SQL handles and query hashes, but requires database compatibility level 130+. Add an early check that raises a clear error message directing users to install in master if their database compat level is too low.
3. sp_kill: Azure SQL DB compatibility for output tables
The USE statement in the persistent output table section (Section 10) isn't supported on Azure SQL DB. Replace with 3-part naming which works on both Azure and on-prem.
4. sp_BlitzIndex: Remove outdated 2005/2000 version references
Help text still mentions SQL 2005 and 2000, but the minimum supported version is now 2016+. Update to reflect current minimum.
References
Summary
GitHub Copilot reviewed PR #3885 and identified 4 compatibility issues that need fixing:
1. sp_BlitzWho: Require SQL Server 2016 SP2+ minimum build
ExpertMode unconditionally references
sys.dm_exec_query_statscolumns (last_dop,min_dop,max_dop,last_grant_kb) that aren't available before SQL Server 2016 SP2 (build 13.0.5026.0). Add a build number check to the version gate to block pre-SP2 builds of SQL 2016.2. sp_BlitzCache: Check database compatibility level 130+ up front
STRING_SPLITis used for parsing SQL handles and query hashes, but requires database compatibility level 130+. Add an early check that raises a clear error message directing users to install inmasterif their database compat level is too low.3. sp_kill: Azure SQL DB compatibility for output tables
The
USEstatement in the persistent output table section (Section 10) isn't supported on Azure SQL DB. Replace with 3-part naming which works on both Azure and on-prem.4. sp_BlitzIndex: Remove outdated 2005/2000 version references
Help text still mentions SQL 2005 and 2000, but the minimum supported version is now 2016+. Update to reflect current minimum.
References