Redgate SQL Prompt 6.5 Tab History

Redgate SQL Prompt Logo.

Hello, my name is Cathrine, and I am a tab hoarder 🤓 I always have lots of tabs open in SQL Server Management Studio (SSMS) connected to different environments. I have written about how Redgate SQL Prompt Tab Coloring makes it easy to find the right tab(s) based on the tab color, but that is not the only tab feature that saves me a lot of time.

Redgate SQL Prompt Tab History. is amazing! It allows you to view and reopen closed tabs, even those unnamed and unsaved tabs with ad-hoc queries that you thought you would never need again. It also allows you to quickly navigate and search through closed and open tabs.

Custom Real Time Monitoring Solution (T-SQL Tuesday #66)

T-SQL Tuesday logo.

T-SQL Tuesday #66 is hosted by me (yay, fun!) and is all about monitoring. We all monitor something while working with SQL Server, and there are so many topics to choose from. As a Data Warehouse developer I use Adam Machanic’s sp_WhoIsActive all the time, I look at the Integration Services Dashboard in SSMS to monitor SSIS package executions and I check the Job Activity Monitor for a quick overview of what’s currently running on our servers.

However, I decided to write about a custom Real Time Monitoring solution we use in my company (Storebrand) that my coworkers in Lithuania created. I couldn’t resist this opportunity to show one of our cool solutions that I get to use and to brag about how talented my coworkers are 👏🏻