Download from Microsoft Install using HomeBrew
Category: Azure
PowerShell – Download Azure Blob Container Content
You get all of your data into Azure or your application uploads/creates directly into Azure storage and then someone asks you to download the files…. This script below will help you download your files.
Azure MSSQL – Server Firewall Rules
Run these commands on the master table. First get the existing rules Based on the above query if there are any rules you need to remove get the name and replace Client with the appropriate name If you need to add an IP rule go to https://www.kittell.net/ip.php and update the…
MSSQL – Datetime In Local Timezone
This function will get the local time based on the time zone difference from UTC
Azure PowerShell – Create Virtual Network Within Resource Group
This is still a work in progress to include all the variables but the script below will create a Resource Group then create a Virtual Network with 3 subnets and a gateway along with custom DNS.
Azure Red Hat – RHUI Update
Most of the this script is based on the document “Red Hat Update Infrastructure (RHUI) for on-demand Red Hat Enterprise Linux VMs in Azure” at https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-linux-update-infrastructure-redhat?toc=%2fazure%2fvirtual-machines%2flinux%2ftoc.json My change will first check if the update was already installed, if not it will follow the process to install See updates at: https://gitlab.com/Kittell-RedHat/AzureRepo/raw/master/AzureRedHatRepoUpdate.sh
PowerShell Azure – Get First Available IP From IP Range
If you build virtual machines in Azure you may find this script useful. Currently it’s not the fastest it could likely be if you have a large subnet but it works for my needs. It mixes two resources to make what I needed. Resources: 1. List IP addresses in a…
Microsoft Azure SQL – Create SQL User
In this example I create a Read-Only user but this will work with any access as long as you change the db_datareader access role to what you need In SQL Management Studio open a “New Query” with [master] database Again in SQL Management Studio open a “New Query” with the…