v2.9.0

This one's a whopper! 🍔

What's Changed

• Get-DbaKbUpdate - Add TimeoutSec so a silent update catalog cannot hang the command by @andreasjordan in #10477
• Claude Code - Add an issue workflow skill and document the test instance fixtures by @andreasjordan in #10479
• Set-DbaAgentSchedule - Keep the frequency settings when they are not part of the change by @andreasjordan in #10480
• Network certificate commands - Find the configured certificate even when it is archived by @andreasjordan in #10478
• Tests - Make three dead mocks apply, harden the update catalog probe and clear the last top-level statements by @andreasjordan in #10481
• Update-DbaInstance - Un-skip the unit tests, and allow -ForEach when the cases come from BeforeDiscovery by @andreasjordan in #10482
• Tests - Recover the tests that a foreach around It never created by @andreasjordan in #10484
• CI - Kill a wedged test file fast instead of burning the 90 minute job timeout by @potatoqualitee in #10483
• Tests - Stop Get-DbaBuild from downloading the build reference index during a unit test by @andreasjordan in #10488
• Tests - Make the assertions that could never fail actually assert by @andreasjordan in #10486
• Docs - Make tests/CLAUDE.md the single source for the test standards by @andreasjordan in #10485
• Install-DbaFirstResponderKit: Added ability to create certificates to let public execute FRK procedures by @ReeceGoding in #10463
• CI - Fix the two things stopping @claude from doing work by @potatoqualitee in #10489
• Tests - Standardise the last four parameter validation tests by @andreasjordan in #10491
• Tests - Recover two skipped tests and give the rest a reason for being skipped by @andreasjordan in #10490
• Tests - Rename two test files to match the command they test by @andreasjordan in #10492
• Get-DbaDbFile - Read the file layout from master when a database cannot be opened by @potatoqualitee in #10496
• TEPP - Start the asynchronous cache runspace on the first tab completion instead of at import by @potatoqualitee in #10494
• runner fleet - Size CI runner lanes to queued work and instrument VM lifetimes by @potatoqualitee in #10493
• Get-DbaUnusedLogin - Match the login name case-sensitively when reading last login time by @potatoqualitee in #10498
• Get-DbaDbFileGroup, Get-DbaDbLogSpace, Get-DbaDbSpace and Get-DbaDbVirtualLogFile - Warn instead of silently skipping a database that cannot be opened by @potatoqualitee in #10499
• CI - Add restricted Codex issue agent by @potatoqualitee in #10497
• Claude workflows - Fix bubblewrap home mount setup by @potatoqualitee in #10502
• runner fleet - Restore maintainer capacity and repair VMSS drift by @potatoqualitee in #10500
• Stop the test heartbeat from failing the stage when the watchdog is reading it by @potatoqualitee in #10503
• CI - Rename Azure Codex issue trigger by @potatoqualitee in #10501
• CI - Cancel superseded ci-azure runs so the newest head owns the lane (do Get-DbaBuild) by @potatoqualitee in #10504
• Use SqlClient SSPI provider for Windows credentials by @potatoqualitee in #10495
• Run the VMSS runner fleet from an Azure Function instead of a five-minute Actions cron by @potatoqualitee in #10506
• Start-DbaAzMigration - Add Azure SQL BACPAC migration by @potatoqualitee in #10505
• Stop the potato CI marker from skipping every merge to development by @potatoqualitee in #10508
• CI runners - Replace the bootstrap reboot and autologon with a LocalSystem runner service by @potatoqualitee in #10509
• Invoke-DbaDbIndexRebuild - Add index and heap maintenance command by @potatoqualitee in #10507
• Bump the github-actions group with 2 updates by @dependabot[bot] in #10510
• ci-azure - Skip the Windows SSPI test when the build exits early by @potatoqualitee in #10515
• ps3-smoke - retry teardown deletes and warn when resources leak by @potatoqualitee in #10516
• Invoke-ManualPester - Check the test file and the repository style gate by @andreasjordan in #10518
• InModule.Help - Make the help tests actually run by @andreasjordan in #10519
• Docs - Point CI documentation at ci-azure instead of AppVeyor by @andreasjordan in #10521
• Pester 6 - Drop stale v4/v5 references and take the version out of names by @andreasjordan in #10520
• Data generation - Make the supported randomizer types match what actually generates by @andreasjordan in #10517
• Copy-DbaDatabase - Fix empty -NewName destination sweep and piped multi-database failures by @potatoqualitee in #10514
• Tests - Replace the $env:APPVEYOR skips with real preconditions by @andreasjordan in #10522
• Enable-DbaFilestream - Report what the WMI provider actually returned by @andreasjordan in #10525
• Import-DbaParquet - Report why the Parquet assemblies could not be loaded by @andreasjordan in #10526
• New-DbaDacPackage - Report the real reason model validation failed by @andreasjordan in #10527
• New-DbaFirewallRule - Stop blaming a disabled DAC for a cycled ERRORLOG by @andreasjordan in #10528
• Set-DbaLogin - Return the login as it is after unlocking it with a new password by @andreasjordan in #10530
• Tests - Run without warnings and fix test cases that never ran by @andreasjordan in #10531
• Tests - Stop writing a file called null into the current directory by @andreasjordan in #10532
• Query Store - Warn instead of silently skipping named system databases by @andreasjordan in #10533
• Test-DbaPath - Silence the expected warnings of the mocked failure tests by @andreasjordan in #10534
• Fleet controller - Compensate VMSS capacity for phantom drift one settled mutation at a time by @potatoqualitee in #10540
• Import-DbaParquet - Stop leaving an assembly resolver registered for the whole process by @andreasjordan in #10541
• Query Store - Silence the expected warnings of the system database tests by @andreasjordan in #10535
• Install-DbaParquet - Keep the assemblies of the two PowerShell editions apart by @andreasjordan in #10538
• Import-DbaParquet - Release the parquet file when the import is done by @andreasjordan in #10543
• Install-DbaCommunitySoftware - add unified community tooling installer (do Install-DbaCommunitySoftware) by @potatoqualitee in #10565
• Connect-DbaInstance / Invoke-DbaQuery - Do not close connections of the caller and do not reuse them for the wrong database by @andreasjordan in #10564
• Set-DbaDbQueryStoreOption - Run the ALTER DATABASE statements on the server connection by @andreasjordan in #10558
• Issue skill - Read the issue body and its comments in one call by @andreasjordan in #10553
• Export-DbaInstance - Script us_english custom errors before their translations by @andreasjordan in #10552
• Save-DbaCommunitySoftware - Accept an array of Software values, add All by @potatoqualitee in #10545
• Set-DbaPrivilege - Write secedit's working database to temp, not cwd by @potatoqualitee in #10544
• Tests - Stop leaving backup files behind in the lab by @andreasjordan in #10539
• CI - Skip Azure migration tests on Dependabot pushes by @potatoqualitee in #10566
• Bump the github-actions group across 1 directory with 2 updates by @dependabot[bot] in #10546
• Get-DbaDbExtentDiff - Leave the connection of the caller alone by @andreasjordan in #10567
• Update-DbaMaintenanceSolution - Update the procedures in the database that was named and leave the connection of the caller alone by @andreasjordan in #10568
• Import-DbaBinaryFile - Work with a connection that is already open by @andreasjordan in #10571
• Install-DbaMaintenanceSolution - Leave the connection of the caller alone by @andreasjordan in #10570
• SQL Server 2025 CU8 by @MikeyBronowski in #10574
• Import-DbaSpConfigure - Leave the connection of the caller alone and make the migration work again by @andreasjordan in #10575
• Invoke-DbaAdvancedRestore - Leave the connection of the caller alone by @andreasjordan in #10576
• Registered server commands - Leave the connection of the caller alone by @andreasjordan in #10577
• Testing Backup-DbaDatabase - Restore model after the all-databases backup test by @andreasjordan in #10582
• Bump anthropics/claude-code-action from 1.0.190 to 1.0.193 in the github-actions group by @dependabot[bot] in #10585
• Clarify private key permissions in Set-DbaNetworkCertificate help by @andreasjordan in #10586
• Get-DbaWsfc* - Fix the State property read from an undefined variable, and report the witness path by @andreasjordan in #10588
• Invoke-DbaDbDecryptObject - Add DataPages to decrypt without a dedicated admin connection by @howarthcd in #10581
• Add Find-DbaDbQueryStoreRegression by @deepeshd87 in #10589
• Invoke-DbaDbDecryptObject - reject ambiguous ciphertext chunks by @potatoqualitee in #10591
• Database context - Run server level statements on the connection by @andreasjordan in #10580
• Set-DbaDbQueryStoreOption - Refresh the Query Store options after changing them with T-SQL by @andreasjordan in #10593
• Get-DbaDbQueryStoreOption - Read from SMO what SMO carries, and query only the rest by @andreasjordan in #10592
• Copy-DbaSsisCatalog - Require SQL Server 2012 on the destination, as the help already promises by @andreasjordan in #10601
• Connect-DbaInstance - Make MinimumVersion decide on a version it can read by @andreasjordan in #10597
• Testing Get-DbaRandomizedValue - Decide emptiness without a culture sensitive comparison by @andreasjordan in #10599
• Copy-DbaAgentSchedule - Make -Force actually drop and recreate existing schedules by @andreasjordan in #10596
• Bump the github-actions group with 2 updates by @dependabot[bot] in #10598
• Testing Get-DbaDbQueryStoreOption - Create the database before anything has read model by @andreasjordan in #10595
• Connect-DbaInstance - Give the cloned server ownership of its database connection by @andreasjordan in #10584
• Database context - Put the database back in the Query and Invoke script methods by @andreasjordan in #10579
• Database context - Add Restore-DatabaseContext and fix eighteen commands by @andreasjordan in #10603
• New-DbaFirewallRule - Adapt the tests to a default instance on the default port by @andreasjordan in #10605
• Rename-DbaDatabase - Build expected file paths without validating drives of the test client by @andreasjordan in #10606
• Remove-DbaAgDatabase - Honor the AvailabilityGroup filter by @andreasjordan in #10608
• Remove-DbaAgListener - Honor the AvailabilityGroup filter by @andreasjordan in #10609
• Get-DbaDbTable - Make IncludeSystemDBs actually exclude system databases by default by @andreasjordan in #10610
• Get-DbaDiskSpace - Make Unit work and clean up the two other dead parameters by @andreasjordan in #10611
• Testing Get-DbaNetworkConfiguration - Certify the virtual name of a cluster instance by @andreasjordan in #10613
• Test-DbaDiskAlignment - Reach a failover cluster instance through its virtual name by @andreasjordan in #10614
• Set-DbaTempDbConfig - Make forced file removal survive work tables and stop resetting the log growth by @andreasjordan in #10615
• Get-DbaPrivilege, Set-DbaPrivilege - Pass the credential to the connectivity test and the service discovery by @andreasjordan in #10616
• Data generation - Stop on configuration errors and write the generated unique values by @andreasjordan in #10618
• Testing New-DbaDbDataGeneratorConfig - Guard columntypes.json against the randomizer types by @andreasjordan in #10619
• Testing Get-DbaDbRestoreHistory - Give every backup its own file so the diff always finds its full by @andreasjordan in #10620
• Get-DbaWaitingTask - Harden flaky test setup and fix always-null InfoUrl by @andreasjordan in #10622
• Fix case sensitivity defects in 15 test files by @andreasjordan in #10623
• Get-DbaDbMailHistory - Make the Status filter work on case sensitive instances by @andreasjordan in #10624
• Get-DbaDbMailLog - Make the Type filter work on case sensitive instances by @andreasjordan in #10625
• Install-DbaWhoIsActive - Detect an existing installation on case sensitive instances by @andreasjordan in #10626
• Set-DbaDbFileGroup - Resolve filegroups reliably on case sensitive databases by @andreasjordan in #10627
• Keep version groups out of the leftover-lane exclusion by @andreasjordan in #10629
• Move the two mixed-instance test files wholly into the MULTI lane by @andreasjordan in #10628
• Testing Find-DbaCommand - Restore the index file the Rebuild test overwrites by @andreasjordan in #10630
• Get-DbaAgBackupHistory - Fix single replica discovery and honor EnableException by @andreasjordan in #10632
• Add-DbaRegServer - Close the store connection its verification call reopens by @andreasjordan in #10633
• Export-DbaCsv - Close the database-scoped connection it opens per call by @andreasjordan in #10634
• Get-DbaXESession - Close the cloned connection behind the XEStore by @andreasjordan in #10635
• Get-DbaDatabase - Stop eating the caller loop on invalid parameter combination by @andreasjordan in #10637
• Get-DbaRandomizedValue - Stop eating the caller loop on invalid parameters by @andreasjordan in #10640
• Test-DbaLastBackup - Stop eating the caller loop on inaccessible directories by @andreasjordan in #10639
• Import-DbaSpConfigure - Stop eating the caller loop and skipping its own cleanup by @andreasjordan in #10641
• New-DbaAvailabilityGroup - Let the validation guards reach their own return by @andreasjordan in #10642
• Log shipping - Let helper failures reach the caller instead of escaping it by @andreasjordan in #10644
• Get-DbaRandomizedDataset - Stop eating the caller loop on template validation by @andreasjordan in #10645
• Import-DbaBinaryFile - Stop eating the caller loop on FilePath validation by @andreasjordan in #10646
• New-DbaDbDataGeneratorConfig - Stop eating the caller loop on failures by @andreasjordan in #10647
• Get-DbaRandomizedType - Stop eating the caller loop when the type list is missing by @andreasjordan in #10648
• Invoke-DbaDbDataGenerator - Stop eating the caller loop when Bogus fails to load by @andreasjordan in #10649
• Convert-DbaMaskingValue - Stop eating the caller loop on missing input by @andreasjordan in #10650
• New-DbaReplSubscription - Remove the latent continue escape and guard the process block by @andreasjordan in #10652
• Set-DbaAgentOperator - Stop eating the caller loop on connection failure by @andreasjordan in #10653
• Invoke-DbaPfRelog - Stop eating the caller loop when no blg files match by @andreasjordan in #10643
• Add-DbaReplArticle - Stop eating the caller loop on parameter validation by @andreasjordan in #10651
• Add-DbaAgListener - Stop demanding databases the command does not know by @andreasjordan in #10612
• Get-DbaWsfcResourceGroup - Name the PartialOnline and Pending states of a resource group by @andreasjordan in #10673
• Set-DbaNetworkCertificate - Say why a private key is unsuitable by @andreasjordan in #10671
• Tests - Case sensitive lookups and backup cleanup in seven test files by @andreasjordan in #10670
• Install-DbaFirstResponderKit - Use the declared variable name when cloning the certificate to master by @andreasjordan in #10669
• Get-DbaComputerCertificate - Keep the friendly name of certificates on remote computers by @andreasjordan in #10668
• SSIS commands - Say why they refuse to run on PowerShell 7 by @andreasjordan in #10665
• Policy Based Management - Run on PowerShell 7 on Windows by @andreasjordan in #10664
• Connect-DbaInstance - Keep the tab completion cache of instance names an array by @andreasjordan in #10672
• Security updates for SQL 2025, 2022, 2019, 2017 - September 8, 2026 by @MikeyBronowski in #10681
• Bump the github-actions group with 2 updates by @dependabot[bot] in #10663
• Copy-DbaDbTableData - Close the source reader when the bulk copy fails by @andreasjordan in #10686
• Invoke-DbaDbLogShipping - Give the helper failure test a UNC shared path on CI by @andreasjordan in #10684
• Get-DbaWindowsLog - Compile the remote script inside the pool runspace so local instances do not hang by @andreasjordan in #10683
• Copy-DbaDbTableData - Name the Query requirement in the parameter guard message by @andreasjordan in #10678
• Get-BulkRowsCopiedCount - Read the rows copied counter as Int64 by @andreasjordan in #10677
• Invoke-DbaDbDecryptObject - Read the family GUID from sys.database_recovery_status instead of DBCC DBINFO by @howarthcd in #10680
• Restore-DbaDatabase - Honor EnableException in the backup information pipeline by @andreasjordan in #10631
• Restore-DbaDatabase - Stop escaping the caller and resurrect the StopAt tests by @andreasjordan in #10636
• Workflows - Pull MinIO from quay.io and mc from GitHub releases by @andreasjordan in #10688
• Password decryption commands - Document the remote DAC prerequisite by @andreasjordan in #10551
• Copy-DbaDatabase - Name -AllDatabases in the examples that migrate every database by @andreasjordan in #10689
• Workflows - Wait for the SQL Server containers before running the core tests by @andreasjordan in #10690
• Invoke-DbaQuery - Close the connection it opened when the query fails by @andreasjordan in #10691
• Progress bars - Complete the bars that 22 commands left behind by @andreasjordan in #10660
• Restore-DbaDatabase - Say that nothing was restored when the selection is empty by @andreasjordan in #10692
• Pin dbatools.library to 2.x SSPI by @potatoqualitee in #10716
• Bump the github-actions group with 2 updates by @dependabot[bot] in #10715
• Copy-DbaDbTableData - Map query columns onto the writable destination columns by @andreasjordan in #10666
• Install-DbaMaintenanceSolution - Close the connection it opened when it skips an instance by @andreasjordan in #10693
• Update-DbaMaintenanceSolution - Close the connection it opened when it skips an instance by @andreasjordan in #10694
• Get-DbaDbObjectTrigger - Stop eating the caller loop on an input object that is not a table or view by @andreasjordan in #10697
• Stop-DbaExternalProcess - Stop eating the caller loop when the process cannot be stopped by @andreasjordan in #10698
• Remove-DbaXESession - Return the store connection after removing a session by @andreasjordan in #10712
• Stop-DbaXESession - Return the store connection after stopping a session by @andreasjordan in #10711
• Dead parameters - Wire up seven parameters that were declared and documented but never read by @andreasjordan in #10708
• Command invariants - Add the missing Test-FunctionInterrupt guards and fix the Test-Bound typo in Export-DbaExecutionPlan by @andreasjordan in #10707
• Invoke-DbaDbDecryptObject - Stop eating the caller loop when the export folder cannot be created by @andreasjordan in #10706
• Convert-DbaIndexToTable - Stop eating the caller loop when no instance is given by @andreasjordan in #10705
• Get-LoginPasswordHash - Stop eating the caller loop when the hash query fails by @andreasjordan in #10704
• Expand-DbaDbLogFile - Stop eating the caller loop when the log file processing fails by @andreasjordan in #10703
• Export-DbaDacPackage - Stop eating the caller loop when only ExcludeDatabase is given by @andreasjordan in #10702
• New-DbaAzAccessToken - Stop eating the caller loop when the token request fails by @andreasjordan in #10700
• Get-DbaWaitResource - Stop eating the caller loop on connection failure by @andreasjordan in #10699
• Start-DbaXESession - Return the store connection after starting a session by @andreasjordan in #10710
• 2026 sept CUs by @niphlod in #10719
• Get-DbaBackupInformation - Stop eating the caller loop when a backup header cannot be read by @andreasjordan in #10701
• Copy-DbaDatabase - Stop eating the caller loop when a system database is requested by @andreasjordan in #10696
• Invoke-DbaAdvancedRestore - Stop applying logs once the stop mark is reached by @andreasjordan in #10695
• Enable-DbaAgHadr, Disable-DbaAgHadr - Report a refused service restart instead of ignoring it by @andreasjordan in #10709

New Contributors

• @deepeshd87 made their first contribution in #10589

Full Changelog: v2.8.4...v2.9.0