Ssms-Tips-Tricks

Years ago, I used to always recommend that people install Books Online (BOL) on their systems. It’s ironic that it was called “Online”, given we’re really talking about “Offline”, but back when we first were talking about it, we were comparing it to a physical book, not to a live reference on a computer screen.

Nowadays though, I find that the version online is so far superior to the one that you can install locally, that I think it’s better to just use the online version. I particularly like the way that the online books are now cross-version ie: each page covers all supported versions, instead of having a separate page for each version.

2025-07-04

When I’m doing a lot of query editing, I often get a bit mesmerized, particularly if there’s a lot of manual copy and paste or cut and paste going on.

One thing that often drives me crazy is when I use Ctrl-C (ie: copy) when I meant to use Ctrl-V (ie: paste). Invariably, I do this when I have nothing highlighted at all. So not only did I not get the value pasted, I just copied an empty value into the clipboard.

2025-07-02

Visual Studio is a very configurable tool, and particularly in the area of keyboard shortcuts. Because SQL Server Management Studio (SSMS) is based on Visual Studio, it inherits many of these configuration options. SSMS has a very rich set of keyboard shortcuts. Without trying to cover most of them, I do want to highlight a few that I think are really important to know how to use.

Let’s start with an easy set of commands.

2025-06-30

If you ever have long scripts in SQL Server Management Studio and need to refer to a particular line, it can be helpful to have line numbers shown. This is even more useful if you ever need to write a set of instructions for someone on how to modify a query, or if you are trying to describe how a query works.

Instead of having a query like this:

2025-06-28

One feature that many developers have been asking the SSMS team for, is the ability to use a dark mode.

Instead of a screen that looks like this:

They wanted a screen that looks like this:

This capability is now present in SSMS. In Tools then Options then Environment then General, you can now choose a Color Theme:

Note that there are several themes now available, including a new extra contrast option.

2025-06-26

When working with SQL Server Management Studio, sometimes you need to show someone else what you’re working on, and the fonts that you’re using are just too small for someone looking over your shoulder or looking at a screen that you’ve shared with them.

What I often see someone do then, is to go into Tools and Options and start to change the font and color settings. The pain with this is that you then need to set them back later.

2025-06-24

Code quality has always been an important topic ever since coding began. Code complexity is an important part of this. One of the topics that came up many years ago was a discussion on what length procedures or functions should be, before they became too difficult to follow.

I remember one guy commenting that he thought as soon as all the code didn’t fit on your screen any more, you were much more likely to have bugs in it. At the time, screens weren’t all that big.

2025-06-22

SSMS is a great tool and it has lots of helpful menu items and toolbar items. Unfortunately, all these items take up screen real estate.

Even though you can get more screen real estate for editing, by unpinning the windows on each side, you can see that the default screen layout could be considered a bit cluttered if you really just want to focus on the particular query that you’re working on.

2025-06-20

Years ago, I had the privilege of presenting “what’s new in SQL Server” sessions at many locations around the world. When presenting sessions, you can sometimes learn as much as you teach. What I learned while delivering those sessions is that the product group sees what’s important in a release very differently to what the attendees do.

Each time there’s a new version of SQL Server, there will normally be three or four marketing pillars (groups of functionality), and each will have about eight to ten bullet points.

2025-06-18

In another section, I’ve described ways to configure the scroll bar in SQL Server Management Studio (SSMS). There is another key option that I haven’t discussed previously: map mode. By default, the scroll bar shows the changes, syntax errors, etc: