What Have I blogged
December 2019 M T W T F S S « Oct 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
Categories
Category Archives: Management Studio
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
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
SQL Solutions – Part 2 bookmarks
Bookmarks combined with SQL solutions can start to give some serious power to a script library. In the previous blog post I covered creating a script library, he’s a copy of one that i created / use daily. SO i … Continue reading
Horizontal Whitespace & Vertical Select
Another demo from the June SQL Pass / SSUG presentation. Some of the lesser known features of management studio is the ability to vertically select data (see below) and also delete white space the following is an example of using these. … Continue reading
Posted in Management Studio, Productivity, Tips & Tricks
Leave a comment
SQL Solutions – Reusable script Library
SQL Server easy to build T-SQL Script library using tools that everyone already has. Continue reading
Posted in Configuration, Management Studio, Productivity, Tips & Tricks
1 Comment
DBA / Developer Tool Set
#DBA #SQLDeveloper customisable toolset that was shown in a presentation as part of #SQLPASS Manchester / Leeds in June Continue reading
Management Studio Solutions
I have found several times creating the same set of scripts for the same thing, trying to locate where I saved it, when did I last run it. I end up spending ages looking for some code I ran previously … Continue reading
Posted in Management Studio, Productivity
Leave a comment