Redgate: SQL Search

I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially when your environment has thousands of objects. Upon some research I found a Redgate tool that is free called SQL Search and it is an installation I do not regret at all.

Let’s dive in.

Installation is a breeze where you can download the installer from: http://www.red-gate.com/products/sql-development/sql-search/

redgate

redgateinstall

Make sure all current SSMS connections are closed – don’t worry too much as the installer will check for you.

sqlsearch

Let’s check out the functionality of the tool which you will now see within SSMS’s menu bar.

ssms

For the first example I leave all default options on – such as searching across all databases against all objects

sqlsearch1

I have highlighted (above) where you type and it uses a dynamic behaviour, by that I mean you get results as you type. So I decide to search for a name of a stored procedure where I totally forgot about where it resides called AttackBytes.

As soon as I type the first 2 letters (A,T)…. it will preload with options.

playhomeDB

There it is within my playhome database where the bottom window will show you the T-SQL.

CodeFound

If you click the “select object in object explorer” link it will navigate to the object within SSMS.

ssmscode

This is totally usefully if you are searching against hundreds of objects and it has saved me time.

Wild-card searching is also supported – for example searching for table names pe% across the server where table definitions will also be provided.

wildcard

objectsfound

1 object I couldn’t search across was sequences, ok I know sequences are not a big deal in SQL Server like in Oracle but I thought I would mention it. It is a product that I have been using for a month now without any issues.

What else would I like to see? Maybe an extra option to skip checking across comment blocks – but I feel that might be a tough one to add.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s