What's Changed

• Test-DbaKerberos - Fix Server-DC time sync for non-admin users by @potatoqualitee in #10075
• Refactor test scenarios by @andreasjordan in #10070
• Fix tests so that they work against a Failover Cluster Instance by @andreasjordan in #10079
• Update Pester version to 5.7.1 by @andreasjordan in #10084
• Get-DbaService: Add property SqlInstance when using parameter AdvancedProperties to support Failover Cluster Instances by @andreasjordan in #10082
• Some small improvements by @andreasjordan in #10081
• Next round of using new test scenarios by @andreasjordan in #10087
• Fix test for Import-DbaPfDataCollectorSetTemplate to support FCI by @andreasjordan in #10093
• Install-DbaSqlPackage: Refactor command to fix issues while testing existing installation by @andreasjordan in #10092
• Invoke-TlsWebRequest: Make Invoke-WebRequest faster by @andreasjordan in #10091
• Test-DbaDiskAllocation: Refactor command by @andreasjordan in #10086
• Start-DbaDbEncryption: Fix issues with parallel processing by @andreasjordan in #10083
• Move more tests to new scenarios by @andreasjordan in #10090
• Improve tests to be more flexible by @andreasjordan in #10096
• Security updates for SQL 2022 - January 13, 2026 by @MikeyBronowski in #10098
• SQL Server 2022 CU23 + SQL Server 2025 CU1 + Security Update by @MikeyBronowski in #10099
• Test Improvements: Move last tests to new scenarios by @andreasjordan in #10100

Full Changelog: v2.7.20...v2.7.21

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

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

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

Had to bump the dbatools library

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

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

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.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

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! 🤩