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 – Creating System Admin (SA) Login With Empty Password – Bad Practice
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.
SQL SERVER – sys.dm_os_sys_info and Lock Pages in Memory
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.
SQL SERVER – User Statistics Report for Database – SSMS
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.
SQL SERVER – Restore Database With Just Log File
Restoring the database with Just Log File is not possible. If you are looking for the answer to this question, you have bad news. It is not possible.
SQL SERVER – List Database Available for Current User – HAS_DBACCESS
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.