Lots of people who watched the video also asked me to build a similar video. Let us see today a video where I explain how to detect 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.
SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist
One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal.
SQL SERVER – Converting Unix TimeStamp to DateTime
There is a very easy method to convert Unix TimeStamp to DateTime. Let us learn that in today’s blog post.