Re: Dead Zune Club

It is a good idea, and I might, but very often I am working at highly locked
down client sites, so I try to stay set up such that I do not bring in any
tools or leave any footprint.  I do carry some tools with me, e.g.  the
portable versions of notepad++ and winmerge.  Toad is just too heavy and
invasive.

Mike

On Tue, Oct 11, 2011 at 8:19 PM, Shawn Wildermuth <
[email protected]> wrote:

> **
>
>
> Why not use Toad against SQL Server?****
>
> ** **
>
> - stw****
>
> ** **
>
> Note: This was typed on a big ole laptop so any misspellings and
> punctuations are completely my fault…not my phone’s.****
>
> ** **
>
> *From:* [email protected] [mailto:
> [email protected]] *On Behalf Of *Mike
> *Sent:* Tuesday, October 11, 2011 8:15 PM
> *To:* [email protected]
> *Subject:* Re: [OT] 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.****
>
>  ****
>
> ** **
>
> ****
>
>  
>