If the client has multiple databases, this script also helps us to find out which database and particularly which database file is the most used.
MySQL – Recover Dropped Performance Schema Database
Earlier today I saw the question in an online forum where the user was looking for ways to recover Dropped Performance Schema Database in MySQL.
SQL SERVER – Script to Estimate Compression
I had implemented Data Compression at my client Performance Health Check. Let us discuss how we can estimate compression.
SQL SERVER – List Databases Where User Has DB Access
This is a very interesting function and it helps us to list databases where User Has DB Access. Well, it is pretty straightforward to know with the help of function HAS_DBACCES.
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 Authority 15 Years of Blogging and Upcoming Changes
Today I complete my 15th year of blogging at SQLAuthority.com. I am truly honoured that many are reading my blog after 15 years.
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.