A Better (Free) Search in SSMS

A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we released. Free as in beer, so go get it.

Why use SQL Search?

There are a number of good reasons, which Ike Ellis of Crafting Bytes does a good job of highlighting in a short video. In short, SQL Search is much more robust in helping you track down objects.

I’m sure plenty of you are like me. You think you know where most of the objects live in a database. I’ll use the SQLServerCentral database as an example. If I want to look in the forums for how to modify profiles, I know there’s an InstantASP_Users table. I can quickly go to the Object Explorer, hit Databases, go to SQLServerCentral_Forums, hit tables, and pick the table. I can get the designer, a list of columns, etc. This is a familiar way of working with databases.

2016-06-13 11_49_33-Start

However, I’d be lying if I said I knew all of the objects that referenced that table. Especially stored procedures. Even if I work with a database every day, and I have a great memory, I don’t always keep every reference in mind.

I still follow that process (too often), but I’ve learned there’s a better way of working with a database.

SQL Search.

If I type “asp_user” in the search dialog, I get this:

2016-06-13 12_01_32-Photos

Now I can see lots of objects, including those in other databases. If I know I want tables, I can easily filter.

2016-06-13 12_01_47-Photos

However I don’t just get the names, I can get some details:

2016-06-13 12_01_55-Movies & TV

The more I move to search, the more I start to realize that the Object Explorer is quite slow, and inefficient. I’d be better served by just going to search right away. At least, a search that gives me plenty of useful information,

So download SQL Search today and see how it can make development easier in large databases, and check out Ike’s video.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.