v2.1.24

What's Changed

• Export-DbaUser - Fix Passthru duplicates by @potatoqualitee in #9463
• Security updates for SQL 2022, 2019, 2017, 2016 by @MikeyBronowski in #9466

Full Changelog: v2.1.23...v2.1.24

v2.1.23

What's Changed

• Update dbatools-buildref-index.json SQL 2019 CU28 by @MikeyBronowski in #9438
• Make Get-DbaPrivilege more efficient by @mrahman-DBA in #9436
• Reset-DbaAdmin: Fix parameter name by @andreasjordan in #9435

New Contributors

• @mrahman-DBA made their first contribution in #9436

Full Changelog: v2.1.22...v2.1.23

v2.1.22

Thanks for keeping us all updated, @MikeyBronowski !

What's Changed

• Update dbatools-buildref-index.json SQL2022 CU14 by @MikeyBronowski in #9431

Full Changelog: v2.1.21...v2.1.22

v2.1.21

What's Changed

• Get-DbaLatchStatistic: Fix division by zero by @andreasjordan in #9427
• Test-DbaDbRecoveryModel: Fix for instances with case sensitive collation by @michele-tahay-kohera in #9425
• Typos Update Get-DbaDbccHelp.ps1 by @MikeyBronowski in #9424

New Contributors

• @michele-tahay-kohera made their first contribution in #9425

Full Changelog: v2.1.20...v2.1.21

v2.1.20

What's Changed

• Security updates for SQL 2022, 2019, 2017, 2016 by @MikeyBronowski in #9422
• Get-DbaDbStoredProcedure: Moved Test-Bound -ParameterName ExcludeSystemSp outside of nested loop by @ReeceGoding in #9419
• Get-DbaDbUdf ExcludeSystemUdf correct logic by @pollusb in #9417
• Get-DbaPermission does not process DENY by @pollusb in #9416
• ExcludeSystemUser correct logic in Get-DbaDbUser by @pollusb in #9415
• Update tests to be able to run them outside of AppVeyor (part 2) by @andreasjordan in #9413

Full Changelog: v2.1.19...v2.1.20

v2.1.19

yet another @andreasjordan release 😅 thank you greatly!

What's Changed

• New-DbaDbUser: Refactoring and bugfixing by @andreasjordan in #9386
• Always use same description for EnableException by @andreasjordan in #9395
• Get-DbatoolsError: Use FullyQualifiedErrorId to filter $global:error by @andreasjordan in #9397
• Add MSA example by @ben-thul in #9400
• Tests: Use Force while importing module to export aliases by @andreasjordan in #9404
• Get-DbaDbDetachedFileInfo: Added new versions by @andreasjordan in #9407
• Fix .Query() and .Invoke() on server for special connections and enhance exception text by @andreasjordan in #9410
• Get- and Copy-DbaDbQueryStoreOption: Fix DBNull issue and add missing Notes property by @andreasjordan in #9409
• Update tests to be able to run them outside of AppVeyor by @andreasjordan in #9406
• Write-DbaDbTableData: Fix for connections to Azure SQL Database with AccessToken by @andreasjordan in #9401
• Export-DbaUser - Refactor T-SQL User-Role Scripting to Eliminate Dependencies by @0x7FFFFFFFFFFFFFFF in #9232

Full Changelog: v2.1.18...v2.1.19

v2.1.18

What's Changed

• Fix for ConvertTo-DbaDataTable tests by @jpomfret in #9384
• Update dbatools-buildref-index.json SQL2019 CU27 by @MikeyBronowski in #9393
• Get-DbaRegServer.ps1: Added Wildcard by @ReeceGoding in #9391
• New-DbaAgentSchedule: Fix issues with testing for correct dates and times by @andreasjordan in #9389

Full Changelog: v2.1.17...v2.1.18

v2.1.16

What's Changed

• Install-DbaInstance: Enable Instant File Initialization using setup.exe parameter by @andreasjordan in #9358
• Invoke-DbaDbLogShipping: Remove Credential from New-Item by @andreasjordan in #9359
• Backup-DbaDbMasterKey - Output filename property with file extention by @andreasjordan in #9360
• ConvertTo-DbaDataTable handle Dataplat.Dbatools.Utility.DbaDateTime as an array by @jpomfret in #9361
• Write-DbaDbTableData - Fail AutoCreateTable if no column definition available by @andreasjordan in #9362

Full Changelog: v2.1.15...v2.1.16

v2.1.17

What's Changed

• Import Tests - Add macos 14, which is arm64 by @potatoqualitee in #9365
• better docs rendering, aligned with docs page by @niphlod in #9377
• Install-DbaFirstResponderKit - Use new script names by @andreasjordan in #9372
• Get-DbaProcess: Fix for empty most_recent_sql_handle by @andreasjordan in #9375
• Support OwnerLoginName in New-DbaAgentSchedule by @david-garcia-garcia in #9370
• Connect-DbaInstance: Fix problems with DAC by @andreasjordan in #9376
• New-DbaAgentJobStep: Fix for using DatabaseUser by @andreasjordan in #9380

Full Changelog: v2.1.16...v2.1.17

v2.1.15

What's Changed

• Update Set-DbaNetworkCertificate to work with PowerShell Core when using RSA certificates by @mwilsonin in #9342
• New Support for Contained Availability Groups by @serenefiresiren in #9345
• Backup-DbaDatabase : add a new switch parameter "NoAppendDbNameInPath" to prevent dbname systematically appended at the end of backup path by @rferraton in #9348
• New-DbaAvailabilityGroup: Add support for contained availability groups by @DorBreger in #9352
• ConvertTo-DbaDataTable - Fix DbaDateTime issue by @potatoqualitee in #9353
• Update dbatools-buildref-index.json SQL 2022 CU13 by @MikeyBronowski in #9354

New Contributors

• @mwilsonin made their first contribution in #9342
• @serenefiresiren made their first contribution in #9345
• @rferraton made their first contribution in #9348
• @DorBreger made their first contribution in #9352

Full Changelog: v2.1.14...v2.1.15