Different Ways of Connecting to Azure SQL DB from Azure Virtual Machines and Internet

This video explores different ways to connect to Azure SQL and explains different troubleshooting scenarios.

We also discussed about Azure SQL Architecture like Gateways, Data Slices & Traffic Manager. Also, we examined the differences between Proxy and Redirect Connectivity.

We considered the Private DNS Zone, Private virtual network link and DNS records too.

I highly recommend for beginners & for the people who are appearing for interviews.

By Watching this Video you will be able to answer the below interview questions

1)     Can you Explain about Azure SQL Architecture?
2)     What are the public facing Gateways in Azure SQL?
3)     What is the role of traffic Manager in Azure SQL?
4)     What are the different connection Policies in Azure SQL?
5)     What is the difference between Proxy and Redirect connection Policy?
6)     What are the ports that’s needs to be enabled for the redirect connection policy to work as expected?
7)     What are the 3 different public network polices that allows you to connect to Azure SQL from Azure Virtual Machines?
8)     What firewall would get added when you enable Allow Azure Services and resources to access this server?
9)     What will happen when we enable the Service Endpoint for Azure SQL?
10)  What needs to be done if you want to Access Azure SQL with the private IP of the Azure virtual machine?
11)  What is the importance of Private Endpoint for Azure SQL?
12)  Will there be any difference with the results of nslookup command before and after enabling Azure Private End point?
13)  What will happen if I delete the DNS record of the private End Point?
14)  What will happen if we delete virtual network link of the private end point?
15)  What’s the difference between service endpoint and private endpoint?
16)  Do you know anything about Azure SQL DB connectivity error 40914?
17)  What will you do as a DBA if you are not able to connect to Azure SQL DB?