Over a million developers have joined DZone.

My Favorite SQL Server 3rd Party Tools

· Database Zone

To stay on top of the changing nature of the data connectivity world and to help enterprises navigate these changes, download this whitepaper from Progress Data Direct that explores the results of the 2016 Data Connectivity Outlook survey.

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.

Turn Data Into a Powerful Asset, Not an Obstacle with Democratize Your Data, a Progress Data Direct whitepaper that explains how to provide data access for your users anywhere, anytime and from any source.

Topics:

Published at DZone with permission of Imran Baloch, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}