Miscellaneous Software

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case the section for a few odds and ends of industry-specific (other than legal), hard to classify or one of a kind software. I may be forgetting some that would fit here, particularly ones there might have been since I compiled the list back when. In no particular order, the list as best I can remember…

Dental practice software – a couple of them
Restaurant menu creation software (may have been MenuMaker)
UPS Worldship
wINDEX
Grammatik
Lotus Organizer
MS Project
Brother’s Keeper
Family Tree Maker
WavePad
Lyris (music program)
iTunes
Winamp
Nero Wave Editor
Automap Streets
Google Earth
Lantastic
Norton Utilities
PC Tools
Norton Ghost
FMS (Franchisee Management System) for PDA (Property Damage Appraisers)
ADP automotive estimating software
Mitchell’s estimating software

The dental stuff is from free advice to my old dentist, a look at her new system when she got it, and an evaluation of dental software for another dentist my partner tried to land us as a client.

The menu software was on a machine I replaced for a restaurant owner, so I installed it on the new one and got to play with it.

I’ve encountered UPS Worldship in a couple of places. While in one I mainly just installed and configured it, in another it was a major troubleshooting exercise in a client’s warehouse/shipping office when it wouldn’t work properly.

wINDEX was an old DOS program for creating book indexes. I got to play with that years ago when a friend was in the indexing business.

I bought Grammatik as part of a package along with WordStar 5.0, and found it a highly entertaining early effort at grammar-checking. Considering how long ago that was, and that grammar checking still doesn’t work perfectly, it was a surprisingly good effort. Ironically, a grammar checker is most needed by someone who can’t write, but people who can’t write have a harder time knowing when the software is being silly and ought to be ignored.

Lotus Organizer wasn’t, if I recall correctly, also an e-mail program like Outlook, but more of a standalone calendar an PIM. I liked it a lot, though never used it heavily myself.

If I recall correctly, the main reasons I ever looked at MS Project were curiosity, and because a customer was trying to use OLE (COM) automation of it from a VB program. Come to think of it, I may also have helped my brother-in-law, who had actual uses for it.

Brother’s Keeper for DOS and Family Tree Maker are my dabbles with genealogy software, mainly the former. One of my colleagues in VB support was trying to write his own, which I thought was cool, and got some help from me.

I have used or played with or helped with various music and sound players, creators and editors. I find that kind of thing especially cool, despite not being musically talented myself.

Lantastic could perhaps have gone under the online and communications part of things, or under a server and networking post. I knew it inside-out when I supported Tranti POS systems. On one level it made sense to use an off-the-shelf network solution to link the machines. It ended up being a problem, as there were just enough issues with it to create bad situations over which they had no control. If your 50 ohm terminator was bad, we could replace that. If something funky with Lantastic made one unit go off the same page with the rest, that was ugly.

I’ve used at least a couple of incarnations of Norton Utilities. I used to swear by PC Tools. I used at least two versions of that, also. There may have been other such utilities. Certainly other utilities, anyway, including things Microsoft eventually incorporated into the OS, or things too obscure to mention, like disk copying software. I’ve also fought with Norton Ghost. Which should probably have gone in a different section; I just happened to remember it here. There’s just been too much for me to remember it all. This is meant to be a “mostly” overview, making clear the scope and range of experience, not an exhaustive list.

Added FMS, which I mentioned in passing under databases. Also added the two automotive estimating software packages I have supported. There were some other utilities used in the same office, like one for dialing a service with salvage yard pricing and parts availability, but they were less significant and I don’t remember their names.

Next up, security, spam and malware.

Posted in Experience, Hardware, Job Hunting, Skills, Software | Leave a comment

Backup and Compression Software

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case relating my experience with backup and compression software. In no particular order, the list as best I can remember…

Microsoft Backup
ARCserve
Retrospect
Veritas Backup Exec
Stomp PC Backup
PKZip
Winzip
NERO Burning ROM
Adaptec/Roxio
Stacker

Stomp and my first look at Retrospect were help with evaluations or troubleshooting by a former partner, for someone he had as a personal client without putting them through the business. The big client used ARCserve from way back, originally under Novell. Later they switched to Veritas backup Exec, which I liked even better and which, at least at the time, had a reputation as best of its kind. The people we outsourced their upgrade to in fall of 2006 completely ignored the presence of the infinitely superior Backup Exec, replacing it with Retrospect, now an EMC product, which gave me some experience fighting with it and trying to puzzle out how anybody could have created such an obscure maze of unusability.

I used to be able to make PKZip dance and sing, and even resisted Winzip for a while. Eventually I bought five Winzip licenses to reward them for being so good and useful. I don’t recall ever using a Winzip competitor, but I did do a VB support call once with a guy who told me his product competed with them.

