$SubscriptionID = "REPLACEWITHYOURS"
$ResourceGroupName = "runwild-feature-rg"
$Location = "eastus"
$ServerName = "runwildtestep"
$VaultName = "YOURVAULTNAME"
$SQLUserName = "BDF"
$SecretName = "FeatureSQLAdminPass"

Login-AzureRmAccount

#Create a secret in vault
Set-AzureKeyVaultSecret -VaultName $VaultName -Name $SecretName -SecretValue (Get-Credential).Password

#Retrieve secret from vault
$password = Get-AzureKeyVaultSecret -Name $SecretName -VaultName $VaultName

#Create PSCredential object
$SQLCredential = New-Object System.Management.Automation.PSCredential -ArgumentList ($SQLUserName, $password.SecretValue)

New-AzureRmSqlServer -ServerName $ServerName -Location $Location -ResourceGroupName $ResourceGroupName -SqlAdministratorCredentials $SQLCredential