Skip to content

Instantly share code, notes, and snippets.

View weeyin83's full-sized avatar

Sarah Lean weeyin83

View GitHub Profile
@weeyin83
weeyin83 / speakinglog-deployazuresqldb.sh
Last active June 20, 2022 10:15
Deploy an Azure Resource Group and then a Azure SQL Database, opening accessing to the firewall for you
# Set an admin login and password for your database
export adminlogin=ServerAdmin
export password=adminpassword
# The logical server name has to be unique in the system
export servername=SpeakingStats
# The ip address range that you want to allow to access your DB
export startip=0.0.0.0
export endip=0.0.0.0
# Set the Resource Group Name
export rgname=rg-speakinglogs
@weeyin83
weeyin83 / azcli-storage.sh
Last active May 22, 2020 09:26
Create a standard storage account
#Create the resource group
az group create \
--name rg-photostorage \
--location UKSouth
#Create the storage account
az storage account create \
--name sarahsphotos \
--resource-group rg-photostorage \
--location UKSouth \
azcopy sync "C:\Users\salean\Pictures\2019" "https://sarahsphotos.blob.core.windows.net/2019-photos?sv=2019-10-10&ss=bfqt&srt=sco&sp=rwdlacupx&se=2020-05-05T17:44:25Z&st=2020-05-22T09:44:25Z&spr=https&sig=m9mbnOaFs0eCNhcuTa9dOsWcXqKySg0xC5PwqVfFvvQ%3D"
choco install microsoft-windows-terminal