Azure SQL/ DWH

For external access for Azure SQL, we have to update Azure Server Firewall settings in azure portal – i.e. Add client IP.  For all granted access add IP range as: –

Azure SQL DB

Azure Pricing based on the DTU count.

Instance being controlled and managed by Microsoft.

Higher the DTU count lower will be the latency.

Azure Data Ware House

To store large amount of structured data.

Costlier compared to Azure Sql db.

Instance with the user can Stop/Start.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s