dbatools

What's Changed

• Set-DbaTcpPort - add force switch by @lowlydba in https://github.com/dataplat/dbatools/pull/8403
• Invoke-DbaDbShrink: Ensure correct usage of the dbasize type for accurate verbose messages by @lancasteradam in https://github.com/dataplat/dbatools/pull/8404
• Get-DbaDependency - fix wrong IsSchemaBound property by @andreasjordan in https://github.com/dataplat/dbatools/pull/8412

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.107...v1.1.108

What's Changed

• Copy-DbaDbQueryStoreOption: Add DatabaseID to the result set by @lancasteradam in https://github.com/dataplat/dbatools/pull/8405

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.106...v1.1.107

What's Changed

• Added several security patches related to CVE-2022-29143 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/8397

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.105...v1.1.106

What's Changed

• Import-DbaCsv - Add actual progress by @MarkPflug in https://github.com/dataplat/dbatools/pull/8393
• Test-DbaDbDataGeneratorConfig - Add missing bigint as supported data type by @andreasjordan in https://github.com/dataplat/dbatools/pull/8388

New Contributors

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

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.104...v1.1.105

What's Changed

• Invoke-DbaDbDataGenerator - Test for MaskingType Random to support special masking types by @andreasjordan in https://github.com/dataplat/dbatools/pull/8390
• Restore-DbaDatabase: cleanup docs by @lowlydba in https://github.com/dataplat/dbatools/pull/8396

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.103...v1.1.104

What's Changed

• Update dbatools-buildref-index.json by @andreasjordan in https://github.com/dataplat/dbatools/pull/8391

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.102...v1.1.103

What's Changed

• Watch-DbaDbLogin - Add back support for 2008 and below by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8384
• Write-DbaDbTableData - Add more error handling by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8378

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.101...v1.1.102

What's Changed

• New-DbaDbUser - Refactoring #2 by @andreasjordan in https://github.com/dataplat/dbatools/pull/8377

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.100...v1.1.101

What's Changed

• Install-DbaMultitool: reflect new 'main' branch in tool repo by @lowlydba in https://github.com/dataplat/dbatools/pull/8376

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.99...v1.1.100

What's Changed

• New-DbaDbUser - Refactoring by @andreasjordan in https://github.com/dataplat/dbatools/pull/8372

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.98...v1.1.99

Get-DbaUserPermission - Fix collation conflict by @ClaudioESSilva
Set-DbaAgentSchedule - Support all FrequencySubdayType options by @ClaudioESSilva

Find-DbaOrphanedFile - Do not trim file name by @ClaudioESSilva
Import-DbaCsv - Fix ColumnMapper bug by @potatoqualitee

Copy-DbaDatabase - Detach/Attach Fix by @potatoqualitee
Add/New-DbaComputerCertificate - Add Flag support by @potatoqualitee
Get-DbaKbUpdate - fix supersedes and instability by @potatoqualitee
DacFX - Fix strong-name signing is not supported on this platform by @potatoqualitee
Get-DbaBackupInformation - Fix size information for striped backups by @andreasjordan
Watch-DbaDbLogin - filter more by @potatoqualitee

Invoke-DbaQuery - fixing layout of examples in documentation by @andreasjordan
Get-DbaRegServerStore - Use correct object while connecting by @andreasjordan
Set-DbaAgentSchedule - Output changed schedule by @andreasjordan
Get-DbaEstimatedCompletionTime - Only show queries that provide estimated completion time by @andreasjordan

New-DbaDiagnosticAdsNotebook - fix formatting by @spaghettidba
Copy-DbaDatabase - Don't use diff backups with Continue by @andreasjordan

Add-DbaAgReplica: add SessionTimeout param by @lowlydba

Test-DbaLastBackup / Remove-DbaDatabaseSafely - Change parameter name DestinationCredential to DestinationSqlCredential by @andreasjordan
Import-DbaCsv - Use nvarchar instead of varchar with AutoCreateTable by @andreasjordan
Get-DecryptedObject - Try one thumbprint after the other by @andreasjordan

Rename-DbaLogin - some internal variable changes by @andreasjordan
Copy-DbaDatabase - New parameter AdvancedBackupParams by @andreasjordan

Set-DbaNetworkCertificate - Add parameter RestartService by @andreasjordan
Get-DbaDbMailConfig - Remove wrong loop by @andreasjordan
Remove-DbaAgentJobStep change ConfirmImpact to High by @MikeyBronowski
Rename-DbaLogin - fix filter to rename dbusers by @potatoqualitee
Internal command - Get-SqlInstanceUpdate - Add missing Credential by @potatoqualitee
New-DbaDbMaskingConfig - add table name(s) to file by @potatoqualitee

Remove-DbaAgentJob change ConfirmImpact to High by @MikeyBronowski
added CU 16 for SQL 2019 by @MikeyBronowski
chore(ci): add informational Codecov status checks by @thomasrockhu-codecov
Export-DbaInstance - Catch Replication Errors by @potatoqualitee
Copy-DbaDbAssembly: Add DatabaseID by @lancasteradam