Re: Dead Zune Club

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

T-SQL came with Sybase, from whom Microsoft had colloborated on SQL Server
4.x. Pre-dates VB and/or Microsoft ... just saying.

- Adwait
--
Adwait Ullal

w: http://www.adwait.com
p: (408) 898-2581


On Tue, Oct 11, 2011 at 5:14 PM, Mike <[email protected]> wrote:

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