v2.1.14

Update dbatools library to update RestSharp which had the previous CVE.

Full Changelog: V2.1.13...v2.1.14

V2.1.13

This is the official Andreas Jordan release 😅

What's Changed

• Get-DbaProcess - Add information about endpoint and DAC by @andreasjordan in #9304
• Connect-DbaInstance - Connect DAC to test connection as soon as possible by @andreasjordan in #9305
• Install-DbaInstance - Fix issue with MachineLearning by @andreasjordan in #9312
• Update buildref by @potatoqualitee in #9323
• Copy-DbaCredential - Force DAC as it is needed for decryption by @andreasjordan in #9306
• Get-DbaStartupParameter - Remove fixed typing of variables that may change their type by @andreasjordan in #9309
• Set-DbaTcpPort - Support multiple ports by @andreasjordan in #9310
• Install-DbaDarlingData - Include new procedures by @andreasjordan in #9311
• Update-SqlPermission (used by Copy-DbaLogin) - Fix for using LoginRenameHashtable together with user different to login by @andreasjordan in #9313
• Backup-DbaDatabase - Use Stop-Function to support EnableException for unverified databases by @andreasjordan in #9317
• New-DbaComputerCertificate - Only use MonthsValid for self-signed certificates by @andreasjordan in #9318
• Update dbatools-buildref-index.json SQL2019 CU26 by @MikeyBronowski in #9324
• Add-DbaDbRoleMember - Add support for adding roles to roles by @andreasjordan in #9319
• New-DbaDbTable - Fix some issues by @andreasjordan in #9314
• Connect-DbaInstance - Open connection to get CurrentDatabase by @andreasjordan in #9308

Full Changelog: v2.1.12...V2.1.13

v2.1.12

What's Changed

• Get-DbaBackupInformation is not reading values for "IsCopyOnly" attribute. by @david-garcia-garcia in #9294
• Update-ServiceStatus - fix cross-domain issue by changing ComputerName to PSComputerName by @fuixx217 in #9288
• Get-DbaLogin - clean up old code causing issues by @jpomfret in #9291
• change splatting to remove
  from docs by @jpomfret in #9292
• Find-DbaInstance, help more markdown-compatible by @niphlod in #9299
• Add-AgDatabase, shorter Example by @niphlod in #9298

New Contributors

• @fuixx217 made their first contribution in #9288

Full Changelog: v2.1.11...v2.1.12

v2.1.11

What's Changed

• changed casing on contributing.md by @KennyNeal in #9269
• Export-DbaServerRole: Fix case in sql to fix issues on case sensitive instances by @andreasjordan in #9271
• Install-DbaInstance - Enable installation in root folder by @andreasjordan in #9272
• Update Format-DbaBackupInformation.ps1 by @0x7FFFFFFFFFFFFFFF in #9277
• Select-DbaBackupInformation - fixed example by @0x7FFFFFFFFFFFFFFF in #9276
• Remove-DbaReplSubscription - Typo fix in Synopsis by @DiHo78 in #9279
• buildref: included CU12 for 2022 by @niphlod in #9278
• Get-DbaReplPublication - fix example by @DiHo78 in #9274

Full Changelog: v2.1.10...v2.1.11

v2.1.10

THIS RELEASE ADDRESSES TWO CVE'S

This update addresses two CVE's, one in Microsoft.Data.SqlClient and one in Azure.Identity. Thanks to @garyhampson for the update on dbatools.library dataplat/dbatools.library#7

See this announcement from Microsoft for more details.

Essentially:

If you are using Microsoft.Data.SqlClient, anywhere (.NET Core, .NET 6/7/8, .NET Framework) and you are using a version that is vulnerable you must update your NuGet package reference to an updated version: 2.1.7, 3.1.5, 4.0.5, or 5.1.3

An updated version of Microsoft.Data.SqlClient, version 5.1.4, was also released that upgrades the Azure.Identity dependency version to 1.10.3 , which addresses CVE-2023-36414 in that library. (release notes) (download)

What's Changed

• Added documentation for PR #6777 (Query Store Set and Get functions shouldn't try to get data from model) by @ReeceGoding in #9266
• Skip Failing Replication Tests by @potatoqualitee in #9268
• update dbatools library by @potatoqualitee in #9267
• Install-DbaMaintenanceSolution does not work inside a container by @david-garcia-garcia in #9252

New Contributors

• @david-garcia-garcia made their first contribution in #9252

Full Changelog: v2.1.9...v2.1.10

