What's Changed
- Sync-DbaLoginPassword - Output the Failed row of a login that could not be synced by @andreasjordan in #10804
- Bump anthropics/claude-code-action from 1.0.248 to 1.0.252 in the github-actions group by @dependabot[bot] in #10805
- Tests - Restore max server memory, count only the sessions a round opened, read the user name from Windows by @andreasjordan in #10800
- Database level commands - Stop writing $null into the output of 9 commands by @andreasjordan in #10797
- Copy commands - Stop writing $null into the output of 17 commands by @andreasjordan in #10795
- Export-DbaCsv - Close the reader in the finally when writing the file fails by @andreasjordan in #10790
- Read-DbaBackupHeader, Start-/Stop-DbaDbEncryption - Run the threads in a pool without a host and close it in a finally by @andreasjordan in #10789
- Update icon in ConvertTo-DbaTimeline.ps1 by @OEdling in #10788
- Instance level commands - Stop writing $null into the output of 19 commands by @andreasjordan in #10796
- Set-DbaLogin - Set -PasswordHash on logins with CHECK_POLICY on by @andreasjordan in #10803
- Cleanup, output and -WhatIf - Fix the side findings of the progress work in 10 commands by @andreasjordan in #10791
- Export-DbaDbTableData, Export-DbaScript - Add -ScriptingOptionsObject, keep every piped table and fix file output with batch terminators by @andreasjordan in #10782
- 2025 cu10 (do Build) by @niphlod in #10808
- Bump anthropics/claude-code-action from 1.0.252 to 1.0.261 in the github-actions group by @dependabot[bot] in #10810
- Add Find-DbaDbMissingIndex by @deepeshd87 in #10779
- Tests - Report Query() calls whose value goes to the output by @andreasjordan in #10798
- Set-DbaLogin - Read only the logins of -Login from the instance by @andreasjordan in #10809
- Connect-DbaInstance - Refuse SQL Server 2000 and 2005 with the last release that supports them by @potatoqualitee in #10813
- Restore-DbaDbSnapshot, dedicated admin connection - Fix the follow-up findings of #10776 in 7 commands by @andreasjordan in #10792
- Copy-DbaSsisCatalog.ps1 - Update to fix sp params by @david-forck in #10815
- Bump anthropics/claude-code-action from 1.0.261 to 1.0.265 in the github-actions group by @dependabot[bot] in #10816
- CI - Run the macOS import check on macos-latest, macOS-14 gets no runner any more by @andreasjordan in #10828
- Build reference - Add the security updates of November 10, 2026 and a script that adds new builds by @andreasjordan in #10826
- Dependabot - Skip patch bumps of claude-code-action, take only minor and major by @potatoqualitee in #10831
- Invoke-ManualPester - Run the tests from outside the module by @andreasjordan in #10830
- Get-DbaDatabase - Refresh the databases that a passed server object has loaded before by @andreasjordan in #10829
- Get-DbaAgRingBuffer - Convert the age of a record in seconds to avoid the int overflow by @andreasjordan in #10821
- Remove-DbaDbBackupRestoreHistory - Honor -KeepDays 0, the instance clock and dropped databases by @andreasjordan in #10820
- Bump anthropics/claude-code-action from 1.0.265 to 1.0.269 in the github-actions group by @dependabot[bot] in #10817
- SQL Server 2025 CU 11, 2022 CU28 by @MikeyBronowski in #10836
- Fleet controller - Ignore ghost ci-azure runs that GitHub never started by @potatoqualitee in #10845
- Backup-DbaDatabase - Back up to NUL also when a Path is given by @potatoqualitee in #10846
- Restore-DbaDbCertificate - Restore every certificate once and warn about a folder without certificates by @andreasjordan in #10840
- Restart-DbaService - Start a service that is already stopped, and report every service in Start-, Stop- and Restart-DbaService by @andreasjordan in #10832
- Test-DbaPath - Use sys.dm_os_file_exists so that logins without sysadmin get an answer by @andreasjordan in #10838
- CI runners - Install runner 2.338.2 at bootstrap, GitHub no longer serves 2.335.1 by @potatoqualitee in #10858
- Copy-DbaLogin - Add -UpdateExisting to update changed logins in place by @andreasjordan in #10801
- Backup-DbaDatabase - Tell that -FilePath names a directory also for logins without sysadmin by @andreasjordan in #10841
- Sync-DbaAvailabilityGroup - Add -UpdateExistingLogin pass-through to Copy-DbaLogin by @andreasjordan in #10802
- Tests - Remove every default parameter value that a test file sets by @andreasjordan in #10842
- Get-DbaFile - List directories with sys.dm_os_enumerate_filesystem so that logins without sysadmin find files by @andreasjordan in #10843
- Get-DbaDbBackupHistory - Add a TimeSpan in -Since to the clock of the instance by @andreasjordan in #10847
- CI runners - Warn about a runner version GitHub retires, and hash check it in the image by @potatoqualitee in #10859
- Find-DbaOrphanedFile - Refuse a login that cannot see sys.master_files and list directories without sysadmin by @andreasjordan in #10844
- Find-DbaAgentJob - Count the days of -LastUsed back from the clock of the instance by @andreasjordan in #10848
- Get-DbaAgentJobHistory - Set no end date unless -EndDate is given by @andreasjordan in #10849
- Get-DbaLastGoodCheckDb - Count the days up to the clock of the instance by @andreasjordan in #10850
- Find-DbaDbUnusedIndex - Report never used indexes, measure the uptime on the instance, skip inaccessible databases by @andreasjordan in #10851
- Remove-DbaComputerCertificate - Delete the key on a remote computer, where CurrentUser\UserDS cannot be opened by @andreasjordan in #10854
- Get-DbaComputerCertificate - Report HasPrivateKey of remote computers and fix -Type and -Path by @andreasjordan in #10855
- Get-DbaNetworkConfiguration - Report HasPrivateKey and FriendlyName of the certificates of a remote computer by @andreasjordan in #10856
- Add-DbaComputerCertificate - Leave no copy of the private key on this computer and report HasPrivateKey and FriendlyName of a remote computer by @andreasjordan in #10857
New Contributors
- @OEdling made their first contribution in #10788
- @david-forck made their first contribution in #10815
Full Changelog: v2.9.1...v2.9.2