Category: Sqlserver Administration

Sometimes your developers are overeager and are killing multiple database processes at once on your Sqlserver instance. Several hours later they approach you with the question of what to do. To decide if you should wait it out or restart the service is a decision that can be based on the following query in a…

Sometimes you are encountered with mysteries on your database server. You have a beautiful alerting system that sends you emails about the Azure node when there are critical events so yo are well informed when some anomaly is going on on your Azure VM-machine.  I received recently an email with a critical event. It was…