Skip to content

Cleaner Code Demos – Speaker Hints

November 17, 2010

Recently I had the privilege of watching Paul Randal and Kimberly Tripp present (separately) at SQL Server Connections. If you have never seen them talk I would highly recommend you make time if you are ever at an event with them. They do a fantastic job.

In any case, they used SSMS quite regularly to show how various things worked in SQL Server. The thing that struck my quite quickly was the easy in which I could see what they were doing, and they could also track where they were in a large complex script.

Typically when I see someone using Management Studio to present it looks like this:

SSMS_present_1

Granted, this is small, but when it’s projected on a screen, it’s not likely to be much better. The important stuff, the query, and the results, are actually a little hard to see.

When I watched Kimberly do this, I saw this for the query:

SSMS_present_2

With this appearing after execution

SSMS_present_3

A couple things to notice here. First, under the main tab, in this case for SQLQuery1.sql, there are two sub tabs. One is the editor, so you can see lots of code (at font size 12). The other is the results, and when I execute a query, SSMS automatically switches to the results tab.

However not only do I have results, but I also have the query at the top. That easily lets me determine what I’ve just run. When you’re doing a few things, either on stage or at work, having the query shown is very, very handy.

How To Set This Up

First, auto hide the Object Explorer and save yourself some space. You can get the menu below by clicking the little triangle in the Object Explorer header bar.

SSMS_present_4

First let’s set up results. I would change the results to text by right clicking in the query window:

SSMS_present_7

Next, you want to go to the Query menu, and select the Query Options item. In this dialog, there are a few things to configure. First is the results item. Choose text and check the these three items:

  • Include the query in the result set
  • Display Results in a Separate Tab
  • Switch to results tab after the query executes

SSMS_present_8  

Then you want to up the font so things are easier to read. I do this first in the Text Editor (see the drop down at the top)

SSMS_present_6

Then do this for the text results, changing the drop down again.

SSMS_present_5

Now when you run a query, you’ll automatically switch over to a screen that is easier to read on a projector. And you’ll see the query you just ran, so it’s easier to keep track of where you are in your presentation.

I actually like these settings so much, I use them for any work I do in SSMS.

About these ads

From → Blog

Comments are closed.

Follow

Get every new post delivered to your Inbox.

Join 4,805 other followers

%d bloggers like this: