ApexSQL Search

Database management usually comes with its fair share of challenges, especially if you are not the most tech-savvy of users.

ApexSQL Search is a reliable software solution that helps you simplify some database-related tasks, namely those of searching for SQL objects and text strings while still working within SQL Server.

If you have several versions of SQL Server installed on your computer, you get the possibility to choose where ApexSQL Search should be integrated with.

In other words, you can benefit from the functions of ApexSQL Search when using a certain SQL Server version, whereas a different edition will not feature them.

The application creates a separate menu within the host software, thus making it easy for you to choose the type of search you want to perform, either object or text-based.

When it comes to launching an object search, you get to choose the database, as well as specify the type of objects you are interested in (such as assemblies, certificates, credentials, columns, indexes, event notifications, parameters, roles, rules, schemas, services, triggers and so on).

To perform a text search, you only need to enter the keyword, select the server and the database names, and simply initiate the search. If you want to filter the results, you can deselect some of the available objects, and then export the results to XML, CSV or HTML.

ApexSQL Search comes in handy if you want to review and alter the extended properties of your database, as well as safely rename tables, views, procedures, functions, columns or parameters.

The utility can come in handy when you want to explore the dependencies not only within the database, but also across other databases, scripts or apps.

ApexSQL Search is a nifty application that integrates within SQL Server and helps you speed up a lot of database-related tasks.