A client asked how to see which databases a user can reach. The HAS_DBACCESS function makes it easy to list databases where the user has DB access.
Get Current Time Zone – SQL in Sixty Seconds #187
Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check.
Detecting Memory Pressure – SQL in Sixty Seconds #186
After my video on CPU running 100%, many of you asked for one on memory. Here is my SQL in Sixty Seconds video on detecting memory pressure.
MySQL – Wait For Seconds Using SELECT SLEEP()
Recently my client asked me if there is the equivalent command of WAIT FOR of SQL Server in MySQL. Of course, there is and a very simple one.
SQL SERVER – List All Available TimeZone
Let me ask you a quick question – how many timezone SQL Server supports? The answer is for SQL Server 2019 it is 141. Yes, it is true.
SQL SERVER – Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE
A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to Azure SQL Database.
SQL SERVER – Last Used Stored Procedure
“Is there any way to know the last used stored procedure in SQL Server?” Well, I was asked this during Health Check.