Wayne Sheffield

My blog about SQL Server

Browsing Posts tagged SSMS Tips

After you’ve messed up all of the configuration settings in SSMS affecting windows, how to you fix things? Read on for how to reset the window layout!

It used to be hard to remove an old server from the SSMS connection dialog. Now, it’s easy-peasy. This blog post shows you how to perform this frequently needed action.

A batch separator is used by client tools to break up a script into batches that are sent to SQL. Learn how to work with them (and even change them) to be more productive.

Whether you are a “use tabs” or “use spaces” type of person, this article will show you how to configure SSMS to work with tabs and spaces. It then goes in to show how to see what you really have in a file, and how to easily convert them from one type to another.

Get more out of SSMS. There’s a lot of stuff built in to help you be more productive, but many don’t know about it. Find out what SSMS has to offer in this month long series of SSMS tips and tricks.

Remove the clutter from SSMS by switching to full screen mode. SSMS goes to maximum size, minimal toolbars and buttons to get in your way.

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. […]