v2.7.20

What's Changed

• Add detailed .OUTPUTS documentation by @potatoqualitee in #10072
• New-DbaDacPackage - Fix DacMessageType namespace in validation check by @potatoqualitee in #10076

Full Changelog: v2.7.19...v2.7.20

v2.7.19

What's Changed

• Test-DbaKerberos - Update documentation and examples, release from pipeline earlier by @potatoqualitee in #10071

Full Changelog: v2.7.18...v2.7.19

v2.7.18

Updated to the new library which added some CSV features https://github.com/dataplat/dbatools.library/releases/tag/v2025.12.28

v2.7.16

Had to bump the dbatools library

v2.7.15

What's Changed

• Sync-DbaLoginPermission / Update-SqlPermission: Fix bug when enabling or disabling login by @andreasjordan in #10061
• Some more test fixes to support remote instances by @andreasjordan in #10060
• Import-DbaCsv - Preserve user-provided SQL connections by @potatoqualitee in #10063
• Start-DbaMigration - Add -SetSourceOffline to set databases offline during migration by @potatoqualitee in #10013

Full Changelog: v2.7.14...v2.7.15

v2.7.14

What's Changed

• Import-DbaCsv - Smart Type Detection & Column Optimization by @potatoqualitee in #10036
• DbaAvailabilityGroup - Add ClusterConnectionOption parameter with TLS 1.3 encryption support by @potatoqualitee in #10035
• Update test for Backup-DbaDatabase to support remote instances by @andreasjordan in #10045
• Set-DbaDbQueryStoreOption: Fix bug with incorrect sql by @andreasjordan in #10050
• Get-DbaDbDetachedFileInfo: Add support for SQL Server 2025 by @andreasjordan in #10053
• Find-DbaInstance: Test correct port by @andreasjordan in #10052
• Set-FileSystemSetting: Force array to always get count by @andreasjordan in #10051
• Expand-DbaDbLogFile - Fix infinite loop in Docker containers and improve automation support by @potatoqualitee in #10049
• Copy-DbaCredential - Update documentation to reflect reality by @Ant-Green in #10041
• Compare-DbaAgReplicaSync - Add new command to report AG replica sync differences by @potatoqualitee in #10048
• Get-DbaStartupParameter - Fix -Simple parameter not being passed to scriptblock by @potatoqualitee in #10027
• Fix some tests to support remote instances by @andreasjordan in #10054
• Add -ForceExplicitMapping parameter to Copy-DbaDbTableData by @wikjoh in #10038
• Copy-DbaAgentJobStep - Add new command to synchronize job steps without destroying history by @potatoqualitee in #10058
• Introduce New-DbaDacPackage for source-based DACPAC builds and improve DacFx clarity in exports by @potatoqualitee in #10059

New Contributors

• @wikjoh made their first contribution in #10038

Full Changelog: v2.7.13...v2.7.14

v2.7.12

What's Changed

• Import-DbaCsv - Move library to Dataplat.Dbatools.Csv 😍 + Export-DbaCsv by @potatoqualitee in #10005

All new Csv library! Coming soon to nuget.

Full Changelog: v2.7.10...v2.7.12

v2.7.10

v2.7.9 had a library version error and has been delisted, on to v2.7.10!

What's Changed

• Export-DbaDacPackage - Add thread-safe database enumeration and SQL Server version check by @potatoqualitee in #9981
• Copy-DbaAgentJob - Fix regression where -Job parameter prevents copying all jobs by @potatoqualitee in #9983
• Set-DbaAgReplica - Fix silent failure with simple ReadOnlyRoutingList arrays by @potatoqualitee in #9988
• Get-DbaAgentSchedule - Fix SMO cache refresh issue by @potatoqualitee in #9989
• Copy-DbaLogin - Add safety check to prevent self-lockout when dropping Windows groups by @potatoqualitee in #9948
• New-DbaAvailabilityGroup - Warn when ConnectionModeInSecondaryRole is used on Standard Edition by @potatoqualitee in #9991
• New-DbaDbTable - Fix IsNode and other switch parameters being ignored by @potatoqualitee in #9990
• Compare-DbaAgReplica* commands - Remove invalid EnableException parameter by @potatoqualitee in #9994
• Install-DbaInstance - Add SQL Server 2025 support by @potatoqualitee in #9995
• SQL 2025 SupportedUntil 2036-01-06 by @MikeyBronowski in #9998
• Get-DbaDatabase - Add T-SQL fallback for Size/SizeMB property by @potatoqualitee in #9996
• Service commands - Fix credential passing through Update-ServiceStatus by @potatoqualitee in #9997
• Get-DbaDatabase - Fix Azure SQL Database sys.master_files error by @potatoqualitee in #10001

