Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.
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.