How to check Azure SQL firewall rues with TSQL
In the master database of the Azure SQL server. select * from sys.firewall_rules
How to restore a Azure SQL DB to a new server
From the target server, select “Create database.” 2. Fill in the configuration values. Then go “Next Networking” or just go to tab “Additional Settings”. 3. Set “Use existing data” to “Backup” and select a backup from your existing database backups.
How to use T-SQL to scale Azure SQL Server
You can use T-SQL to scale up/down Azure SQL Server: To check the DB scaling progress, you can use T-SQL in Master DB: With the T-SQL Alter database command, you can use SQL agent to easily schedule your database scale up/down.