NERO was my favorite CD burning software. I found it entertaining when Microsoft adopted Roxio as the native software for XP and made sure NERO as packaged with CD burners wouldn’t work. The archiving and CD burning computer at the big client had Adaptec software, which worked just fine. That machine had a fancy SCSI Plextor burner in it.

Putting Stacker into this list is a bit of a stretch, but I did use it heavily in its heyday, and was entertained by the whole Doublespace/Drivespace thing. I never used Stacker or anything similar again after it killed my original 60 MB MFM drive, which was cannibalized out of my Packard-Bell 286 to build my original 386.

Next up, miscellaneous software.

Posted in Experience, Hardware, Job Hunting, Skills, Software | Leave a comment

Legal Industry Software

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case relating my experience and associated history with legal industry software. Juris products are excluded, as they were included here. In no particular order, the list as best I can remember…

West Publications Premise
West Publications LawDesk
Lexis-Nexis
Loislaw
Shepard’s Citations
Couch on Insurance
Wintitle
FRED.net
Winlaw
Prometheus
Amicus Attorney
Legal Files
AbacusLaw
Lawyer’s Diary PC Edition
Turbolaw

Naturally I’ve worked with the legal research and associated software, mainly Premise 3.72 and 4.0. I helped with evaluation of Lexis-Nexis and Loislaw research.

Wintitle and FRED.net are associated with real estate practice.

Lawyer’s Diary PC edition incorporates and expands upon the content of the annual bound Lawyer’s Diary. Most people prefer the book, but some are avid about the extra features in the (rather oddly designed, IMHO, at least when I supported it) software. Updating a network installation was… interesting.

I once had lunch with the guys behind Turbolaw. At the time, it was a package centering around templates and automation of Word and Excel to populate the appropriate forms you’d file in certain types of cases, like family law (divorce) and worker’s comp. One attorney needed it. I noticed the name of the company was Promethean Software, and I mentioned to them that we were working on law firm software named, or at least codenamed, Prometheus, so their name caught my eye. That led to a lunch meeting in Fitchburg between a few of them, me, and my partner who was primarily responsible for Prometheus, and the name. At first, on the phone, one of them thought the name was no big deal. Later they asked us not to use it, to avoid confusion. Oddly enough, despite some of us not having cared for ‘Prometheus,” and people jokingly referring to it as “Promiscuous,” we never did come up with a catchier name. We showed them some printouts of screens as it stood then, and talked about what it would do. They were terrified by it, because had we wanted, our product could easily have incorporated the functionality of their less comprehensive but more specialized product. There was some discussion of sending them a beta to play with when it was ready, and doing joint marketing of the two products. That would have been a huge boost. Subsequently my partner stopped working on it for a while, then started over from scratch. Prometheus went so far as to be used in a six-person law office until they ran up against its limitation of working only with Microsoft Office document types. Otherwise it was flawless, so there was little “support” involved beyond getting it setup. Unless you count that I looked into adding PDF support, but could not work it into the existing code.

Which brings me to the whole case/document manager thing. We did some evaluation of products in the genre, which is part of what led to Prometheus, as we thought we could do it better. Which when the iron was hot might have been true.

Winlaw was the reason we even knew about such things. Winlaw was software by a company named The Counsell Group, or TCG, which eventually dotcommed itself into being Breakaway Solutions and then defunct. The big client hired TCG to create Winlaw, as apparently nothing available “off the shelf’ at the time would do. TCG had plans to make a version for wider sale, and even trademarked the name Winlaw to reserve it for legal software purposes. It was a great name, especially when you consider it dates back to the days of prefixing software names with “Win” being all the rage.

There were problems. Mainly the problem was that it was a VB3 app using a shared Access 1.0 database as the backend. Access data was never meant to be shared by 40 – 50 users. It locked. A lot. To the point of being down something like 45 minutes per day per user.

We were hired to fix it. The client settled with the original vendor and got full and unfettered ownership of the code for the purpose. We improved performance, ported it to VB5 and later VB6, migrated them to SQL Server as the real way to eliminate any locking, and had it stable since the beginning of 1999. Subsequently we added a utility to enforce data gathering about each case at the time it closed. I improved the user interface, made it so some user defaults could be set, made it so searching could be done for exact or “like” (wildcard) matches, and that sort of thing. I also discovered and fixed a longstanding bug in the original code, whereby it could and did, fortunately rarely, overwrite a document with a new document of the same not-quite-random name. I also wrote a separate utility that could copy all the documents for a case to a specified location, or archive them, which was the same except for deleting the documents from the server if it copied them successfully.

