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?

[@gatlaaravind3178]

All times, we can learn something new with Vamsi.. Thanks for uploading

[@KTEXPERTS]

Doing great job Vamsi by sharing the knowledge.

[@chindamparamesh6996]

Tremendous Teaching ....,, 👍👍

[@naveenpacha]

Thanks Vamsi. Great efforts 👌

[@sudheerratna7755]

Hi Vamsy, thanks for this video. Appreciate all your efforts. Could you please help us understand as to how you were able to access SQL DB from VM when there is no explicit firewall rule/vnet rule or exception. Fyi, this was discussed around 19:53 of this video.

[@chaitanyabhoomireddy9035]

Very nice video and awesome explanation.

[@vamsychiranjeevi9619]

Glad you liked it!

[@venkatreddy3836]

can you please share that PowerShell script which you used for troubleshoot the connection issues or share us the link

[@mohseenshaikh7632]

This was really helpful video. We are stuck at one point. We have azure api, we want to connect it using private endpoint of sql server. Api is not able to resolve private ip of sql server because we have api vnet inteigration set on vnet gateway. We dont want to change it form virtual gateway. What can we do

[@who5387]

Hi Vamshi Have been watching your videos it was a very good learning. could you please tell me when you gonna start new batch on AZURESQL(PASS)so that i could be part of your amazing knowledge transfer

[@vamsychiranjeevi9619]

Hi, I Completed IAAS & Azure Managed instance is about to get completed. I didn't start Azure SQL yet in case you are interested ping me on my WhatsApp [phone].

[@vaibhavwadhai8046]

Could you please share the note for this

[@jeffringeorgejose3897]

Hi, So instead of accessing the SQL from VM, can I connect from my local machine, if I use a VPN? (Provided the VPN gateway is hosted in Azure, and I have added the Virtual network rule in Sql server for the VNET where the gateway is hosted)

[@vamsychiranjeevi9619]

Yes you can if you have proper VPN.

[@vaibhavwadhai8046]

How we can provide the sql access to end user without RBAC role for Azure SQL server ?

[@vamsychiranjeevi9619]

Sorry I didn't get your question. From where are you trying to connect to Azure SQL DB? Is it from on-premises or from Azure?