Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
As there was no owner, it was not possible to open that database in the SSMS. We had to find Owner of the Database and change it later on.
I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course.
A very popular question I often receive during my Performance Health Check is about how to use stored procedures in SELECT Statement.
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.