My partner got it the majority of the way done, then decided it would be far better to write an all new program. We would offer the client a version specific to them to satisfy the project requirements, but also be able to market a generic release to other firms. That was Prometheus. The first incarnation of it, largely complete, was used by a couple people in a small firm. They stopped using it only because it was overly oriented toward the types of cases the big firm handled, and was overkill for them. When I pushed for a more complete version because we had someone else wanting to use it, who would test it more effectively, my partner quickly created a new (admittedly improved) but similarly undercooked version of Prometheus. I managed to clean up some loose ends and make it installable, so we had six people using it for a couple years. As mentioned, the main problem ended up being that it couldn’t handle PDF files, and I couldn’t rapidly enough make it do so.

It was kind of cool, but simple compared to most of the case/document/practice management software out there. I had wanted to put out a basic version, even just as freeware/shareware, as basic document management for anyone.

Besides Winlaw and Prometheus, I have actually supported Amicus Attorney, which didn’t impress me. I’ve played with Abacus, and possibly others I’m forgetting. Legal Files is the somewhat complicated, product the big client moved to from Winlaw. I helped them decide on it. I played with a demo version and worked with the sales and development people there on migrating data and documents from Winlaw. That was my last major work for the client, and left me impressed with what I’d done.

Have I forgotten any legal-oriented software? Perhaps, but it’s a limited range of titles. Next up, backup and compression software.

Posted in Experience, Job Hunting, Skills, Software | Leave a comment

Communications, Internet, Handheld and Blogging

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case the communications and internet related section. It probably leaves off various modem dialing software I’ve forgotten, but remains a long list covering a ton of ground. I considered breaking it down further, but what the heck. This is also a list that feels to me like it could be updated the most, to include modern, web-based tools like Facebook, Twitter and Google+, which strike me as a new category. And as something the proverbial everyone uses, so the point would be? In no particular order (actually, I’m attempting to group things logically), the list as best I can remember…

Blue Wave offline reader
Wildcat!
Procomm
Various modem software
Various fax software

Outlook
Outlook Express
Thunderbird
MS Mail
Exchange client
Lotus cc:Mail
Lotus Notes
Eudora

Exchange Server
Ipswitch Mail Server
Internet Information Server
NSlookup

Internet Explorer
Lynx
Firefox
Safari
Netscape Navigator
AOL software
Chrome

FTP Explorer
Cute FTP
Filezilla

Webex
PC Anywhere
Remote Desktop Connection

FrontPage
w.bloggar
pMachine
Wordpress
Expression Engine
Movable Type
phpBB
Textpattern
BlogDesk

Blackberry software
Various Palm and other PDA/cell phone utilities
Microsoft phone software

AOL Instant Messenger
MSN Messenger
Yahoo Messenger
Google Chat

Arrow mailing list software
Lyris List Manager
Mailman

Wow! You got that all? Basically it’s miscellaneous early stuff, e-mail clients (dedicated or multipurpose), server stuff and utilities, web browsers, FTP clients, remoting tools, blogging tools and web page editors, handheld and phone stuff, and chat software. Added later, it includes mailing list software too. There are undoubtedly things I don’t remember, even apart from what’s covered under “various…” whatever entries. For instance, I know I used DNS tools on the same dedicated server that had Ipswitch mail, but I couldn’t tell you what that was called. I’ve used other utilities of that sort, and also you wonder when is it networking and when is it internet or communications related. Now for some details and history, which promises to be somewhat lengthy.

I wanted to get a modem for my Color Computers, but it would have plugged into the same funky slot used for the overpriced external floppy drive, making it kind of hard to run the computer at the same time I connected to one of the numerous local BBS numbers the anomalous (and short-lived) clueful guy at Radio Shack gave me. My first modem went in my first 386 instead. As I recall, that was 1200 baud, followed shortly by a 2400 my mother got me for Christmas. I knew a guy who ran a BBS in Boston named Tangent. I became addicted to that, which already included people I knew. He got UUCP feeds of newsgroups, including the VB and Robert Jordan ones at my request, and of course was on Fidonet. I checked out other boards, but mainly that was home.

Through that, my very first internet e-mail address ever was @tangent.shore.net, before he got a domain. Unrealized by me at the time, my second e-mail address was @microsoft.com, via Microsoft Mail, through which we were directly on their mail system, even though we were outsourced. Ultimately Tangent got a domain, vader.com, so my first non-work, non-subdomained e-mail address was there. I posted a lot on the comp.lang.basic.visual.misc newsgroup, in the heyday of a guy named Jens Balchen, along with some other regulars. Probably a little weird to work all day supporting VB, then post free answers for people, but I’m a geek. I specialized in setup wizard and app distribution, and in automation of Word from VB apps, so I tended to latch onto those posts. My very first web browsing was through the BBS, too, via the Lynx text browser.

