Category Archives: Management Studio

Azure Data Studio Snippets #17

Posted on March 17, 2020 by martincroft

I know snippets have been around for years and I have utilised lots of SSMS tools like ssmstoolspack back in the day persuading a company I worked for to buy a copy for the developers.  Of late my SSMS tool … Continue reading →

Posted in Azure Data Studio, Azure Data Studio Extensions, Management Studio, Productivity, Snippets, Uncategorized | Leave a comment

Monitoring CPU

Posted on October 21, 2019 by martincroft

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

Posted on October 19, 2019 by martincroft

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

SQL Solutions – Part 2 bookmarks

Posted on July 18, 2016 by martincroft

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 →

Posted in Configuration, Management Studio, Productivity, Tips & Tricks | Leave a comment

Horizontal Whitespace & Vertical Select

Posted on July 13, 2016 by martincroft

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

Posted on July 12, 2016 by martincroft

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

Posted on July 11, 2016 by martincroft

#DBA #SQLDeveloper customisable toolset that was shown in a presentation as part of #SQLPASS Manchester / Leeds in June Continue reading →

Posted in Management Studio, Productivity, Tips & Tricks, Uncategorized | Leave a comment

Management Studio Solutions

Posted on May 23, 2014 by martincroft

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