Skip to content

Category: Tools and Productivity

Do you like wasting time on repetitive tasks? Yeah, I didn’t think so. Me neither. I always try to find tools and techniques that can help me work smarter and more efficiently. Fewer clicks, more smiles! :)

In this category, I write about applications that can help increase your productivity. I also share tips for saving time in applications you might already be using. Some of my favorite free tools for text editing are Notepad++ and Visual Studio Code. I’m also a huge fan of the Redgate products, especially SQL Prompt. This is a licensed tool, but the one tool I would pay out of pocket for to use at work!

Redgate SQL Prompt 7.1 Results Grid Features

Redgate SQL PromptRedgate 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!)

Continue reading →

Free Personal Source Control with Visual Studio and Git

Free Personal Source Control with Visual Studio and GitDo you work on projects in Visual Studio? Are you looking for a free and simple way to source control your projects without sharing them with the whole world? Would you like to be able to manage your projects online and still be able to work on your projects offline? If so, you may want to look into using Visual Studio and Git.

As a speaker and blogger, I create projects for demos, videos and screenshots. When I only had a few projects it worked quite well to “source control” my projects: I kept them in a OneDrive folder, created copies of demo code for new presentations and maintained versions manually.

However, the projects grew in number and size and became more difficult to maintain. There were no easy ways to track how I changed and improved my code over time, and I couldn’t revert to previous code. I kept telling everyone else to use source control, so I decided it was finally time to source control my personal projects.

In this post I will show you how I added my first project to source control with Visual Studio and Git.

Continue reading →

Redgate SQL Prompt 6.5 Tab History

Redgate SQL PromptHello, 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.

Continue reading →