In a way, the first killer e-mail and newsgroup app for me was Blue Wave. Even on a dialing plan that made Boston free, occupying the phone line ad nauseum wasn’t always a Good Thing. An offline reader was perfect, and it was a great program.

I never ran a BBS myself, but I got a copy of Wildcat and played with it wistfully, which helped me understand the sysop side of things even better. By the time I might have been thinking of hosting a BBS, I got on the internet proper. My first ISP was a fly by night named Nexus, and my first e-mail address via my very own ISP was @nexuswww.com. That company closed without notice and walked away with about five months I had prepaid. I turned to a more stable outfit then, ICI, and was with them or their successors from… that must have been 1996… until early 2004, and then for another year or two as a backup ISP for work.

But I think this qualifies as digression, even as detailed and history-recounting as I mean for these posts to be.

The e-mail clients are almost self-explanatory. When I was at Corporate Software/Stream, we used cc:Mail internally, and eventually that switched to Lotus Notes Mail. We used Lotus Notes all along, for other things. I was at the periphery of some actual Notes database work one of my colleagues did, though I don’t recall doing that myself. Nobody liked Notes mail. We also used MS Mail, while we were still directly on Microsoft’s mail system. Eventually that changed. Then later still, when customers expected to e-mail us things @microsoft.com, we again got Microsoft addresses, routed through and administered by the Mail and Exchange support team. I believe that was when we used Exchange client. I know I used it at some point.

I’ve used Outlook Express extensively, Outlook some, and tried Thunderbird a couple of times. I helped someone with Eudora. I’ve supported Outlook extensively, mainly 98 and 2003.

As mentioned, Ipswitch (IMail) was both what I used for webmail at one time, and what I administered for a year on a dedicated server. Later I got the big client on the internet, via four channels of a T-1 that was otherwise used for phone service, and setup e-mail to go through their proxy server to Exchange. I installed and administered Exchange 5.5, IIS, proxy server, set them up to use Outlook Web Access. Later I got other clients online through DSL, and one of them on Exchange under Small Business Server 2003. In the end, I did some of the administration of Exchange 2003 for the big client.

I mentioned Lynx. Naturally I’ve used IE. I preferentially use Firefox. I swear I remember using Safari once, can’t remember exactly where, and think it must have been on the Apple laptop of a graphic designer/marketing person I worked with on the big client’s web site design. Which means I’ve used more than just the two Macs eons ago I mentioned under hardware. I don’t think I have used Opera, but I could possibly have tried that or other browsers. Oh! I have used Netscape Navigator, come to think of it (he exclaims, scrolling up to add it to the list, which just wasn’t big enough already). I’ve actually supported AOL hands-on for people, which is why that is on the list. Always exciting. Finally, I’ve used Chrome, but didn’t take to it.

I am a command line FTP person going way back. I still resort to it sometimes, depending what I’m doing and whether there is a decent client handy. To do something like upload every file for a new WordPress install efficiently, you want something like Filezilla. Not FTP Explorer, which tends to “forget” files if you have it do an upload that includes files in subdirectories. For one or a few files, command prompt works fine. At least, it does if you’ve long since learned all the basic commands and can whip them out and employ them any time.

I’ve used PC Anywhere off and on since 1993. Host was loaded on the primary workstation POS on the Tranti systems, and we could call in using PC Anywhere Remote. That was used more from home, given the limited PC resources we had available at the office. I also used it to administer a dedicated server, and in helping with computer support for my father’s business.

With Webex, on the other hand, I have only been on the receiving end, working with Juris support on a major problem that after tens of hours of my time turned out to be an obscure file version mismatch. It’s cool. As is remote desktop connection, which I’ve employed recently, enabling me to do almost everything from home that I’d have gone on site for before.

I created my first personal web site in 1996 or 1997, and have maintained a business site since 1997, which remains as a legacy site since 2007.

I’ve used Blogger, which isn’t listed, and the other blogging systems that are, at least trying them out. I added phpBB to the bog list because a while back I made an extensive but ultimately unsuccessful attempt to help a blogger fix problems with it.

Did you know Microsoft once made phones, and voicemail software used on your computer in conjunction with them? Yup! I bought that system sometime after moving to Quincy in 1999, and ran it on my old Pentium 200. I had it until the phone portion died. It was pretty cool. At one point I figured out how to get WAV files of people’s messages out of temporary files to keep them for posterity.

I’ve helped various people with cell phone synchronization, and done a lot of installing Palm desktop software and helping people with it. It was years ago I first supported a Blackberry. One attorney bought a used Blackberry and got the service such that she could have e-mails forward out to it if she left her computer and Outlook running. I filtered it so she’d get only the most important stuff. It may have been that experience that led me to get a Blackberry myself in 2006, though I have since retired it.

