.NET Zone is brought to you in partnership with:

Imran is a DZone MVB and is not an employee of DZone and has posted 31 posts at DZone. View Full User Profile

My Favorite SQL Server 3rd Party Tools

01.09.2014
| 4619 views |
  • submit to reddit

Introduction:

There are some great 3rd party tools that makes the development of SQL Server faster, easier, smarter and enjoyable. In this small blog post I would like to point some good 3rd party SQL Server tools which help me a lot during application development.

Description:

SQL Complete:

dbForge's SQL Complete is one of my favorite tool. It is an add-on of SQL Server. It has a free and paid version. It simplify and accelerate your work by predicting keywords and object names. It has a great intellisense. Also, it support SQL formatter, statement expansion, SQL snippets, code navigation and much more. You can find more about SQL complete at http://www.devart.com/dbforge/sql/sqlcomplete/ 

SQL Search:

Red Gate's SQL Search is another very helpful tool. SQL Search quickly find fragments of SQL text within stored procedures, functions, views and more. It's completly free. It also allows you to quickly navigate to different objects. It makes the search easier and increase your development efficiency. You can find more at http://www.red-gate.com/products/sql-development/sql-search/ 

SQL Sentry Plan Explorer:

If you are performance guy then you must have SQL Sentry Plan Explorer. It makes the query plan analysis very efficient. It is very lightweight and standalone. It's color coding highlights the potential trouble areas. It allows deeper analysis. It also have free and paid version.  You can find more at http://sqlsentry.net/plan-explorer/sql-server-query-view.asp

SQL Toolbelt:

SQL Toolbelt include sixteen essential and excellent tools for SQL Server. It include a powerful set of tools. For example, SQL Compare which compare and sync the database schema. You can find more at http://www.red-gate.com/products/sql-development/sql-toolbelt/

Summary:

In this article, I showed you some very essential and most important SQL SERVER 3rd party tools that I use in my daily application develoment. Hopefully you enjoyed my this article too.

Published at DZone with permission of Imran Baloch, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)