RE: Dead Zune Club

Yeah, that's been my experience with Toad too, would love to find something
more portable.

 

- 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:30 PM
To: [email protected]
Subject: Re: [OT] 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.