I’ve used the various chat programs, speaking of addictive. I’ve actually broken the habit long since. It was too easy to be interrupted.

One of my friends and former colleagues once discovered that MSN Messenger exposed an object model through which it could be automated with VB code. To a degree, anyway. I recently made the same discovery about iTunes. I was whipping together a simple program to automate restoration of archived documents (batch file does the work, but the software builds the batch file, rather than a lot of copy, paste, edit, replace trickery), so it would take me a few hours rather than, say, twenty. I briefly tossed in code to launch iTunes and start playing the default list, just for the sake of curiosity. Anyway, I helped a little with the MSN automation, and trying unsuccessfully to fix it once Microsoft broke it by changing the object model drastically.

Finally, there are mailing lists. I have run a mailing list for former colleagues in Visual Basic support for some fourteen years. For a while I ran one for former Access support people, and one for job hunting, to share both positions available and wanted, share advice on resumes, etc. I forget what tool I was using on the original web host, where e-mail was Ipswitch IMail. Later I had an overpriced 64k partial T-1 connection in the office. I checked out Lyris, but it was Linux-oriented and wasn’t going to work for me. I found an excellent, easy to use list software called Arrow and ran that on an old computer, right in the office. Eventually I ended up using Mailman, associated with web hosting.

I guess that’s it. No telling what I might have forgotten. Next up will be legal industry software.

Posted in Experience, Hardware, Job Hunting, Skills, Software | Leave a comment

Dictation Software and Some History

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case relating my experience and much associated history with dictation/voice recognition products. In no particular order, the list as best I can remember…

Dragon Naturally Speaking
IBM Via Voice
L&H Voice Express
Phillips handheld dictation/transcription software

There may have been other software that would fit this category, but these are the big three voice recognition products, plus the one digital device and its associated software I supported.

Voice recognition software is of special interest to me dating back to 1984 or 1985. For my major we had to take two computer science classes, plus a “data processing” class that fell under the Management Science department rather than the Math department. At the time, the class was a relatively basic “all about computers.” Which was pretty weird, because most management students were taking a very similar computer class offered just for them by the computer science people, then taking BASIC. A semester or two after I took it, they got PCs, courtesy of a donation from Shaw’s Supermarkets in thanks for a big study done for them by the marketing students, and the class changed completely. They taught segments on Lotus 1-2-3, some word processor, I believe some other packaged software, and some elementary RPG (Report Program Generator) stuff. Which I might not have known, but I actually helped a couple of classmates with their work for that class, even though I had never taken it or learned the stuff myself. Classic me. When I took the class, we had a great professor named George Ladino, who not long after left to work in “high tech.” Which seemed to me the thing I might want to do, but I thought I’d always be behind the curve and never have adequate qualifications, connections or whatever. Heh.

Given my terror of speaking before a group such as a class, it is particularly notable that he required us each to do a presentation to the class on an assigned topic. Mine was voice recognition. After all, computers were getting all advanced and stuff by then, so why should Scotty have to settle for quaintly typing. Talking your computer down from the ledge had to be right around the corner.

That was how I learned about Ray Kurzweil, the work he was doing, along with the work IBM was doing, and how tricky an exercise it was. The fascinating subject helped ease the pain of public speaking, to the extent that was possible.

Flash forward to 1998. Well, sometime before then, really, when I first saw Dragon being promoted at computer shows and thought here was the eventual result of all that early work on voice recognition. In 1998, though, when we first connected with the big client, they’d been dabbling with voice software. Several of the attorneys had Pentium 200 machines, for which they’d seriously overpaid, with Windows 95 and awful no-name sound cards, on the idea they would dictate using IBM Via Voice. Between the hardware, the state of the software at the time, and the natural dragging of heels that never stopped, that didn’t go over so well.

They were still interested in the idea. At least, the more tech savvy people were. The owner, who had been partially behind the original push and dreamed of paperlessness from way back, before it was remotely as possible as now, had mixed feelings about the cost involved in getting even a part of his vision.

In early 1999, we purchased Dragon Naturally Speaking Preferred 3.0, and the corresponding current versions of IBM Via Voice and Lernout & Hauspie Voice Express. We and a couple of the lawyers tested them. Dragon won, no contest. It wasn’t even close. As I recall, IBM was the next best option. Varying numbers of people used Dragon ever since, and unlike some software, most updates were worth buying. It actually required minimal support. Usually the problem is that sound quality goes astray. There are ways to test, and only so many things it can be. Headsets and microphones die or get frayed cables. Sound cards die, if rarely, and these days the sound is usually integrated into the motherboard and is both adequate and stable. User profiles get corrupt and new ones have to be created, much as it sucks to lose all the training you’ve done. That kind of thing. Windows Sound Recorder can give an idea how the hardware is working. It’s so big now that installation can be fun, and the hardware needs are great. Dragon 9.0 wouldn’t run on Vista, so you had to download a major update. That’s how I came to support Vista without having actually used it myself yet. My days of supporting it ended before newer versions of Windows, and of course now people can speak to their phones, voice recognition and hardware have come that far.

