My Favorite SQL Server 3rd Party Tools
Join the DZone community and get the full member experience.Join For Free
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.
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/
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/
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 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/
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, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
Logging Best Practices Revisited [Video]
Real-Time Made Easy: An Introduction to SignalR
Extending Java APIs: Add Missing Features Without the Hassle
Microservices Decoded: Unraveling the Benefits, Challenges, and Best Practices for APIs