v2.1.31

What's Changed

• New-DbaConnectionStringBuilder, param reorganization by @niphlod in #9613
• Update dbatools-buildref-index.json SQL 2017 Azure Connect Pack by @MikeyBronowski in #9620
• Update dbatools-buildref-index.json SQL 2022 CU18 by @MikeyBronowski in #9625
• Set-DbaAgentOperator, better docs by @niphlod in #9617
• New/Remove-DbaAgentOperator, better docs by @niphlod in #9621
• New-DbaDbMaskingConfig, handle numeric by @niphlod in #9622
• Get-DbaDbUser, faster enumeration when targeting single db by @niphlod in #9623
• Start-DbccCheck, better extraction of errors by @niphlod in #9624
• New-DbaDbMaskingConfig, account for lots of tables by @niphlod in #9642
• buildref, "touch" LastUpdated even if no new CU have been shipped by @niphlod in #9661
• Install-DbaDarlingData: Added new stored procedures, documented abbreviations, and gave every procedure an abbreviation by @ReeceGoding in #9652
• Set-DbaAgentJobOutputFile: also report the current output file name by @ReeceGoding in #9646

Full Changelog: v2.1.30...v2.1.31

v2.1.30

What's Changed

• Update dbatools-buildref-index.json SQL 2019 CU32 by @MikeyBronowski in #9611
• Set-DbaDbQueryStoreOption, use correct postfix for STALE_CAPTURE_POLI… by @niphlod in #9605
• Get-DbaBackupHistory, better docs for Since parameter by @niphlod in #9604
• Set-DbaResourceGovernor - Pass Credentials to Get-DbaDbUdf by @darrenmaginnis in #9609

New Contributors

• @darrenmaginnis made their first contribution in #9609

Full Changelog: v2.1.29...v2.1.30

v2.1.29

What's Changed

• Update dbatools-buildref-index.json SQL2019 CU30 by @MikeyBronowski in #9560
• Update-DbaInstance, fix documentation by @niphlod in #9559
• Get-DbaExternalProcess - Test failing by @jpomfret in #9571
• Install-DbaMaintenanceSolution - don't drop tables if not readding by @jpomfret in #9570
• Update dbatools-buildref-index.json by @rwestMSFT in #9577
• BuildRef, add 2019CU31 by @niphlod in #9587
• Test-DbaWindowsLogin, add property for mismatch on samaccountname by @niphlod in #9589
• Set-DbaLogin, report correct name for -WhatIf by @niphlod in #9582
• Find-DbaAgentJob, work with multiple wildcards by @niphlod in #9583
• New-DbaSqlParameter, check bound parameters correctly by @niphlod in #9584
• Backup-DbaDbMasterKey, add FileBaseName by @niphlod in #9599
• Backup-DbaServiceMasterKey, add FileBaseName parameter by @niphlod in #9598
• Backup-DbaDbCertificate, new FileBaseName parameter by @niphlod in #9597
• Invoke-DbaDbShrink, accept pipelined databases by @niphlod in #9596
• Get-DbaNetworkCertificate, propagate credentials by @niphlod in #9595
• Enable/Disable-DbaTraceFlag, support -WhatIf by @niphlod in #9588
• Connect-DbaInstance, honor -Database parameter by @niphlod in #9585
• Invoke-DbaQuery, re-wire connection with integrated as another user by @niphlod in #9592

Full Changelog: v2.1.28...v2.1.29

v2.1.28

What's Changed

• Security updates for SQL 2022, 2019, 2017, 2016 by @MikeyBronowski in #9547
• SQL Server 2022 CU 16 by @rwestMSFT in #9551
• Include new version of SQL Server Maintenance Solution by Ola Hallengren by @andreasjordan in #9550
• Fix for installation of SQL Server Maintenance Solution by Ola Hallengren: Changed name of branch from master to main by @andreasjordan in #9549

Full Changelog: v2.1.27...v2.1.28

