SqlReliabilityKit.psd1
|
@{ RootModule = 'SqlReliabilityKit.psm1' ModuleVersion = '0.5.2' GUID = '0f3c9a2e-8b1d-4c7a-9e2f-1a6b5d4c3e2f' Author = 'Deepesh Dhake' CompanyName = 'Deepesh Dhake' Copyright = '(c) 2026 Deepesh Dhake. MIT License.' Description = 'A SQL Server reliability toolkit: backup recoverability, restore-chain validation, disaster-recovery drift detection, backup anomaly detection, and Query Store regression analysis. Built on dbatools.' PowerShellVersion = '5.1' # dbatools provides connectivity (Invoke-DbaQuery) used by the commands. RequiredModules = @( @{ ModuleName = 'dbatools'; ModuleVersion = '2.0.0' } ) # Explicit export list - keep in sync with Public/*.ps1 FunctionsToExport = @( 'Find-SqlQueryStoreRegression', 'Test-SqlRestoreChain' ) CmdletsToExport = @() VariablesToExport = @() AliasesToExport = @() PrivateData = @{ PSData = @{ Tags = @('SQLServer', 'dbatools', 'DBA', 'QueryStore', 'Backup', 'DisasterRecovery', 'Reliability', 'Windows') LicenseUri = 'https://github.com/deepeshd87/SqlReliabilityKit/blob/main/LICENSE' ProjectUri = 'https://github.com/deepeshd87/SqlReliabilityKit' ReleaseNotes = '0.5.2 - Physical mode now sets dbatools session trust config automatically when -TrustServerCertificate is used, covering the internal restore-target connection, and restores the prior value afterward. 0.5.1 - Fix: physical mode passes the connected server object to Test-DbaLastBackup (it does not accept TrustServerCertificate directly). 0.5.0 - Detect regressions at the QUERY level (aggregate across plans), catching plan-flip regressions that plan-level comparison missed. Adds PlanChanged output, removes PlanId. 0.4.1 - Add Minute to WindowUnit for very-short-window analysis. 0.4.0 - Add -WindowUnit (Day/Hour) for short-window regression analysis; rename BaselineStartDaysAgo/BaselineEndDaysAgo to BaselineStart/BaselineEnd. 0.3.2 - Fix: remove EnableException from Connect-DbaInstance call, use ErrorAction Stop for reliable error handling across dbatools versions. 0.3.1 - Fix: apply TrustServerCertificate at connection time via Connect-DbaInstance (Invoke-DbaQuery does not accept it directly). 0.3.0 - Adds -TrustServerCertificate to both commands for self-signed cert connections. 0.2.0 - Adds Test-SqlRestoreChain (backup chain validation with logical and physical/DBCC modes). 0.1.0 - Find-SqlQueryStoreRegression (execution-weighted Query Store regression detection).' } } } |