Creates a new database master key. If no database is specified, the master key will be created in master.
You will be prompted to securely enter your password, then a master key will be created in the master database on server1 if it does not exist.
New-DbaDatabaseMasterKey -SqlInstance Server1
Suppresses all prompts to install but prompts to securely enter your password and creates a master key in the ‘db1’ database.
New-DbaDatabaseMasterKey -SqlInstance Server1 -Database db1 -Confirm:$false