dbatools Files

What's Changed

• speedup dependency detection for integration tests by @niphlod in https://github.com/dataplat/dbatools/pull/10179
• Minor test fixes for Connect-DbaInstance by @andreasjordan in https://github.com/dataplat/dbatools/pull/10175
• Add command Test-DbaNetworkCertificate by @andreasjordan in https://github.com/dataplat/dbatools/pull/10178
• Get-DbaDbTable: Fix for Azure SQL Database by @andreasjordan in https://github.com/dataplat/dbatools/pull/10182
• Test-DbaLsnChain: Fix bug in case log backup is taken during full backup by @andreasjordan in https://github.com/dataplat/dbatools/pull/10185
• Backup-DbaDatabase: Respect explicit FileCount when using StorageBaseUrl (S3/Azure) by @andreasjordan in https://github.com/dataplat/dbatools/pull/10186
• Copy-DbaDatabase: Fix renaming for database names with special characters by @andreasjordan in https://github.com/dataplat/dbatools/pull/10187
• Start-DbaDbEncryption: Add missing parameter and fix documentation by @andreasjordan in https://github.com/dataplat/dbatools/pull/10191
• Import-DbaCsv - Fix RFC 4180 multiline quoted field handling by @mbentham in https://github.com/dataplat/dbatools/pull/10190
• Import-DbaCsv: Add -NoColumnOptimize switch by @mbentham in https://github.com/dataplat/dbatools/pull/10195
• Test-DbaLsnChain: Fix bug when reading history from file by @andreasjordan in https://github.com/dataplat/dbatools/pull/10201
• Get-DbaAgentJob and Sync-DbaAvailabilityGroup: Move filter for MSX jobs to the command that needs it by @andreasjordan in https://github.com/dataplat/dbatools/pull/10198
• Test-DbaBackupInformation: Add member IsVerified to output if not already present by @andreasjordan in https://github.com/dataplat/dbatools/pull/10200
• Connect-DbaInstance: Use localhost for dedicated admin connections to avoid multiple IP resolution on multi-homed servers by @andreasjordan in https://github.com/dataplat/dbatools/pull/10199
• Export-DbaLogin: Add -IncludeRolePermissions switch by @mbentham in https://github.com/dataplat/dbatools/pull/10196
• Get-DbaUserPermission: Fix incorrect schema name shown as 'STIG' by @andreasjordan in https://github.com/dataplat/dbatools/pull/10210
• Export-DbaInstance: Propagate -EnableException to sub-commands and wrap exports in try-catch by @andreasjordan in https://github.com/dataplat/dbatools/pull/10211
• Get-DbaReportingService: Use Credential in every call to Get-DbaCmObject by @andreasjordan in https://github.com/dataplat/dbatools/pull/10207
• New-DbaLogin: add ExternalGroup support and SQL Server 2022 Entra login handling by @andreasjordan in https://github.com/dataplat/dbatools/pull/10225
• Get-DbaStartupParameter: Fix multiple issues by @andreasjordan in https://github.com/dataplat/dbatools/pull/10208
• Test-DbaKerberos: Remove CNAME test by @andreasjordan in https://github.com/dataplat/dbatools/pull/10209
• Update-DbaInstance: Fall back to computer name if Resolve-DbaNetworkName fails by @andreasjordan in https://github.com/dataplat/dbatools/pull/10212
• New-DbaDbMailProfile - Fix to allow multiple accounts per profile by @andreasjordan in https://github.com/dataplat/dbatools/pull/10214
• Connect-DbaInstance: Auto-retry with Initial Catalog=master for mirrored SQL Server instances by @andreasjordan in https://github.com/dataplat/dbatools/pull/10215
• Export-DbaScript: Handle Distributed Availability Groups gracefully by @andreasjordan in https://github.com/dataplat/dbatools/pull/10216
• Get-DbaReplSubscription: Also check distribution DB for pull subscriptions missing from syssubscriptions by @andreasjordan in https://github.com/dataplat/dbatools/pull/10218
• Invoke-DbaDbLogShipping: Add -IgnoreFileChecks parameter by @andreasjordan in https://github.com/dataplat/dbatools/pull/10219
• Copy-DbaPolicyManagement: Add ObjectSets migration by @andreasjordan in https://github.com/dataplat/dbatools/pull/10220
• Get-DbaDb[StoredProcedure|Table|Udf|View]: Wrap all ClearAndInitialize in try-catch-block by @andreasjordan in https://github.com/dataplat/dbatools/pull/10226
• Backup-DbaDatabase: Prevent duplicate dbname when using CreateFolder with ReplaceInName by @andreasjordan in https://github.com/dataplat/dbatools/pull/10224
• Invoke-DbaDbDataMasking: Fix MaskingID column and index left behind after masking by @andreasjordan in https://github.com/dataplat/dbatools/pull/10223
• Invoke-DbaDbDataMasking: Fix Deterministic masking not applied with multiple columns by @andreasjordan in https://github.com/dataplat/dbatools/pull/10222
• Read-DbaXEFile: Fix database_name and other action columns being empty by @andreasjordan in https://github.com/dataplat/dbatools/pull/10221
• March 2026 CVEs by @niphlod in https://github.com/dataplat/dbatools/pull/10230
• Remove Invoke-SmoCheck - no longer needed by @andreasjordan in https://github.com/dataplat/dbatools/pull/10229
• Set-DbaPrivilege: Use per-service SID (NT SERVICE\ServiceName) for IFI, LPIM, SecAudit by @andreasjordan in https://github.com/dataplat/dbatools/pull/10228

New Contributors

• @mbentham made their first contribution in https://github.com/dataplat/dbatools/pull/10190

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.7.25...v2.7.26