I am super excited to share with all of you that today, I released my 40th Pluralsight course. The topic of the course is Impact with Slowloris.
SQL SERVER – Network Port Used
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
My client was working from home and could not reach his SQL Azure database. Here is how to add IP address to firewall rules from the Azure portal.
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.