Are you tired of spending hours searching for SQL objects and data in your SQL Server Management Studio (SSMS) or Visual Studio (VS) projects? Look no further! ApexSQL Search is a free add-in that will revolutionize your SQL Server experience.

One of the most powerful features of ApexSQL Search is its ability to show visual relationships between objects. In SSMS, this is called “view dependencies,” but ApexSQL Search takes it to the next level. With just a few clicks, you can easily see how different SQL objects are related to each other.

But that’s not all! ApexSQL Search also offers a range of other useful features. For example, you can manage extended properties and perform smart renaming without breaking dependencies. This means you can rename your SQL objects with confidence, knowing that all related objects will be updated accordingly.

Searching for specific SQL objects or data is a breeze with ApexSQL Search. The Database object search feature allows you to find all SQL objects containing a specified phrase. And if you’re looking for data in tables and views, the Database text search feature has got you covered.

Sorting and filtering your search results is easy with ApexSQL Search. Simply click on the appropriate column name to customize the sorting, or right-click to filter the results using the Filter row. You can even use wildcards and regular expressions in your search queries, just like you would in SQL Server.

Managing extended properties has never been easier. ApexSQL Search provides an intuitive interface for customizing extended properties stored in your database. Simply call the Edit extended properties feature from the ApexSQL Search menu, and you’re good to go.

One of the standout features of ApexSQL Search is its automatic SQL query editor renaming. This means that SQL query windows are automatically named based on their contents, making it easier for you to keep track of your queries.

And let’s not forget about the View Dependencies feature. With ApexSQL Search, you can visualize all objects’ relationships and customize the arrangement of the dependency diagram. Whether you prefer a circular, force-directed, hierarchical, or orthogonal layout, ApexSQL Search has got you covered.

Ready to take your SQL Server experience to the next level? Download ApexSQL Search today and start exploring the full potential of SQL Server. With ApexSQL Search, you can experiment with all the concepts discussed in this blog post and discover even more powerful features along the way.

Happy searching!