Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Calling All Editing Buffs Expand / Collapse
Author
Message
Posted Monday, August 29, 2005 7:52 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 7, 2014 8:23 AM
Points: 318, Visits: 351
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sMcCown/callingalleditingbuffs.asp

Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com
Post #215135
Posted Friday, September 2, 2005 6:47 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 16, 2014 7:20 PM
Points: 63, Visits: 470

I use Epsilon programmer's editor (little E for PC, evolved from Emacs) which I learned at Carnegie Mellon almost 20 years ago.  Notepad/Wordpad and application development environments with built-in editors have made it hard to explain to DBAs and to developers what a real programmer's editor is.  Epsilon is more useful and flexible than specialized "data cleansing" tools as well.  In my view, a person who doesn't have a tool that performs a regular expression search is not a **real** programmer.

Query Analyzer does its job; Epsilon does its job; they work well together.  Code repository is a separate job, not to be confounded with editing.




_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
Post #216495
Posted Friday, September 2, 2005 7:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:37 AM
Points: 2,897, Visits: 5,983

Feature: Auto Script generating

 

Along the same lines as centralized code such, but a scripting tool to help you pass the same code to multiple servers quickly, for example, you have a script, sproc etc, that you run against every server in your organization.  It'd be nice to be able to select each sever from a list and have the code to run it against each server generated for you so you can just hit run.  Sure I Can do it with more code, but it'd be great if I didn't have to.  Something along the lines of what Hyena by Systemtools can do for network administration.



To help us help you read this

For better help with performance problems please read this
Post #216529
Posted Friday, September 2, 2005 8:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 9, 2009 2:25 PM
Points: 22, Visits: 11
From the article:

"The plan is to give them the features only if they promise to build the product we want. No ‘we'll look into it' or ‘we'll see what we can do'. I'm only turning over the list if they promise to give us our features in a fairly reasonable timeframe."

Do you really think that is productive? How can a vendor promise features if they don't even know what they are before you are requiring them to commit? Don't get me wrong...I love this idea of compiling a list of feature requests as a community but I think it should be done in an open way so we can build off each other's ideas.
Post #216601
Posted Friday, September 2, 2005 9:02 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
I second that... what are your ideas?
Post #216606
Posted Friday, September 2, 2005 9:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 24, 2014 8:40 PM
Points: 174, Visits: 454

i really miss the rectangular copy feature of Brief, how many times do you get an email thats got text pasted in column formatting that you only want to use columns 20 thru 30 for the task at hand.

you can't do anything like that in a microsoft editor...

Post #216624
Posted Friday, September 2, 2005 12:40 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 11:26 PM
Points: 3,214, Visits: 2,336
The include/exclude lby line, line/column/block of code for edit change/replace of a venerable old product - TSO SPF/EDIT from the mainframe world. The global search and replace regular expressions of EditPadLite from the windows world (actually snagged from the Unix world). Then add some of the powerful one key/control key commands of the 'vi' editor from the Unix world.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #216740
Posted Friday, September 2, 2005 1:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 5, 2009 2:31 PM
Points: 41, Visits: 18
I have to agree with katesl on the code repository.  It sounds like what you want is a shared folder somewhere.  I mean, that's what we use at my company and it works quite well.  QA defaults to the same open directory, I open up whichever script I need and start running code to troubleshoot/fix whatever problem comes up.  It's not a terribly complicated solution to that poblem, but it works quite well.


Rational Anarchy
Post #216765
Posted Wednesday, September 7, 2005 9:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 4:58 PM
Points: 9, Visits: 17

One of the features they pulled from 2005 is the Auto Complete feature.  This is helpful for someone who is new to a DB/Table, as well as improves the ability to quickly add items needed.

Would like to see one where the AutoComplete works across Databases and Servers.

Also, ability to easily go to a graphical view and back to scipt mode (think MS Access, or Enterprise Manager Views), but also smart enough to handle CASE and other statements that normally are not graphically displayed.

Able to create/learn your coding style, and apply to code (Formatting Script), this includes use of Tabs, how to structure SELECT statments, your Column List, etc.

Post #217657
Posted Friday, September 9, 2005 6:50 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 21, 2009 10:33 AM
Points: 50, Visits: 10

I wish MS would just make the changes, why should we have to depend on 3rd party vendors?

Some of the most obvious ones that should have been in QA long ago and will be very disappointing if they are not in 2005:

Parenthesis () checker!!!!!!  Please don't make me yet again check manually the ltrim(rtrim(str())) statement I just wronte.  - As a side note, why the heck isn't there an alltrim() in T-SQL????

Intellisense/AutoComplete!  Functions (substring, dateadd, etc) and procs should give you a tool tip to remind you of arguments as you type.  Tables and view should have Intellisense so you can type "select authors. "  and have a list of all the fields from the table authors.

Auto Correct!  How many times have you typed "selcet col from table"? 

Code Snippets!  Something better then templetes.  Also, when I type "case" or "if" the IDE should know what is coming next and create the outline of the construct.

Auto Formatting!  Indent and format views, procs, and adhoc queries.




Post #218642
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse