One liner for adding your current IP to a Azure SQL Server firewall. Used in ADO.

add_current_ip_to_fw.sh

MYIP=$(curl -s http://ipinfo.io/json | jq -r '.ip') && \
MATCH="^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$" && \
if [[ $MYIP =~ $MATCH ]]; then \
  echo "Adding $MYIP to $(SERVER_NAME) firewall"; \
  az sql server firewall-rule create -g $(RESOURCE_GROUP) -s $(SERVER_NAME) -n ALLOW_ADO --start-ip-address $MYIP --end-ip-address $MYIP; \
else \
  echo "$MYIP is not a valid IP address."; \
  exit 1; \
fi