Next up will be communications, internet, PDA and blogging.

Posted in Experience, Hardware, Skills, Software | Leave a comment

Database and RDBMS

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case relating my experience/history with database/RDBMS technolgies/software. In no particular order, the list as best I can remember…

PC File
Paradox
Access
MSDE
Microsoft SQL Server
Sybase SQL Server
MySQL
DB2
Oracle
bTrieve
dBase
FoxPro
Lotus Approach
Microsoft Query

Some of the above items are there because I have direct and even extensive experience. Others are there because I supported the use of the product or database format programmatically, mainly from Visual Basic, and had some degree of associated training. So, for instance, the presence of Oracle or DB2 on the list does not imply I could jump into a hardcore DBA job with one of those products. I have also left out some of the incidental data sources that can be used programmatically or with Word mail merges, including Word, Excel, and text formats, be they CSV, tab separated, or fixed field width.

I believe my first database experience was with PC File, by shareware pioneer Jim Button’s ButtonWare. It was used circa 1990/1991 on my 286 to administer and print mailing labels from the Arisia database as it existed at the time.

When I worked at Tranti Systems, I got a taste of Paradox, which was a hot skill at the time.

Later I worked with people who supported Microsoft Access, and have used most versions of it myself. Because of the UI limitations of SQL Server 6.5, I used Access with attached SQL tables for administrative ease. I’ve supported and trained clients in using it the same way to query their data in both SQL Server (Winlaw) and bTrieve (Juris Classic). It was, of course, the default/customary database backend for typical VB apps that needed one.

My main server database experience has been with Microsoft SQL Server, from the standpoint of having installed, reinstalled, configured, administered, etc. Besides having accessed, or helped others access, data on it programatically or via other front ends.

MySQL I know manly from blogs, and having gotten into the admin tools to do queries, export data, even do mass cleanups.

MSDE is sort of where Access intersects SQL Server. I used that for distributing at a test site a beta version of a case/document management software, codenamed Prometheus, that was never be completed. I also supported MSDE as used by the newer, Windows versions of Juris until the 2 GB size limit became a factor.

bTrieve used to be an inexplicably popular backend for applications. Besides supporting the use of it with VB, it was used in Juris Classic and a program called FMS (Franchisee Management System) by Property Damage Appraisers, both of which I’ve supported. I believe it was used in some aspect of Tranti Systems 2100. Or something at the company; I clearly remember it being around, if not any specific unpleasant experiences with it.

I worked with people who supported FoxPro, so got a little exposure that way and through VB/Fox interactions calls. More recently, I dealt with Fox in the form of a couple of FoxPro-based applications, one more raw than the other. One was a custom order entry system. I did a little brief support of it, helped migrate the server side from Novell to Windows 2003, and helped make sure it ran after the workstations were upgraded to XP. The other was Wintitle, a program used in real estate closings, in which the Fox aspect was mainly useful in understanding its peculiarities.

In VB support I was never what you would call a “database person.” I got by. Similar to my emphasis on good user interface design, my big thing is proper relational database design. It’s surprising how often you run into poor design, even from people who are supposed to be experts. It’s one of those little things that stick out like a sore thumb to me, bothering me all out of proportion. I’ve never been as clear as could be on the distinctions between different join statements, but if you name your tables and fields funny, if you aren’t clear on your one to many foreign keys, and your many to many linking tables, that sort of thing, I will notice.

Next up, dictation software, odd as that may sound.

Posted in Experience, Job Hunting, Skills, Software | Leave a comment

Graphics and Presentations

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case relating my experience/history with graphics and presentation software. In no particular order, the list as best I can remember…

PowerPoint
Corel Draw
Jasc Paint Shop Pro
Microangelo
Adobe Illustrator
Microsoft PhotoDraw
Microsoft Photo Editor
Microsoft Paint
Visio
AutoCAD
Ulead PhotoExpress or PhotoStyler
Graphics portion of DeskMate on Color Computer 3
Jasc Animation Shop
The Print Shop

There are ones I can’t remember, like a particular 3D graphics program I played with back when computers could barely handle it, and a cheesy early CAD software. There are others besides the Ulead software that were bundled with scanners. There’s the built-in graphics features in Word, which were my other specialty besides macros when I supported the product. I created a detailed training handout on the drawing tools in Word just before I transferred to VB support.