v2.1.9

What's Changed

• Project readme update - update command count reference by @0x7FFFFFFFFFFFFFFF in #9228
• Fix minor typo in CONTRIBUTING.md by @ben-thul in #9260
• fix: Set-DbaAgentSchedule should check for not null on enddate by @lowlydba in #9257
• Copy-DbaCredential: Fix for credentials with square brackets in it's name - Issue #9242 by @ibaxo in #9243
• New-DbaComputerCertificate, options for Algorithm and Period validity by @daniel-merchant in #9264
• Multiple Functions - Remove Stop-Function ErrorRecord parameter use outside of try-catch blocks by @0x7FFFFFFFFFFFFFFF in #9227
• Restore-DbaDatabase - improve warning output for standby mode databases by @0x7FFFFFFFFFFFFFFF in #9230

New Contributors

• @ibaxo made their first contribution in #9243

Full Changelog: v2.1.8...v2.1.9

v2.1.8

What's Changed

• Update dbatools-buildref-index.json SQL 2019 cu25 by @MikeyBronowski in #9244
• Update Get-DbaWaitStatistic.ps1 to be in sync with the Paul Randal script it copies from (fixes 9251) by @ReeceGoding in #9249
• Invoke-DbaQuery, fixed example for TVP by @niphlod in #9247

New Contributors

• @ReeceGoding made their first contribution in #9249

Full Changelog: v2.1.7...v2.1.8

v2.1.7

What's Changed

• Get-DbaAgentSchedule: Fix description output for hourly jobs by @andreasjordan in #9194
• Copy-DbaDbTableData: Add missing database parameter when connecting to target by @andreasjordan in #9193
• Added several security patches related to CVE-2024-0056 + SQL 2022 CU11 by @MikeyBronowski in #9207
• Update Set-DbaDbQueryStoreOption.ps1 by @tominyorks in #9205
• Grant-DbaAgPermission - Update Type description by @0x7FFFFFFFFFFFFFFF in #9201
• Invoke-DbaQuery, support reuse of parameters by @niphlod in #9221
• Update-DbaInstance: Fix typo in warning message by @pluim003 in #9213
• Get-DbaCmObject - Improved CIM ErrorHandling by @FriedrichWeinmann in #9107
• Copy-DbaDatabase - doc update by @0x7FFFFFFFFFFFFFFF in #9200
• Update Get-DbaFile.ps1 by @0x7FFFFFFFFFFFFFFF in #9202

New Contributors

• @tominyorks made their first contribution in #9205
• @pluim003 made their first contribution in #9213

Full Changelog: v2.1.6...v2.1.7

v2.1.6

What's Changed

• Update dbatools-buildref-index.json SQL 2022 CU10 by @MikeyBronowski in #9167
• Get-DbaPermission - fix returning Null in field 'Securable' by @uncletimmy3 in #9171
• SQL Server 2019 CU 24 by @rwestMSFT in #9185

Full Changelog: v2.1.5...v2.1.6

v2.1.5

What's Changed

• Update Get-DbaDbBackupHistory.ps1 by @0x7FFFFFFFFFFFFFFF in #9138
• Update dbatools-buildref-index.json - Added 11.0.7512 by @andreasjordan in #9142
• Add-DbaAgDatabase - Use ExecuteAs with restore to set correct database owner by @andreasjordan in #9144
• Connect-DbaInstance - Change EncryptConnection to a switch with a default of $true by @andreasjordan in #9143
• New-DbaEndpoint - New parameter AuthenticationOrder by @andreasjordan in #9145
• Set-DbaDbCompatbility - Fix for using piped input and don't trust master compatibility level by @andreasjordan in #9146
• Update Set-DbaAgentJobStep Retry null check by @tyndur in #9148
• New-DbaEndPoint - Fix Auth Order Param issue by @potatoqualitee in #9155
• Backup-DbaDatabase - allow users to specify no compression by @ben-thul in #9151
• Encryption Check - Add support for string settings by @potatoqualitee in #9154
• Install-DbaInstance - Fix for installing MachineLearning in SQL Server 2022 by @potatoqualitee in #9153
• Config - do not attempt HKCU on macOS or Linux by @potatoqualitee in #9157
• Fix non-Windows Import Errors by @potatoqualitee in #9158

New Contributors

• @0x7FFFFFFFFFFFFFFF made their first contribution in #9138
• @tyndur made their first contribution in #9148

Full Changelog: v2.1.4...v2.1.5