v2.1.27

What's Changed

• Fix test for Backup-DbaDatabase by @andreasjordan in #9507
• Fix test for Measure-DbaBackupThroughput by @andreasjordan in #9508
• Fix test for New-DbaCredential by @andreasjordan in #9509
• Fix test for Remove-DbaDbTableData by @andreasjordan in #9511
• Get-DbaDbMailServer: Fix e-mail account names if more than one account exists by @potatoqualitee in #9506
• Fix test for Remove-DbaDbSynonym by @andreasjordan in #9510
• New-DbaAgentJob: Fix wrong output when using -Force to remove existing job by @andreasjordan in #9512
• Fix test for Enable-DbaHideInstance by @andreasjordan in #9517
• Fix test for Copy-DbaLinkedServer by @andreasjordan in #9516
• Fixed test for Copy-DbaEndpoint by @andreasjordan in #9515
• Fix test for Set-DbaNetworkConfiguration by @andreasjordan in #9514
• Fix test for Start-DbaXESession by @andreasjordan in #9513
• Tests/pester5runner by @niphlod in #9521
• Enabling more tests on AppVeyor by @andreasjordan in #9523
• Fix test for Get-DbaEstimatedCompletionTime by @andreasjordan in #9522
• Tests - use new Test-Config instead of constants.ps1 by @potatoqualitee in #9524
• first pester5 test (do Invoke-DbaQuery) by @niphlod in #9525
• DevContainer update to support aider by @potatoqualitee in #9527
• pester runner, detection based on standard Requires directive by @niphlod in #9528
• Pester migration - First Batch by @potatoqualitee in #9529
• Pester migration - Second batch by @potatoqualitee in #9530
• Pester migration - Third batch by @potatoqualitee in #9531
• Pester v5 runner fixes by @potatoqualitee in #9533
• Update dbatools-buildref-index.json SQL2019 CU29 by @MikeyBronowski in #9538
• Import-DbaCsv, work with numeric, too by @niphlod in #9534

Full Changelog: v2.1.26...v2.1.27

v2.1.26

What's Changed

• Security updates for SQL 2022, 2019, 2017, 2016 by @MikeyBronowski in #9493
• Copy-DbaResourceGovernor: Fix copy of classifier function by @andreasjordan in #9492
• Fix typos in DbaDbDbcc commands by @MikeyBronowski in #9494
• Fix test for Get-DbaDump by @andreasjordan in #9499
• Refactor AgHadr tests by @andreasjordan in #9498
• Fix tests for Availability Groups by @andreasjordan in #9500
• Enable test for Invoke-DbaDbMirroring by @andreasjordan in #9503
• Refactor tests to use variable server instead of instance for SMO server objects (part 1) by @andreasjordan in #9501
• Mount-DbaDatabase: Deduplicate filepaths if more that one backup is in the last backup file by @andreasjordan in #9504
• Connect-DbaInstance: Fix for issue when changing database context by @andreasjordan in #9505

Full Changelog: v2.1.25...v2.1.26

v2.1.25

What's Changed

• Update dbatools-buildref-index.json SQL2022 CU15 by @MikeyBronowski in #9476
• Update tests to be able to run them outside of AppVeyor (part 3) by @andreasjordan in #9426
• Test-DBALsnChain - Fix missing log backup (#7515) by @AdamJKoehler in #9467
• Get-DbaHelpIndex - Bad joins based on Index Name instead of Index ID when Indexes in same DB named the same #9447 by @jianjunpei in #9473
• Test-DbaDbCompression, returns ? for empty tables (do Compression) by @niphlod in #9474
• Get-DbaDbView, add Schema parameter (do DbView) by @niphlod in #9475
• Import-DbaCsv, map correct types for BulkCopy by @niphlod in #9479

New Contributors

• @AdamJKoehler made their first contribution in #9467
• @jianjunpei made their first contribution in #9473

Full Changelog: v2.1.24...v2.1.25

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