create_sql_database.ps1

create database [$dbName];
USE [master]
GO
CREATE LOGIN [$userName] WITH PASSWORD=N'$password', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
USE [$dbName]
GO
CREATE USER [$userName] FOR LOGIN [$userName]
GO
ALTER ROLE [db_datareader] ADD MEMBER [$userName]
GO
ALTER ROLE [db_datawriter] ADD MEMBER [$userName]
GO
ALTER ROLE [db_ddladmin] ADD MEMBER [$userName]
GO
GRANT EXECUTE TO [$userName]
GO