Scrub the existing cmdlets and make sure the all offer the -Encrypt, -AccessToken, -TrustServerCertificate, ... parameters

[Matteo-T]

In v22.0.57, I may have missed a few (e.g. Enable-SqlAlwaysOn and Disable-SqlAlwaysOn).

It would be nice to complete the list in some v22 update.

[potatoqualitee]

We handle this through a config system. Seems like that'd be a more maintainable solution for you all.

[Matteo-T]

What's the definition of "config system"?

[potatoqualitee]

In our module, we use Get-DbatoolsConfig and Set-DbatoolsConfig and Register-DbatoolsConfig which saves to a JSON file or the registry. @FriedrichWeinmann created it for us and it's now included in his PSFramework module and is all in C#

We allow users to save the config in their current session (Set) or for all sessions (Register)

Set-DbatoolsConfig -Name Import.EncryptionMessageCheck -Value $false -PassThru | Register-DbatoolsConfig

Oh, looks like we have way more commands than that, like import and export 😅

https://dbatools.io/configuration/

HTH

[potatoqualitee]

omg where can i report this bot

Edit: reported as malware

[potatoqualitee]

This is how we handle it @Matteo-T

https://blog.netnerds.net/2023/03/new-defaults-for-sql-server-connections-encryption-trust-certificate/

# Set defaults just for this session
Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true
Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false

# Set these defaults for all future sessions on this machine
Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register
Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false -Register

[Matteo-T]

Yeah - I was thinking about having something like that while talking to the go-sqcmd folks. Maybe I'll revisit and add it.

[potatoqualitee]

bravo GH and Microsoft, that bot is gone 🙌🏼

[potatoqualitee]

feel free to take our design, @Matteo-T. We also include the things found in the SSMS connection panel.

[Matteo-T]

bravo GH and Microsoft, that bot is gone 🙌🏼

Actually, I just deleted those bot-things myself. :-)