There is great free tool "Atlantis SQL Everywhere" I am using which has many advantages over SSMS. Color coding identifiers (not just table names) like in Resharper, expanding on columns for SELECT * from table, configurable shortcuts for scripts repository (like "IJ" for typing INNER JOIN), formatting, renaming variables and aliases across script, copy grid data as IN clause, generate C# classes. It has better navigation for finding objects by just typing partial name instead of defining filters in SSMS. I like highlighting NULLs inside result grid in yellow to distinguish.
Basically SSMS + Redgate = Atlantis (almost)
Matt - 8 years ago
There's a great opportunity for new tools for writing SQL
There is great free tool "Atlantis SQL Everywhere" I am using which has many advantages over SSMS. Color coding identifiers (not just table names) like in Resharper, expanding on columns for SELECT * from table, configurable shortcuts for scripts repository (like "IJ" for typing INNER JOIN), formatting, renaming variables and aliases across script, copy grid data as IN clause, generate C# classes. It has better navigation for finding objects by just typing partial name instead of defining filters in SSMS. I like highlighting NULLs inside result grid in yellow to distinguish.
Basically SSMS + Redgate = Atlantis (almost)
There's a great opportunity for new tools for writing SQL