

I really love the coloring of the tabs to let me know if I’m connected to production, staging, test or development. Cathrine Wilhemsen has an nice article how to use these features if you’re interested. The speed I have writing queries has at least doubled. I recently started using SQL Prompt from Red-Gate which I should’ve done a long time ago. Depending on what type of database instance is selected, some or all of. With the multi scripts feature, you can select databases on the current server and execute a script against them from one. No more information than needed and you’ll be able to a lot more tabs on your screen than before. Click Search to repeat the current search in the selected time period. Go to the section “Tab Text” and set the following options to “False” to disable the information shown in the tab:Ĭlick the OK button and open a new tab. Go to the options screen to adjust the settings for the tabs:

Who cares about the database server, the database name and the login who is connected if all the information is already in the task bar below in your screen. Your tab will probably look something like this before the change: Making the tab names smaller makes it possible to have more tabs open at the same time without the hassle of scrolling to the right one. In the left hand pane if you select the Execute SQL tab, you will be presented with a three paned window and a small toolbar. Like many of your I normally have loads of tabs open in SSMS to get all my work done.īased on this article I want to show how to reduce the size of your tab by disabling most of the information which is already present somewhere else.īy default SSMS shows all kinds of information which you probably don’t need in your tab because the information is present somewhere else.
