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.
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.
This time DBA called me as he wanted to know if how to confirm that lock pages in memory is enabled for the SQL Server instance.
Once we isolate the user, it was easier for us to get the performance back to the original level. Learn about User Statistics Report for Database – SSMS.
In those scenarios, we end up on a very elaborated training session. Let us learn today about how to List Database Available for Current User.