Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

My Favorite SQL Server 3rd Party Tools

DZone's Guide to

My Favorite SQL Server 3rd Party Tools

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

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.

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

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 DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

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

X

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

{{ parent.tldr }}

{{ parent.urlSource.name }}