Have you ever been working in SSMS where you need to frequently access one particular script, but you are spending most of your time in other scripts? Starting with SSMS 2016, you can pin a tab to your SSMS Query window pane to make it easier to go back to that script.

On the right side of each tab, is a pin icon. Clicking this will pin that tab to SSMS.

How this works depends on the options selected. Under the default configuration, SSMS will move this tab to the far left, and it will stay there. However, you can have all pinned tabs be in a separate row.

When the pinned tabs are in a separate row, this is how SSMS will look:

This post is for day four of my month-long blog series “A Month of SSMS Tips”. I have a landing page for the series at bit.ly/MonthOfSSMS. Please visit this page for an easy place to quickly view all of the other tips in this series.