What's Changed
- Network certificate commands - Accept Key Storage Provider keys and inspect private keys through CNG by @andreasjordan in #10721
- CI runners - Set an account lockout threshold at bootstrap so a SQL login can be locked out by @andreasjordan in #10718
- CI - Scope the Azure log shipping test databases by run id so concurrent runs do not share a blob name by @andreasjordan in #10717
- Get-DbaBackupInformation - Keep the readable files when one file of a Path array cannot be read by @andreasjordan in #10723
- Bump anthropics/claude-code-action from 1.0.222 to 1.0.230 in the github-actions group by @dependabot[bot] in #10734
- Connect-DbaInstance - Skip the Windows SSPI test when the instance is not local by @andreasjordan in #10733
- Update-DbaInstance - Use the temp folder of the test configuration in the tests by @andreasjordan in #10732
- Update-ServiceStatus, Set-DbaPrivilege - Keep test variables out of the module scope and filter on bound parameters by @andreasjordan in #10731
- Get-DbaExternalProcess, Stop-DbaExternalProcess - Restart only the Restart instance in the tests by @andreasjordan in #10730
- Stop-DbaProcess - Skip system sessions instead of trying to kill them by @andreasjordan in #10729
- Connect-DbaInstance - Return the connection of a server object after reading its current database by @andreasjordan in #10728
- Invoke-DbaQuery - Document what -As SingleValue really returns by @andreasjordan in #10727
- New-DbaComputerCertificate, New-DbaComputerCertificateSigningRequest - Add -Provider to create the private key in a Key Storage Provider by @andreasjordan in #10722
- Pin dbatools.library to 2026.9.16 Azure compatibility preview by @potatoqualitee in #10720
- Set-DbaLogin - Return the login as it is after unlocking it with a new password by @andreasjordan in #10537
- Remove-DbaComputerCertificate - Add -DeleteKey to delete the private key with the certificate by @andreasjordan in #10724
- CI - Report a failed test that outputs SMO objects instead of killing the stage by @andreasjordan in #10738
- Set-DbaLogin - Stop eating the caller loop on an invalid parameter combination by @andreasjordan in #10737
- Remove-DbaPrivilege - Add a command to revoke Windows privileges by @andreasjordan in #10739
- Message log file - Write the tags instead of the type name and rotate past the second file by @andreasjordan in #10742
- Maintenance runspace - Skip TEPP when the runspace imports the module by @andreasjordan in #10744
- CI - Fail when the pinned SMO changes an enumeration floor by @andreasjordan in #10746
- Get-DbaXEObject - Require SQL Server 2008 and make -Type work for the predicate types by @andreasjordan in #10747
- Copy-DbaDatabase - Add destination data, log and FILESTREAM directories for backup/restore by @andreasjordan in #10748
- Claude Code hooks - Tune the four gates from the #10654 field report by @andreasjordan in #10749
- Remove-DbaAgentJobStep - Stop ending the calling script when a job or step is missing by @andreasjordan in #10750
- Disable-DbaReplPublishing - Stop ending the calling script for an instance that is not a publisher by @andreasjordan in #10751
- Set-DbaSpConfigure - Stop ending the calling script when the server refuses a change by @andreasjordan in #10752
- Invoke-DbaAdvancedRestore - Guard process after a stop in begin by @andreasjordan in #10754
- Export-DbaExecutionPlan - Warn when the plan query fails and export every -InputObject plan by @andreasjordan in #10753
- Set-DbaPrivilege - Resolve .\Name and LocalSystem, and compare policy entries by SID by @andreasjordan in #10758
- Measure-DbaDiskSpaceRequirement - Return ? for unreadable mount points instead of skipping rows by @andreasjordan in #10756
- Configuration - Apply the persisted values only once per process by @andreasjordan in #10743
- Backup-DbaDbCertificate - Stop before exporting to a path the instance cannot access by @andreasjordan in #10757
- Connect-DbaInstance - Add connection retry parameters by @potatoqualitee in #10741
- Bump the github-actions group with 2 updates by @dependabot[bot] in #10766
- New-DbaAvailabilityGroup - Complete the progress bar in a finally block by @andreasjordan in #10764
- Add-DbaAgDatabase - Complete the progress bars when the command stops early by @andreasjordan in #10762
- Write-ProgressHelper - Fix its defects and add -Id/-ParentId by @andreasjordan in #10761
- Query Store - Ask a central feature rule instead of comparing VersionMajor by @andreasjordan in #10745
- CI - Build MinIO test image from official source by @andreasjordan in #10765
- Backup-DbaDatabase - Complete the progress bars in finally blocks by @andreasjordan in #10763
- Maintenance task tempcleanup - Remove only dbatools* temp items that are stale by @andreasjordan in #10760
- New-DbaComputerCertificate - Leave nothing behind on the computer it runs on by @andreasjordan in #10735
- Tests - Enforce the Stop-Function flow-control invariants over all commands by @andreasjordan in #10755
- Copy-DbaAgentJob: compare job definitions instead of date_modified for -UseLastModified by @mrahman-DBA in #10767
- Sync-DbaAvailabilityGroup: add -UseJobLastModified pass-through to Copy-DbaAgentJob by @mrahman-DBA in #10768
- Install-DbaSqlPackage - Stop without elevation instead of leaving the loop of the caller by @andreasjordan in #10769
- Bump anthropics/claude-code-action from 1.0.235 to 1.0.240 in the github-actions group by @dependabot[bot] in #10771
- Progress - Complete the bars of 13 long-running commands in finally blocks (tier 1) by @andreasjordan in #10773
- Progress - Complete the bars of 9 more commands in finally blocks (tier 2) by @andreasjordan in #10774
- Progress - Complete the bars of 13 more commands in finally blocks (tier 3) by @andreasjordan in #10775
- Bump the github-actions group with 2 updates by @dependabot[bot] in #10785
- Update-DbaInstance - Add -KeepExtractedFiles to leave the extracted update files to the caller by @shaded0 in #10784
- Get-AgentJobFingerprint - Store the file with LF line endings by @andreasjordan in #10783
- Security updates for SQL 2025, 2022, 2019, 2017 - October 13, 2026 by @MikeyBronowski in #10786
- Save-DbaDiagnosticQueryScript - Get past the 403 from Glenn Berry's resources page by @potatoqualitee in #10787
New Contributors
Full Changelog: v2.9.0...v2.9.1