During the recent Comprehensive Database Performance Health Check, I got a question from a client if there is an easy way to figure out the Network port.
Question: How to Get Volume Mount Point for SQL Server Files?
Answer: I was asked this question by my client during the recent Health Check.
The question was is there any way to list all the IP addresses which have access to the Azure Firewall and remove them via T-SQL in SSMS.
Question: How to Find the IP Address of All SQL Server Connection?
I had recently received this question during a recent consultation.