SQL Database Connectivity Explained | Data Exposed

From the creator

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. Read more at the following links: Connectivity Architecture: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture?WT.mc_id=dataexposed-c9-niner. Impact of removing Allow Access to Azure Services: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview#impact-of-removing-allow-azure-services-to-access-server?WT.mc_id=dataexposed-c9-niner. IP Based Firewall: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure?WT.mc_id=dataexposed-c9-niner, Vnet Firewall Rules: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview?WT.mc_id=dataexposed-c9-niner. Follow Rohit Nayak and Colin Murphy on Twitter at https://twitter.com/sqlrohit and https://twitter.com/colinatwork. More Data Exposed: https://www.youtube.com/playlist?list=PLlrxD0HtieHieV7Jls72yFPSKyGqycbZR

Published 2019-08-15 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.