Redgate recently released SQL Prompt 7.1. I try to be an efficient developer (read: I’m a lazy and often impatient developer), so I’m a huge fan of any feature that can save me some clicks here and some time there. In this version, SQL Prompt comes with new Results Grid Features. And let me tell you… I rarely hear so many business users and business analysts ask me: How did you do that!?
Well, let me show you :)
(Like this video? Check out the other 14 Super SQL Tips!)
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.
Redgate recently released SQL Prompt 6.5. There are some nice features in this version, but my favorite is by far Tab Coloring! It is no longer an experimental feature, it has become a proper feature. I did a quick demo of Redgate SQL Prompt including Tab Coloring in my SQLBits session to show how you can save time and work more efficiently.
Yay! I’m very happy to be accepted into the Friend of Redgate program in 2015 :)
As a Friend of Redgate I get to use and review their tools and provide feedback directly to the development and product teams. I might also get the opportunity to speak about and/or publish articles about their tools and how we use them to solve our problems at work.
I’ve been using the Redgate tools for years, and I love how they interact with and give back to the community. Not only do they host free SQL in the City events, they also support a lot of user groups and SQLSaturdays and publish books you can download for free. They listen to your suggestions and always have a smile on their face :) I’m very excited to see how I can help this year.
My hope and goal is to provide some good feedback on how we use their tools in a data warehouse environment, and get some help in return to learn how we can be even more efficient. There are many areas in my department we can improve, and I hope we can use the Redgate tools to streamline our deployment process and automate testing – things we struggle with in a complex environment where so many things depend on each other. I also hope I can help others by sharing our experiences by speaking or publishing blog posts or articles. This will be an exciting year!