What Have I blogged
May 2022 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 -
Recent Posts
Archives
Cloud
Azure Data Studio Azure Data Studio Extensions Beers Bit of fun Configuration Dashboards Dataplatform DataScotland Docker extensions Management Studio Markup Notebooks Performance Tuning PowerShell Productivity Snippets SQL Notebooks SQLSaturday SQL Security Tips & Tricks TSQL Uncategorized virtualization Visualisation Waffle YorkshireCategories
- Azure Data Studio
- Azure Data Studio Extensions
- Beers
- Bit of fun
- Configuration
- Dashboards
- Dataplatform
- DataScotland
- Docker
- extensions
- Management Studio
- Markup
- Notebooks
- Performance Tuning
- PowerShell
- Productivity
- Snippets
- SQL Notebooks
- SQL Security
- SQLSaturday
- Tips & Tricks
- TSQL
- Uncategorized
- virtualization
- Visualisation
- Waffle
- Yorkshire
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 AzureDataStudio, Dashboards, tricks, TSQL
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 CPU, Productivity, Scripts, SQL, TSQL
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