Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS.
Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.
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 – 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.