DevOps Pro Tip - Creating Accounts on Azure SQL Database through PowerShell

create-dbo.ps1

$server = "tcp:my-azure-sql.database.windows.net,1433"
$database = "MyDatabase"
$adminName = "admin@my-azure-sql"
$adminPassword = "P4SSW0rd"

$connectionString = "Server=$server;Database=$database;User ID=$adminName;Password=$adminPassword;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
$connection = New-Object -TypeName System.Data.SqlClient.SqlConnection($connectionString)

$queryPath = "C:\Temp\SqlDbo.sql"
$query = [System.IO.File]::ReadAllText($queryPath)

$command = New-Object -TypeName System.Data.SqlClient.SqlCommand($query, $connection)

$username = New-Object -TypeName System.Data.SqlClient.SqlParameter("@Username", "MyDboName")

$command.Parameters.Add($username)

$connection.Open()
$command.ExecuteNonQuery()
$connection.Close()