SQL Database Connectivity Explained | Data Exposed

This session explains the basics of how connectivity works for SQL Database and how you can use network access controls to securely access SQL Database.

Note: At 7:33 during the video, it is said that “Allow Access to Azure services” restricts traffic to resources within the subscription - which is incorrect. Setting Allow access to Azure services button on the Portal (Firewall settings page) to ON shall allow traffic to/from resources ( e.g. Azure VM) or PaaS services( e.g. Web App) hosted inside Azure - within same subscription or from another subscription.

[victorsaraiva]

Very well explained...I liked the diagrams, the explanations and the questions asked by the host

[GeminiLearning]

This is a very informative video guys. Thanks a lot.
Please to you have a more comprehensive videos on SQL server and Azure SQL?

[TarasVytrykush]

Can one tell what's the best way to access the Azure SQL server with disabled public access for an Azure AD group members? I wonder if there's a way for doing that without creating VM to be as mediator point.

[raufasadov]

The official docs says in order to use redirect mode, allow outbound communication from the client to Azure SQL DB gateway IP addresses on port 1433 and to all Azure SQL IP addresses in the region on ports in the range of 11000-11999. How can I determine IP addresses in the region? I didn't get the second part which is about 11000-11999. Could someone help me understand this?

[tyrrelldavis]

Is there a channel for mixer API tutorials?

[changeDgame]

Wonderful presentation and explanation! If you could provide functionality of proxy server connection instead of white listing public of on-premise or out of azure hosted vms (which is really painful when you have customer connecting from different geographical locations and their public gateways are different) that would make us turn to AzureSQL for our production servers.