v2.9.1

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

• @shaded0 made their first contribution in #10784

Full Changelog: v2.9.0...v2.9.1