|
I do. In my tool chest are dozens of tools that are of my own devising, because I either found nothing publicly available, or the available tools were deficient in some way. Once upon a time, I even published some of them, but nobody seemed to care about them, so most now remain private. A handful remain online in a small GitHub repository that I created as a reference/resource repository for use with the packages in my other repositories. Though they got into that kit because one or more build scripts requires them, many of these tools are generally useful command-line tools that are in some way better than the stock system tools they replace.
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
I do that too - a lot. Although, I haven't written a command-line tool in quite some time now. I wrote a little dialog-based app that I clone for most things now. Mostly because I have a drag-and-drop edit control that I use all the time and it makes the UI very easy to use.
|
|
|
|
|
Is this D&D edit control something around which I could create such a tool?
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
Probably. I found it at this site. There's a D&D combobox too which can be useful.
I made them work in 64-bit unicode mode also. If you don't want to deal with that then let me know and I will try to send them to you, somehow.
|
|
|
|
|
Rick York wrote: Probably. I found it at this site. There's a D&D combobox too which can be useful.
What happened to the URL?
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
Interesting take on the sharing principle.
I've got several that I use at least once a week or more. The latest is an FTP client, because as you mention, I couldn't find one that did everything I wanted. Another would be a sql restore utility that can be started with a right-click of a .bak file. (this one saves me the most time per week) I've considered sharing but am reluctant due to company policy. I suppose it could be reasonably argued that these tools were mostly developed after hours and on weekends...as utility apps they don't directly contribute to company revenue. Explaining to the boss that you spent 4 hours on a cool little utility that might save you 10 minutes a day is a conversation I'd rather avoid. Instead, I can be super-productive, get the jobs done on time and have plenty of leisure time!
"Go forth into the source" - Neal Morse
|
|
|
|
|
kmoorevs wrote: Explaining to the boss that you spent 4 hours on a cool little utility that might save you 10 minutes a day is a conversation I'd rather avoid. Instead, I can be super-productive, get the jobs done on time and have plenty of leisure time!
I might not want to work for your boss. Let's see, that's 10 minutes per day on tedium that would be better spent on new work, so you've recouped your investment in the first 24 days.
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
See and PLAY!!
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
digimanus wrote: In Word you can only store 2 bytes.
???
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
word is in c#
ushort
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
How you can improve your workflow using the JavaScript console is an excellent summary of the methods afforded by the Console class. Although the context of the article is the Web browser console, the information is equally applicable to the Node console. The examples made clear some methods that weren't entirely obvious without an example and its output to study.
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
|
Thank you!
This is very much appreciated!
|
|
|
|
|
You are most welcome!
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
Thanks
One very useful command not covered in the article is the debugger command.
Create a line with debugger; and every time that line is hit the dev tool of the browser will open at that line with the run paused.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
Thanks for calling my attention to the debugger command. Though I vaguely remember a reference to it, I've never seen it in action. I'll do my best to remember to do so the next time I'm working on some JScript that runs in a Web browser.
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
So we have this SSRS report that is supported via several SQL jobs that do exactly the same thing for a specific set of facilities, each with their own ID. Each job is comprised of about a dozen steps representing a mic of SSIS packages and plain old sql. As you might guess, each job has its own facility id hard-wired into each of its steps. On Friday, I was tasked with adding support for an additional facility ID (and adding support for a new column in the source data).
Today, I generalized all of it by creating stored procs that accept the facility ID as a parameter (to replace the sql steps), and a single ssis import package that accepts the facility id on the command line.
The result is a single job that performs work for all desired facility id's (five steps per facility ID), and it only takes about five minutes to add support for additional facility IDs instead of the better part of two hours to create and test a whole new set of packages and associated SQL agent. The real silver lining is significantly eliminating the possibility of copy/paste errors when creating the steps.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Just don't tell anyone, you'll have a 2 hour break every time a new facility is added.
|
|
|
|
|
Quote: In every job that must be done
There is an element of fun
You find the fun and snap!
The job's a game
And every task you undertake
Becomes a piece of cake
A lark! A spree! It's very clear to see that
A spoonful of sugar helps the medicine go down
The medicine go down, the medicine go down
Just a spoonful of sugar helps the medicine go down
In a most delightful way
|
|
|
|
|
|
The best laid plans of mice and men sometimes work out fine.
|
|
|
|
|
That's really amusing. I got an email from some code regarding a very similar issue and how to fix it.
I didn't quite buy the fix, it seemed odd. Refactoring a Reporting Services Report with Some SQL Magic
And congrats for the win. I often experience management kicking and screaming when I suggest similar optimizations.
|
|
|
|
|
I empathize with you about management kicking and screaming when you suggest optimizations. Why do you suppose that happens?
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
The biggest food distributor in xxxx (with some 90 "divisions"; 100,000+ service workers, and billions in sales), duplicates all the job streams and "data schemas" (VSAM files!) every time they create a new division ... which happens every few months.
The only change is the division "identifiers".
90+ duplicate job streams running every day.
The "head" responsible for this is a 30+ year "company" man.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
John Simmons / outlaw programmer wrote: The real silver lining is significantly eliminating the possibility of copy/paste errors when creating the steps.
So what are the government beauro crats supposed to do all day?
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|