RE: Dead Zune Club

> SSMS is terrible compared to Toad/Oracle, I wonder if there is something
else that is solid that I should switch to?

While I haven't seen Toad in a decade (when it was a freeware third party
app), I'm really surprised to hear you say that it's superior to SSMS. I'm
curious what innovations they've made. Can you fill us in?

There are a few add-ins for SSMS that I find indispensable:

SQL Prompt (Redgate). This does Intellisense for queries. But not just
filling in the names of columns. It can also help to automatically fill in
the ON conditions for JOINs, for example.

SSMS Tools (freeware, http://www.ssmstoolspack.com/). A bunch of features,
but the important ones to me are:

.         Automatically saves every query you issue, ever, and allows you to
search through history to find old ones.

.         Provides a colored bar next to your query window, with a color
specified for each server you connect to. I use this to show green ("safe")
for DEV servers, and red ("danger") for Production servers.

.         Automatically generate INSERT statements for the data actually in
a table.

SQL Search (freeware, Redgate). Helps you locate specific entities or stored
procs. Very helpful in a large database.