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.
How to Get Volume Mount Point for SQL Server Files? – Interview Question of the Week #295
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.
SQL SERVER – Fix: The operating system returned error 21(The device is not ready.)
The client was in very much panic as they were getting the following error – The operating system returned error 21(The device is not ready.)
SQL Server – T-SQL – Add and Remove IP Address to Azure Firewall
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.
SQL Azure – Add IP Address to Firewall
However, recently my client was working from home and he was not able to access the SQL Azure database. Let us learn how we can and IP Address to Access.
SQL SERVER – Network Protocol and IP Address
The question was if there is a way to know how many sessions are connected to current SQL Server instance with their network protocol as well as IP address.
How to Find IP Address of All SQL Server Connection? – Interview Question of the Week #280
Question: How to Find the IP Address of All SQL Server Connection?
I had recently received this question during a recent consultation.