Then in VB support, I eventually ended up doing the segment of training covering graphics. Speaking of which, there’s the icon editor that came with Visual Basic, which did what it needed to do but couldn’t compare to Microangelo. I know I’ve looked at the presentation and graphics software with other suites, like OpenOffice, but by now that almost goes without saying. Also speaking of VB, I wrote a goofy little program called KidPaint that also isn’t listed. Never thoughts I’d see the day one of my own kids could play with it.

While I wrote this up, I remembered that I’ve used Microsoft Publisher. One of the first PC softwares I ever used was a thing called IMSI Publisher. So are those to go under presentations, or under word processing? And what about Adobe Acrobat, the full version? Distinctions, distinctions…

Next up, database and RDBMS.

Posted in Experience, Job Hunting, Skills, Software | Leave a comment

Spreadsheets and Accounting

This post and others like it relate back to an introductory post that explains the point. This is an edited variant of something I wrote in 2007, in this case relating my experience/history with spreadsheets, bookkeeping, tax, timekeeping and accounting related products. In no particular order, the list as best I can remember…

Excel
Google spreadsheets
Lotus 1-2-3
Quattro Pro
Multiplan
Quicken
MS Money
Quickbooks
Peachtree
Juris Classic and Next Generation
Juris Management Console and various utilities
Juris Time Sheet
Juris Expense Sheet
VisiCalc
DAC Easy Rapid Tax
Star Office
OpenOffice
First Choice
TimeForce Qqest time clock
Tranti time clock
XTreme Time Minder

There are probably others I’m forgetting. Some of the above were various versions. The funny thing is, I’ve done support for programmers who were working on accounting software packages, but not ever used the ones in question myself.

I’ve ended up using Excel regularly.

The Juris products are peculiar to law firms, where I supported them, including a big migration from the “classic” DOS version using BTrieve data to a 32-bit version for MSDE or SQL Server.

With my accounting degree, you’d think there’d be a bigger emphasis on this stuff, but not really.

I added the two timeclock systems and the timekeeping software I used internally. For the Timeforce Qquest, I actually set it up, isolated the timekeeping machine on a separate network with the bookkeeper’s computer, helped figure out how to use it, and later fixed a polling problem. For Tranti I wrote documentation for the standalone timeclock, and supported the timeclock software integrated with the POS system. I wrote Time Minder for entering time and categorizing activity based mainly on the wishes of a large XTreme Computing client, but such that it could also be used for any client and internal timekeeping. In an earlier, completely different version I had a stop/pause/resume/start measuring function I thought was cool but wasn’t as needed or useful as expected.

Next up will be graphics and presentations software.

Posted in Experience, Hardware, Job Hunting, Skills, Software | Leave a comment

Career Change?

In a way, it’s redundant to talk here about a career reboot, since that was part of the entire point of the my-name site, and not completely a new thing. It always came down to money and logistics. I mean, apart from any questions of what in the world I’d doing, feeling (probably far more than actually being) washed up in the computer-related areas that would be most logical.

A little history:

I’ve been into computers and gadgets to some degree since the seventies, experienced with PCs since 1988, building/rebuilding/fixing them (PCs – I was good with electronic gadgets at work from one of my first jobs, when I’d save the company service calls on their fancy package scale postage meters) since 1992. I first made a living at support starting in 1993, ended up with the kind of support/management job by 1998 that impresses people to hear about, went off to be self-employed full time in 1999, went out of that business in 2007, and continued to dabble in updating a web site here and fixing a computer there since then. I was management at the business, as well as all the other hats involved in writing and maintaining software, running networks, supporting applications, PCs, and so forth, mainly for a good-sized law firm client on which I was almost completely reliant. I’d always expected that the only way to get them to update adequately would be to turn them over to another provider, but that made it no less devastating when it came and I closed up shop, now behind on technology and, more importantly, confidence. Even though when you get me going, I’ll admit that I am Just That Good.

Meanwhile, I’d married and had kids. We ended up in a state of equilibrium, where she works full time for too little money, I work a compatible part time schedule for too little sleep, we come close to making it, we avoid the “donut hole,” and the kids are cared for without daycare and the hundreds of dollar a week that would entail if we both worked full time.

Well, it may be time for a flip of positions.

That means on the one hand deciding/figuring out what in the world to pursue for work that’s full time, and on the other hand how to prepare myself for it and sell myself. On the plus side, the financial angle differs from what it would be were I trying to work full time concurrent with her also working full time. I could make as little as double what I make in an average of 22.5 hours a week, rather than asking more than four times that. Just to account for tax, benefit and child care consequences.

Not that I couldn’t have done with more money already. I had already settled on writing as my next career to start on the side while still working part time. A good thing to engage in with no downside, under the circumstances, but riskier, to say the least, if I were swapping to prime earner.

