Tag Archives: TSQL

Azure Data Studio – Database Status Dashboard (5/31)

One of the things I was finding I was missing was when restoring databases and adding into availability groups. It was quite easy to see in SSMS when databases, were synchronized or syncronizing or had just plain, fell over when … Continue reading

Posted in Azure Data Studio, Dashboards, SQLSaturday, Tips & Tricks, TSQL | Tagged , , , | Leave a comment

Monitoring CPU

As part of a licensing project, it was found to be very useful to get an overview of current servers CPU across the SQL estate. There was an expensive 3rd party software solution that was reporting high CPU usage on … Continue reading

Posted in Management Studio, Performance Tuning | Tagged , , , , | Leave a comment

Using Output

The OUTPUT command can be a very useful tool to use at times. The following scripts show a couple of ways it can be used. The code from these scripts can be found here on my shared dropbox. First off … Continue reading

Posted in Tips & Tricks, TSQL | Tagged , | Leave a comment