The strangest SQL Server Agent problem you will ever meet!

I came across this issue recently and I found it to be logged nowhere. It was a nightmare to troubleshoot and thus I would like its resolution to stay publicly available – because frankly there is 0% chance anyone will be able to solve it on his own. I was lucky to be helped by a…

2

How to do a quick SQL Server healthcheck

There is sometimes the need to do a quick SQL Server healthcheck. Usually this is needed before a maintenance or a migration takes place or after a problem has been resolved. The time given to you for this typical healthcheck is usually short, so let’s see how you can do this in a quick and efficient…

1

How to use Extended Events to proactively monitor your SQL Server for Deadlock issues

Usually after a deadlock occurs, we don’t have the needed information to troubleshoot the deadlock issue. This is because in order to troubleshoot a deadlock issue we need verbose information, so we need to have certain trace flags enabled (e.g. 1204, 1222). This is usually a problem because after setting up these trace flags, you…

2