Now it’s a matter of dusting off my resume, evaluating my experiences and interests all over again, updating this site to what it was meant to be, editing LinkedIn, letting people know, brushing up some skills, those sorts of things. I’m excessively generalist, computer-wise. I have the business/management background, if not seriously high-powered. Failed interviews before I gave up included basically being laughed at for going out of business. In one case, from a “if you’re a failure, how can you be management” perspective. In another case, from an “it’s raining IT work soup, how could you have been reliant on one client and gone out of business unless you were a complete idiot” perspective. Apparently not everyone has heard that you learn from mistakes, perhaps even more from successes.

Sometimes I regret not having pursued the accounting/finance angle that my degree would suggest. I can’t see making my way back to that now, or wanting too beyond a what-if minor wistfulness.

We’ve more than joked about my becoming a chef, but that would involve culinary school, and might not be a great move financially and in other ways.

It always comes down to some confluence between management/coordination and IT. Or perhaps writing and IT, since the second biggest skill group I’ve been endorsed for on LinkedIn involves writing, be it software documentation or otherwise.

Posted in Uncategorized | Leave a comment

Thomas F. Fish

On May 15, 2012, my friend Tom Fish died of natural causes in Greenfield, Massachusetts. If no obituary is published elsewhere, let this serve as one.

Tom was born June 26, 1961 in Levittown, NY, to Prescott Hayes Fish, late of Florida, and Ida Theresa “Tess” Cash, late of Massachusetts. He was by far the youngest of four children, and to the best of anyone’s knowledge has predeceased a brother, two sisters, at least two nephews, and at least one niece. He is survived by two children, Anne and Alan, and their mother, Diana.

This paragraph is an update to what I knew and what had transpired at the original writing. It is 1/29/23. It bothered me that I didn’t remember the names of some of Tom’s family, even though I had met them many years ago. First, both parents had indeed predeceased him. I was uncertain of that until I wrote this originally, but have found the info online recently to have exact dates. His unlamented stepmother died subsequent to Tom. His brother-in-law, David J. Croan, had died in 2005, and his sister, Alice G. Croan, passed July 10, 2017. Her children, the niece and nephews I had met in my youth, were Daniel A. Croan of Fall River, MA, Keith D. Croan of Colorado, and Kathleen A. Richards of Pembroke, MA. This is the part of the family known to me. There are also several children and great grandchildren to Tom’s sister. Since he’d held himself estranged from the family, I don’t know that Tom ever was aware of any marriages or offspring of the near-age relatives. Other siblings to Tom that I now know of were named Donald and Suzanne.

Tom spent much of his life in Massachusetts, moving in his youth from New York to Cape Cod, then to Pembroke, where he attended Silver Lake Regional High School. We met there in 1975. Subsequently he attended University of Massachusetts at Amherst for English and History.

Tom lived briefly in Florida, which is how I came to spend several weeks there in 1986. Then he lived for a time in New Hampshire, before settling in western Massachusetts, a place he had come to love during college. Most of that time was spent in Turners Falls, where he served for a time as a town meeting member and on the zoning board of appeals. Again, he was the reason I spent some time living in that area. He could be most persuasive and infectiously enthusiastic.

In his youth, Tom loved genealogy, for all he was not always close to his family. He was proud of his links to the Mayflower and early Cape Cod settlers, and would haunt libraries for hours in the pre-internet days, once dragging me along. I was bored, apparently being more fascinated in theory than with the nuts and bolts, nee this and begat that. In one line, he went farther back than anyone I know, to the hundreds AD.

It was Tom’s father who suggested that he get into title search, applying the genealogy research skills to real estate. That broke him out of the classic post-college drift, and ultimately out of his discomfort with being an employee. Despite how scary and rocky it was getting established, risking being entrepreneurial, he was tenacious. He could always write well, and could be one of the most persuasive people I knew. That helped him get established. Being good kept him busy, until the internet changed the business for everyone. He had an impressive run.

In the end, Tom turned to book indexing, another good application of his ability to focus on details and producing accurate results.

Tom was active in the U. Mass. Science Fiction Society, the roots of his later achievement of being one of the co-founders of Arisia, a large Boston area SF convention and the organization of the same name that runs it. He was how I came to be involved in that.

While I never thought of Tom as “a dog person” or a particular lover of animals earlier in his life, he did have a dog, a Sheltie named Wanderer, when we first met. That was the dog on whose nose we mischievously put Pop Rocks. Later in life, he started a group called Valley Dog Rescue. It mostly centered – still does – around a mailing list of people involved in rescuing and placing dogs and other animals. If he could have, he would have devoted all of his attention to dog rescue. He brought people together and accomplished much good.

Tom will be missed by the many people whose lives he touched over the years.

Posted in Personal | 4 Comments