github dataplat/dbatools v2.9.2

one hour ago

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

Full Changelog: v2.9.1...v2.9.2

Don't miss a new dbatools release

NewReleases is sending notifications on new releases.