Wayne Sheffield

My blog about SQL Server

As you already know, SQL Server runs as a service. And services require a service account to run under. While this service account is likely to be a domain service account, it could be an account on the local machine. To follow good security practices you would need to specify that this account: Has the […]

One of the most basic actions dealing with a SQL Server instance is connecting to that instance. In this post, we’ll cover the many possible ways of connecting to a SQL Server instance.

In this post, you can learn how to control what information is SSMS displays in the status bar and on the query tabs. De-clutter or prevent duplicate information – it’s easy to control what you get.

SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance. This is available by right-clicking on the server and selecting Activity Monitor, or by selecting the toolbar icon for it. Either of these options will bring up the Activity Monitor in a new tab. In […]

SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of either the server node, or the database nodes. Simply right-click the node, and select reports. The server level reports are: And the database level reports are: Each of these reports provide useful, timely information. Once […]

If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are all for the purpose of ensuring that everyone (especially those in the back of the room) can clearly see your demo in SSMS. The fonts used in SSMS and a few other settings need adjusted. […]

Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have SSMS configured exactly to your liking, you need to save all of these configuration settings. You know, in case you have to start over with a fresh install. Thankfully, saving SSMS settings is very easy. […]

When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you change the code, you will look at the execution plan again. However, comparing all the changes is troublesome. Fortunately, comparing query plans has become easy in SSMS (starting in 2016). Just save off the first […]

We all know that we should liberally document our code with comments, so that others (and even yourself) will know what the code is doing down the road. I like to start all of my code off with my classic remark block:

Note that this is a SQL Prompt snippet, not a snippet from […]

One of the things that I do with my code is to include reference links to what I was doing where applicable. SSMS provides us with a way to navigate directly to these web links, instead of having to copy the link and paste it into your browser. All that is needed for this is […]

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.