Full Changelog: v2.7.8...v2.7.10

v2.7.8

What's Changed

• SQL Server 2022 CU22 by @MikeyBronowski in #9975
• Adds SQL 2025 GA by @MikeyBronowski in #9978

Full Changelog: v2.7.7...v2.7.8

Thanks to super-star @MikeyBronowski for this one! 🤩

v2.7.7

Thank you to our 4 new contributors + claude 🤖 This is a big one which includes updates to dbatools.library. Also, check out the updated website at https://dbatools.io.

New Commands Added

1. Add-DbaDbFile - Create new command to add files to database filegroups
2. Compare-DbaAgReplicaAgentJob - Compare Agent Jobs between Availability Group replicas
3. Compare-DbaAgReplicaCredential - Compare Credentials between Availability Group replicas
4. Compare-DbaAgReplicaLogin - Compare Logins between Availability Group replicas
5. Compare-DbaAgReplicaOperator - Compare Operators between Availability Group replicas
6. Compare-DbaAvailabilityGroup - Compare Availability Group configurations
7. Copy-DbaExtendedStoredProcedure - Copy Extended Stored Procedures between SQL Server instances
8. Copy-DbaServerRole - Copy Server Roles between SQL Server instances
9. Get-DbaAgDatabaseReplicaState - Get the replica state of databases in Availability Groups
10. Sync-DbaLoginPassword - Synchronize login passwords between SQL Server instances

Renamed Commands

1. Invoke-DbaAzSqlDbTip → Invoke-DbaDbAzSqlTip (renamed for consistency)

What Else's Changed

• Fix Get-DbaSchemaChangeHistory when no trace file exists by @SylvainDuran in #9852
• Test-DBALsnChain - Fix NullArray exception by @Philippe-Eversa in #9856
• Add server name to removal message in Remove-DbaDbUser for WhatIf clarity by @SylvainDuran in #9858
• Correct retrieval of server name in Remove-DbaCredential by @SylvainDuran in #9860
• Fix Set-DbaAgentJobStep: Add proxy removal support and prevent unwanted parameter resets by @SylvainDuran in #9861
• Fix Remove-DbaAgentJob to continue processing when jobs don't exist by @SylvainDuran in #9863
• Add Claude Code GitHub Workflow by @potatoqualitee in #9868
• Add secure credential storage guidance to readme by @potatoqualitee in #9872
• Copy-DbaDbTableData - Add documentation for temporal tables by @potatoqualitee in #9869
• Write-Progress - Add Completed and fix in multiple commands by @potatoqualitee in #9870
• New-DbaDbSnapshot - Add .Refresh() calls to fix AG secondary snapshots by @potatoqualitee in #9875
• Test-DbaLastBackup - Add Checksum parameter support by @potatoqualitee in #9874
• Restore-DbaDatabase - Fix ReplaceDbNameInFile to only replace filename, not directory path by @potatoqualitee in #9873
• Add-DbaAgDatabase - Add NoWait parameter to skip seeding wait by @potatoqualitee in #9878
• Sync-DbaAvailabilityGroup - Fix null reference errors when syncing empty Agent objects by @potatoqualitee in #9877
• Test Suite Runner - Add auto test selection based on changed files by @niphlod in #9882
• Copy-DbaDatabase - Fix SetSourceOffline to only run on successful copy by @potatoqualitee in #9880
• Stop-DbaService, Start-DbaService - Add PolyBase and Launchpad service type support by @potatoqualitee in #9879
• Invoke-DbaDbPiiScan - Fix TEXT, NTEXT, XML column handling by @peterkruis in #9890
• Update-DbaInstance - Fix NoPendingRenameCheck parameter not being passed to Test-PendingReboot by @niphlod in #9893
• Update Claude Code GitHub Workflow by @potatoqualitee in #9894
• Rename-DbaDatabase - Fix ReplaceBefore parameter error with empty strings by @potatoqualitee in #9888
• Enable-DbaAgHadr - Improve error message to show actual failure reason by @potatoqualitee in #9887
• Import-DbaCsv - Add support for custom delimiters by @potatoqualitee in #9884
• Compare-DbaAvailabilityGroup - Add commands to compare AG replica configurations by @potatoqualitee in #9886
• Remove-DbaReplArticle - Add replication library loading to fix Article type error by @potatoqualitee in #9892
• cut down appveyor's env matrix since we're now running serially by @potatoqualitee in #9896
• Publish-DbaDacPackage - Restore DacFxPath parameter functionality by @potatoqualitee in #9899
• Copy-DbaLogin - Protect BUILTIN\Administrators on SQL Server on Linux by @potatoqualitee in #9901
• Get-DbaDatabase - Add Pattern parameter for wildcard database filtering by @potatoqualitee in #9897
• Restore-DbaDbSnapshot - Add retry logic for deadlock errors by @potatoqualitee in #9900
• Invoke-DbaDbAzSqlTip - Rename function to match manifest exports by @jpomfret in #9903
• Get-DbaSchemaChangeHistory - Fix incorrect object type for indexes by @potatoqualitee in #9906
• Get-DbaCmObject - Add configurable CIM operation timeout by @potatoqualitee in #9905
• import.ps1 - Remove AlwaysBuildLibrary configuration by @potatoqualitee in #9907
• Connect-DbaInstance - Exclude ActiveConnections for SQL Server 2022+ to fix performance issue by @potatoqualitee in #9908
• Invoke-DbaAdvancedInstall - Add /q switch for Server Core compatibility by @potatoqualitee in #9898
• Add command Get-DbaAgDatabaseReplicaState as a first step for AG monitoring and health check by @andreasjordan in #9910
• Format-DbaBackupInformation - Fix cross-platform path handling for Windows to Linux restores by @potatoqualitee in #9913
• *-DbaDbTable - Add parameter aliases to standardize table name parameter by @potatoqualitee in #9912
• Get-DbaMemoryCondition - Remove outdated Microsoft KB URL reference by @potatoqualitee in #9914
• skip claude-issue* branches by @niphlod in #9920
• Export-DbaSysDbUserObject - Fix ScriptingOptionsObject parameter being ignored by @potatoqualitee in #9918
• Copy-DbaLinkedServer - Add DAC connection to prevent multiple DAC connection attempts by @andreasjordan in #9921
• Get-DbaNetworkCertificate - Fix warning parameter forwarding by @potatoqualitee in #9922
• Update-DbaInstance - Add UseSSL and Port parameters with configuration defaults by @potatoqualitee in #9923
• Copy-DbaDbTableData - Add support for ignoring computed columns by @potatoqualitee in #9915
• Add-DbaComputerCertificate - Add support for importing full certificate chain by @potatoqualitee in #9924
• Start-DbaDbEncryption, Stop-DbaDbEncryption - Add -Parallel switch for async execution by @potatoqualitee in #9916
• Remove-DbaDbUser - Fix Azure SQL Database compatibility by @potatoqualitee in #9933
• New-DbaAgent* - Add enhanced error handling for contained AG listeners by @potatoqualitee in #9925
• Copy-DbaDbTableData - Fix data ordering issue when copying tables without explicit ORDER BY by @potatoqualitee in #9927
• Add-DbaComputerCertificate, Start/Stop-DbaDbEncryption - Fix PFX certificate chain import and improve parallel encryption handling by @potatoqualitee in #9936
• Complete Pester 5 migration - Migrate final 4 meta-tests and fix duplicate test execution by @potatoqualitee in #9937
• New-DbaDbTransfer - Infer SSL/TLS settings from source connection by @potatoqualitee in #9930
• Get-DbaAgentJob, Remove-DbaAgentJob - Add validation for null/empty Job parameter by @potatoqualitee in #9931
• Get-DbaAgentJob - Optimize Database filter with hashtable lookup by @potatoqualitee in #9932
• Invoke-DbaDiagnosticQuery - Fix Azure SQL DB query execution with limited permissions by @potatoqualitee in #9917
• Copy-DbaDbMail - Fix InvalidCastException by explicitly casting SMO name properties to string by @potatoqualitee in #9926
• Sync-DbaLoginPassword - Add command to sync passwords using hashed values by @potatoqualitee in #9883
• Install-DbaMaintenanceSolution - Add backup parameters (ChangeBackupType, Compress, CopyOnly, Verify, CheckSum, ModificationLevel) by @potatoqualitee in #9939
• Tests - Filter and fix by @p...