|
$subName = 'my azure subscription name here' |
|
$rgName = 'nesql-june24-demo2' |
|
$region = "East US" |
|
$serverName = 'billwilder911' |
|
$myIp = "107.92.120.203" #### CHANGES A LOT! |
|
|
|
Add-AzureRmAccount # then log in interactively, including with 2FA |
|
Select-AzureRmSubscription –SubscriptionName $subName |
|
|
|
# How many regions am I allowed to deploy SQL to? |
|
$sqlRegionCount = (Get-AzureRmResourceProvider –ListAvailable | Where-Object {$_.ProviderNamespace -eq 'Microsoft.Sql'}).Locations.Length |
|
Write-Host "$sqlRegionCount regions available for creating Azure SQL Databases:" |
|
(Get-AzureRmResourceProvider –ListAvailable | Where-Object {$_.ProviderNamespace -eq 'Microsoft.Sql'}).Locations |
|
|
|
# create a RESOURCE GROUP for this demo |
|
New-AzureRmResourceGroup –Name $rgName –Location $region |
|
(Get-AzureRmResourceGroup –Name $rgName).Location |
|
|
|
# create a DATABASE SERVER |
|
New-AzureRmSqlServer –ResourceGroupName $rgName –ServerName $serverName –Location $region –ServerVersion "12.0" |
|
|
|
#create a DATABASE FIREWALL RULE |
|
New-AzureRmSqlServerFirewallRule ` |
|
–ResourceGroupName $rgName ` |
|
–ServerName $serverName –FirewallRuleName "one ip to rule them all" ` |
|
–StartIpAddress $myIp –EndIpAddress $myIp |
|
# -AllowAllAzureIPs |
|
|
|
|
|
# create a DATABASE ************************************ |
|
Get-AzureRmSqlCapability –LocationName $region |
|
|
|
$dbName = 'BillDb' |
|
$dbEdition = "Basic" |
|
$dbLevel = "S0" # https://azure.microsoft.com/en-us/documentation/articles/sql-database-service-tiers/ |
|
$dbLevel = "Basic" # https://azure.microsoft.com/en-us/documentation/articles/sql-database-service-tiers/ |
|
|
|
$db = New-AzureRmSqlDatabase –ResourceGroupName $rgname ` |
|
–ServerName $serverName ` |
|
–DatabaseName $dbname ` |
|
–Edition $dbEdition ` |
|
–RequestedServiceObjectiveName $dbLevel |
|
|
|
$db |
|
|
|
Write-Host "Firewall?" |
|
Write-Host "${dbName}.database.secure.windows.net" |
|
|
|
# comment out to NOT delete right away |
|
Write-Host "Remove-AzureRmResourceGroup -Name $rgname -Force" |
|
$subName = 'Bill Wilder – Finomial MSDN(Converted to EA)' |
|
$rgName = 'nesql-june24-demo2' |
|
$region = "East US" |
|
$serverName = 'billserver981' |
|
$myIp = "107.92.120.203" #### CHANGES A LOT! |
|
|
|
Add-AzureRmAccount # then log in interactively, including with 2FA |
|
Select-AzureRmSubscription –SubscriptionName $subName |
|
|
|
# How many regions am I allowed to deploy SQL to? |
|
$sqlRegionCount = (Get-AzureRmResourceProvider –ListAvailable | Where-Object {$_.ProviderNamespace -eq 'Microsoft.Sql'}).Locations.Length |
|
Write-Host "$sqlRegionCount regions available for creating Azure SQL Databases:" |
|
(Get-AzureRmResourceProvider –ListAvailable | Where-Object {$_.ProviderNamespace -eq 'Microsoft.Sql'}).Locations |
|
|
|
# create a RESOURCE GROUP for this demo |
|
New-AzureRmResourceGroup –Name $rgName –Location $region |
|
(Get-AzureRmResourceGroup –Name $rgName).Location |
|
|
|
# create a DATABASE SERVER |
|
New-AzureRmSqlServer –ResourceGroupName $rgName –ServerName $serverName –Location $region –ServerVersion "12.0" |
|
|
|
#create a DATABASE FIREWALL RULE |
|
New-AzureRmSqlServerFirewallRule ` |
|
–ResourceGroupName $rgName ` |
|
–ServerName $serverName –FirewallRuleName "one ip to rule them all" ` |
|
–StartIpAddress $myIp –EndIpAddress $myIp |
|
# -AllowAllAzureIPs |
|
|
|
|
|
# create a DATABASE ************************************ |
|
Get-AzureRmSqlCapability –LocationName $region |
|
|
|
$dbName = 'BillDb' |
|
$dbEdition = "Basic" |
|
$dbLevel = "S0" # https://azure.microsoft.com/en-us/documentation/articles/sql-database-service-tiers/ |
|
$dbLevel = "Basic" # https://azure.microsoft.com/en-us/documentation/articles/sql-database-service-tiers/ |
|
|
|
$db = New-AzureRmSqlDatabase –ResourceGroupName $rgname ` |
|
–ServerName $serverName ` |
|
–DatabaseName $dbname ` |
|
–Edition $dbEdition ` |
|
–RequestedServiceObjectiveName $dbLevel |
|
|
|
$db |
|
|
|
Write-Host "${dbName}.database.secure.windows.net" |
|
|
|
|
|
Write-Host "Run this later to delete this resource group containing database server and database" |
|
Write-Host "Remove-AzureRmResourceGroup -Name $rgname -Force" |
|
#Remove-AzureRmResourceGroup -Name $rgname -Force |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|