In Azure, you're not limited to public networks.
They have Azure Virtual Network to create a private network between your VMs, then using Azure VPN Gateway you can connect via P2S VPN into this private network, getting a local VN IP address, and connect to your Azure SQL Server instance with SSMS.
After configuring private VNs, you can use Azure VN NAT to ...
this may be too late, but there seems to be a better answer for this question.
I was searching for the same thing; how do I view the connection string to a particular SQL Server database. I read you cannot do it within SQL Server Management Studio, but you can retrieve the connection string Visual Studio uses, as suggested by another user.
In Visual Studio, ...
Normally DBAs create an automated function or have tools to rebuild the indexes.
This one is a functional version to rebuild all indexes to all tables in your schema:
DECLARE @tableSchema varchar(max),
DECLARE cur CURSOR FOR SELECT TABLE_SCHEMA, TABLE_NAME FROM Information_Schema.tables where ...
If you want to check database size of particular database using SSMS Gui
Go to Server Explorer -> Expand it -> Right click on Database -> Choose Properties -> In popup window choose General tab ->See Size
Source: Check database size in Sql server ( Various Ways explained)