Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Calling All Editing Buffs


Calling All Editing Buffs

Author
Message
KenpoDBA
KenpoDBA
Mr or Mrs. 500
Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)

Group: General Forum Members
Points: 582 Visits: 617
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.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:


katesl
katesl
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 473

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.."
Luke L
Luke L
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2894 Visits: 6120

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
Andy Ognenoff
Andy Ognenoff
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 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.
Ninja's_RGR'us
Ninja's_RGR'us
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22161 Visits: 9671
I second that... what are your ideas?
Bill Scott
Bill Scott
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 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...


Rudyx - the Doctor
Rudyx - the Doctor
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3536 Visits: 2478
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."
ryan-201613
ryan-201613
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

Group: General Forum Members
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
Brock McDonald
Brock McDonald
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 29

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.


jgoodwin
jgoodwin
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 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.





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search