One day, your Availability Group cluster can get into a critical state in a way that forces your team to create the Availability Group from scratch. The foll...

This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a problem. It only points to the existe...

Usually, when I need to troubleshoot currently running requests, I use a combination of sys.dm_exec_requests and sys.dm_os_waiting_tasks. The former retrieve...

What are Orphaned Users “Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated with its relevant Server Login. This o...

If after creating a DB Mail Profile and an account you send a test email and it doesn’t work, you can try these steps to troubleshoot it: Look for error mess...

On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was “SQL Server DBA Tips that Can Save Yo...

Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to change the data type of one of the columns from TINYINT to INT...

Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way or another, to parameterization. On one hand,...

Imagine the following scenario: After a very nice weekend, you get up in the morning with a smile on your face, get to work and drink your nice morning coffe...