Re: Dead Zune Club

Like most MS products, it is too clickly.  here is always one or two too
many clicks necessary to do just about anything, which sounds trivial but
gets annoying fast.  For example with toad if you want to see data from a
table, you just click on the tablename.  Probably the biggest continual
annoyance is having to exactly select the portion of SQL that you wish to
run.  Toad had several more highly convenient options, and you only had to
have the cursor located somewhere in the block.  I have to use the mouse
more often with smss.  Then other small things, but that get annoying, like
not remembering which windows you want to have open on start up.

As far as TSQL, it is very Microsofty/VBish.  Noisy, cutesy, and lacks basic
functionality like TRANSLATE.  Not that PL/SQL is anything to brag about.

One thing I do like, is the sproc debugging.

Some of my complaints are not fair.  I recently spent several months using
almost nothing except notepad++, and now I'm expecting all editors to have
things like sophisticated column mode editing, etc.

Mike

On Tue, Oct 11, 2011 at 12:25 PM, Chris Wuestefeld <chris-/ffxFymC14jQ7bhM+Ce/[email protected]
> wrote:

> **
>
>
> > 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.****
>
> ** **
>
>  
>