Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

Top 4 Best SQL Editors

14 February,2016 by Tom Collins

Based on a recent poll I took the best\most used  SQL Editor goes to :

SQL Server Management Studio – Query Explorer


This is not a surprise as it ships with SQL Server and is the default client . Quite often developers will remain with the tools they first started on.   It’s good to maintain an open-mind, there may be more productive methods available.

One factor which will influence sql editor tool choice  is the range of platforms. For example, if a developer or DBA is writing sql code to support multiplatforms such as SQL Server and DB2 , they may look to sql editor tool with standardised support for both platforms.

Lets look at some details

  1. SQL Server Management Studio

Home Page:

Author: Microsoft

Latest Stable Version: SSMS 2016

Written in: C , C++, .Net, t-sql to communicate to DB

Operating System: Windows


2.    MS SQL Code Factory

Home Page:

Author:Maestro Group

Latest Stable Version: 15.7

Operating System: Windows


3.DatabaseSpy SQL Editor


Author: Altova

Latest Stable Version:  2016

Operating System: Windows


4. SQuirrel SQL Client

Home Page :

Author: Colin Bell, Gerd Wagner, Rob Manning and others

Latest Stable Version:  3.7

Written in:  Java

Operating System: Cross Platform


Read More on sql tools

SQL server 2008 R2 – Silent installation for the SSMS and client tools

SQL Server - Open SSMS on the Command Line - SQL Server DBA

SQL Server – Open SSMS without the splash screen graphic - SQL ...



Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on Top 4 Best SQL Editors | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer