Pinned tabs in SQL Server Management Studio (SSMS)

Introduction

While working in SQL Server Management Studio (SSMS), we may need to open many query windows. But each time we may feel difficult to recognize the important query window which we need to refer frequently. There is an option, we can Pin the tabs which are mostly frequently referred.

Pinning Tabs

We can pin the query windows. At the top of the each query window, there is an icon to pin the tab, and once the tab in pinned it will always present in the left side of the SSMS, as shown below.

There is another option to highlight the pinned tab as well. Just above we saw that the pinned tabs will be in the same row, in other option, we can keep the pinned tabs in separate row. To keep it in separate row, go to the Tools -> Options, select the Tabs and Windows option. Then tick the “Show pinned tabs in a separate row” checkbox, as shown in the below window.

Once the above settings is done, if we pin the query window, those tabs will be separated to another row as shown below,

Conclusion

In this article, I have shared how we can pin our frequently required query window. Hope this tip was very useful. Please share your feedback in the comment section.