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: 0.0.0.0 – 255.255.255.255

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:

WordPress.com Logo

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

Google photo

You are commenting using your Google 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