THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Using SSMS in Customer Presentations

When using SSMS with a projector or very large screen HDTV, there are several customizations to make things easier to read for the people in the back of the room. First let’s look at a screen capture of SSMS without any customizations.


Figure 1. SSMS with default settings.

Do you really need the Properties pane during a presentation? Probably not. You can close that out to obtain more SSMS real estate.


Figure 2. Properties pane closed. Go to Tools and select Options.

To increase the size of most fonts in SSMS including the Object Explorer, within Options, open Environment, select Fonts and Colors, then under Show settings for, select Environment Font. Pick a font type and size. The changes will not fully take effect until you close and reopen SSMS.


Figure 3. Under Options, open Environment and select Fonts and Colors. Change the font settings for Environment Font.

To make the grid results visible to the people in the back of the room, you can change the font settings for Grid Results.


Figure 4. Change the font for the Grid Results.

Notice how much larger the fonts are except for the query text.


Figure 5. The grid results are larger, but the query text is still small.

To increase the size of query text, you can use Fonts and Colors to change settings for the Text Editor. I prefer a different approach. You can change the size of query text by using the dropdown menu at the bottom of the query pane.


Figure 6. Use the dropdown at the bottom of the query pane to increase the query font size.

Another option for making SSMS more readable is to use the free Microsoft tool ZoomIt.

Published Monday, June 27, 2016 2:39 PM by John Paul Cook



RichB said:

Or... you could undock the query pane for full screen goodness... just grab the tab and lift it out.

June 27, 2016 9:39 PM
Anonymous comments are disabled

About John Paul Cook

John Paul Cook is a database and Azure specialist in Houston. He previously worked as a Data Platform Solution Architect in Microsoft's Houston office. Prior to joining Microsoft, he was a SQL Server MVP. He is experienced in SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse currently studying to be a psychiatric nurse practitioner. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Connect on LinkedIn

This Blog



Privacy Statement