Monthly Archives: October 2019

Creating test data using TSQL- 4 weeks of CPU stats

To Spoof the creation of SQL creating the CPU stats for the last 4 weeks I used some useful SQL routines, the full code is linked here but the relevant sections are explained in the blog post. These are a … Continue reading

Posted in DataScotland, Tips & 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 , , , , | Leave a comment

Setting up Docker for testing – Setting up 3 SQL servers Manchester / Glasgow / Edinburgh

There are a lot of resources out there about Docker, I am just going to cover the steps I ran to get a test environment I used to present with. These steps created 3 different SQL server environments (Glasgow, Manchester, … Continue reading

Posted in Azure Data Studio, DataScotland, Docker, Management Studio | Tagged | Leave a comment