Friday, July 31, 2026

Joining the ranks of the idle rich

This is the way the world ends
Not with a bang but with a whimper
(T.S. Eliot, 'The Hollow Men')

I've already quoted this epigraph at the end of my MBA studies and it seems pertinent to quote it again today. I have now joined the ranks of the idle rich, although I'm not idle and I'm not rich. In plain language, I have retired from full-time work.

I sent the parting letter to everyone at work as well as to some outside people with whom I have contact. I received in return some warm replies, and the chairman of the board (who lives in Canada) even telephoned me yesterday afternoon to thank me for all my work.

My last day was subdued: we had set up a test server the previous evening and someone had forgotten to turn off the task scheduler, so in the morning I saw many duplicate reports in my mail box. Once that was fixed, I went over procedures that would send me emails, changing the destination of those mails. A few more fixes and that was that. I had forgotten to remove myself from all the groups to which I belong, which would mean that every day a multitude of reports would be sent to my (now closed) email address; I fixed this in the evening.

So now I become a contractor and it will be interesting to see how often I will be contacted and how many hours I can charge throughout the month. I suspect that there'll be frequent consultations in the coming week but then this should taper off.

I don't feel anything special at the moment, although as it is the weekend, effectively nothing is unusual. The first moment of change will be on Sunday morning; I am cancelling the alarm clock that would wake me at 5:30 am. The swimming pool is closed on Sundays so I don't even have to get up in time to swim.



This day in blog history:

Blog #Date TitleTags
27231/07/2010How things have changedLiterature
74531/07/2014Feral systemsDBA
105931/07/2017Mobile CPAPCPAP
197631/07/2025No more normal ... and how science fiction handles mental illnessPsychology, Robert Silverberg, Non-fiction books

Thursday, July 30, 2026

Minor accident

About ten days ago, I slipped on the stairs leading to our flat. Fortunately, I was almost at the bottom of the staircase so I only fell two steps. My right forearm took most of the impact although somewhere else in my body also got hit. I lay there for a few minutes without moving, trying to get my breath back. I was taking the dog for her early morning walk - she didn't pull me causing me to slip, and when I was lying on the staircase, she simply waited for me to get up. It's not clear to me how I managed to slip - I think that my feet touched the front edge of the stair instead of the back.

Looking at my forearm a bit later, I could see that there was a minor abrasion but I didn't pay much attention to it. When I showed my arm to my wife, she said that there was a huge swelling in the area that I hadn't noticed because it was on the 'dark side of my arm'. It wasn't hurting very much (if at all), but I took an ibuprofen pill to help control the swelling.

Over the past few days, the arm hurts only if I rest it on something (like a chair arm) or raise it to the height of my eyes. It does not hurt when swimming. It was at the pool a few days ago that I noticed that my inner forearm has turned yellow and that there is a red area not at the same place as the abrasion.

The red area is easy to see but the yellow part, which starts slightly after the wrist and continues to past the elbow can't easily be seen in the photo. I don't want to manipulate the colours too much as otherwise it won't look natural.

The yellow is of course internal bruising and shows that the impact caused much more damage than I originally thought. But there are no broken bones, and it's just a matter of time until everything sorts itself out.



This day in blog history:

Blog #Date TitleTags
18830/07/2009Speed IIIProgramming, Office automation
27130/07/2010Nice workDavid Lodge
61530/07/2013SynchronicityTV series
105830/07/2017Sing Street (2) - A few more observationsFilms
152130/07/2022Kate Bush - a little harmonic analysisKate Bush, Music theory
164930/07/2023The swimming pool show - addenda and updatesMusical group
197530/07/2025The making of "Five leaves left"Nick Drake, Joe Boyd

Tuesday, July 28, 2026

Parting letter

Following is the text that I sent this morning to all the employees. Yesterday I attended my 'farewell party' in Karmiel, after which several people came up to me for chats.


Dear friends,

After 37 years at Tzora Furniture and then in the Global family, it is time for me to end a significant chapter in my professional life and retire. I arrived at Kibbutz Tzora in 1989 and was immediately assigned to work at the factory. Since then, I have gone on a long and fascinating journey — from accounting, through the implementation of ERP systems, to the development and implementation of computer solutions that have become an integral part of the company's daily operations.

Over the years, I have had the privilege of working alongside dedicated, professional, and above all, good people. I have learned from each and every one of you, and our collaborations have always been a source of pride and satisfaction. Most of the time, I have enjoyed serving you, introducing new processes, and solving challenges together that came up almost every week.

I apologize if I have offended anyone along the way. Any disagreement or unpleasantness has always stemmed from our shared desire to do the job better — never from a personal standpoint.

The late CEO, Eli, used to say that there are no problems, only challenges. I must say that at times you have challenged me greatly, but I am happy to say that the challenges created synergy, and in the end both sides benefited. I believe that these challenges have made me feel much younger than my biological age.

I am finishing work a few days before my 70th birthday with a great sense of satisfaction. Two goals have accompanied me throughout the years: to improve the flow of information between the company's departments, and to empower the employees. I believe that we have succeeded in both goals, and I am leaving behind a good infrastructure and legacy for the future. Many times I have been happy that the work fits me like a glove, but in reality that is because I designed the role quite a bit myself and could not have done it without your support, so thank you.

Thank you for years of trust, cooperation, professionalism and friendship. I wish you all great success in the future.

Best regards

Noam



This day in blog history:

Blog #Date TitleTags
18628/07/2009Speed, speed, speedProgramming, Office automation
27028/07/2010The in-basket 5In-basket
61328/07/2013A neat hack: right clicking a grid's title barProgramming, Delphi, ClientDataSet
115828/07/2018100 yearsPersonal
197328/07/2025Adding comments to the blog manager programBlog manager program

Saturday, July 25, 2026

Redefining primary keys as composites

On the weekends, I've been occupied with updating one of the OP's database programs to Delphi 12CE and unicode. I'm becoming very familiar with this so the conversion has been straightforward for most of the time. I'm not going to write about that today.

I was working on the forms that allow data in the MATSCALE table to be edited; this table is really a 'junction table' that defines which 'scales' are connected to which 'purposes', where the 'purposes' table contains entries such as 'work', 'absorption to kibbutz' and similar. Had I was defining this table for the first time instead of inheriting something that I defined 20 - if not 30 - years ago, then I would probably have only the two columns, 'purpose' and 'scale', that together would create the primary key. I have found it occasionally difficult to work with such a primary key and find it easier to create an auto-increment integer that can serve as the primary key.

It occurred to me early this morning on the dog walk that I could take a leaf out of the way that Priority defines tables; there must always be a primary key (denoted U, for unique) and there can be an autoincrement (denoted A), where this column often serves as a foreign key in other tables. Although I have never done this before, I should change the MATSCALE keys so that the primary key is purpose + scale, leaving 'id' as an autoincrement that is not a key. This way, the same scale can never be defined twice for the same purpose.

Having the idea was relative simple but implementing it was hard. The first thing that I did was to duplicate the MATSCALE table, including copying the data, so that I would have an easy to access table with the data should I need to restore it. I had tried various means of changing the primary key, but none of them worked until I found the following solution: first, define 'id' as a normal integer instead of being an autoincrement (this was in case of having to recopy the data). Then I defined both 'purpose' and 'scale' as not null, committing each change in turn. Then I was able to edit the primary key, adding the two new columns and removing the original column. I then reconnected the 'id' column to the key generator. I dropped the copied table, of course.

So now I have an autoincrementing column that is not the primary key; the actual PK is combined of two columns. I am documenting this in case I decide to implement the same idea elsewhere. I know that there are similar tables in both this database and in the management database.



This day in blog history:

Blog #Date TitleTags
9725/07/2007Life is stranger than artPersonal
9825/07/20071972 - the year I've been leading up toIsrael, Habonim, Kibbutz, Richard Thompson, 1972
18425/07/2009Better late than never - IIRichard Thompson, Fleetwood Mac, Albion Band
26925/07/2010The in-basket 4Programming, Delphi, In-basket, Resource files
38725/07/2011Human Resources Management resultsMBA, HRM
88025/07/2015Vinyl log 21 - 25 JulyRichard Thompson, Vinyl log
105625/07/2017Guitar cornerGuitars
124625/07/2019Running a procedure from a screen triggerPriority tips
197025/07/2025Ding Dong, the witch is dead!Personal

Thursday, July 23, 2026

Challenges and out of the box solutions

I wrote1 yesterday about how the old CEO would challenge me with various problems. I forgot to mention that my manager mentioned that often she would come to me with questions that either I could solve on the spot or those that needed a bit more thought (see the accompanying picture). Often I would solve 'the impossible' either in the shower or when walking the dog.

I also mentioned that there appears to be a bug in Priority regarding certain SQL queries although I won't go into detail about the bug here. I went out with the dog for our early morning walk and a solution for fixing this bug popped into my mind. It's not a complete fix, but it's good enough for the time being. The only way to get there was to ignore the standard method of doing something (which appears to be bollixed at the moment) and find an out of the box method. It helps to do this when one is far away from a keyboard.

Internal links
[1] 2121



This day in blog history:

Blog #Date TitleTags
9623/07/2007Favourite filmsFilms, Woody Allen, Meg Ryan, Diane Keaton, Kevin Kline, Hugh Grant
26823/07/2010Porting the Amateur Reasoner/2Prolog, Bill Thompson
105423/07/2017This bird has flown: the enduring beauty of Rubber SoulBeatles
164523/07/2023The beginnings of a new songHealth, David Lodge, Song writing
196823/07/2025Dave Cousins RIPObituary, Sandy Denny

Wednesday, July 22, 2026

The season of farewell parties

There are six more workdays left until I retire as a full-time salaried employee. I will be working after this, but as a freelancer who chooses his own hours and doesn't have to hear from the entire workforce. So in the days that are left, it is time to part from as many employees as possible.

Today there was a 'farewell party' in the branch where I have worked for the past 36 years, my 'home team'. First, my manager, the chief financial officer, praised me to kingdom come in front of all the employees there (about 20). At first this was OK but towards the end became a little embarassing. She spoke about how I have always served professionally whoever would come to me for help, and how I have solved many thorny problems over the years. She told how I have created an information eco-system for the company, creating reports and work protocols that have advanced the company over the years. This was as much for those who are not aware of what I have done over the years as it was for those who were well aware.

I began my speech by noting that whenever I attend a funeral on the kibbutz, I hear the deceased being praised in glowing terms, and I always think that it's a shame that the deceased never got a chance to hear all these wonderful things being said about him/her. I have the advantage of being alive to hear my 'eulogy'. I then talked a little about how it was in the early days, and how certain workers who are still with us began their employment. I said that like on Yom Kippur when we all request forgiveness for anything bad that we might have done, I request forgiveness from anyone with whom I might have had a dispute: if so, these disputes were always on a professional basis and not personal. I did say that I have personal and professional satisfaction from the legacy that I am leaving behing. I also recalled the late CEO who would often substitute the word 'challenge' for 'problem'; he challenged me frequently and I doubt that I could have achieved the same results had he not been there with his challenges. I mentioned that this branch implemented ERP 'by the book' and would always use it as an example to the other branches who frequently did their hardest to implement ERP as it is not meant to be implemented; I had to find ways that their protocols could match those in Priority as much as possible.

Several people came up to me personally after the speeches to shake my hand and say a few words. Most surprisingly, one was a new employee who said that he didn't know me but that he had heard of me and wanted to wish me well. That was very kind of him.

There will be another such 'party' in Karmiel next Monday; there it will quite different as first of all, my connection with that factory started only in around 2008 if not later, and secondly because I am only there once or twice a month, so all communication is either by email or by online meetings. My manager will not be there, but I will hear either from the CEO or from the factory manager (if not both) what they have to say.

There will probably be some form of 'party' in Tel Aviv towards the end of August as well as a special celebration for the finance department to which I belong.

I am not resting on my laurels: there are still some thorny problems to be solved at work that only I can deal with. After a minor upgrade a week and a half ago, there are several procedures that have stopped working for most people (but not for me), where the problem seems to be connected with choosing parts as input.  I figured out how I can run these procedures under the debugger when the person running the procedure is not me but an ordinary employee. I saw that when I run these procedures, a normal SQL statement is created, but when they run the procedure, a ridiculous statement is created that apparently joins one part with the entire table of parts, causing the procedure to crash eventually . I have passed examples of this problem on to the company that gives us professional support, but I haven't heard back from them yet.

I have prepared a general farewell letter to be sent to the entire company by email some time next week. I will send it a few days before I finish as it would be nice to read what people have to say. After I retire, my account will be closed so that no one can write to me anymore with their problems - or even their best wishes. I will leave a message 'this email address will self-destruct in ten seconds', but I doubt that many people will get the reference. I must also remember to write to the company that supports us, although I will stay in contact with them, only with a different email address.



This day in blog history:

Blog #Date TitleTags
26622/07/2010Porting the Amateur ReasonerProgramming, AI
26722/07/2010Beef ratatouieCooking
61222/07/2013Transferring cassettesPersonal, Old recordings
74122/07/2014Rice and beansCooking
74222/07/2014And now for something completely differentFilms
88222/07/2015Vinyl log 20 - 22 JulyVinyl log, Fotheringay
179322/07/2024Italian phrasesItaly
196722/07/2025Resuscitating the Donner octave pedalPedal board

Sunday, July 19, 2026

Rugby, cricket and music: memories of 1968/9

Yesterday's post1 about the death of Gary Sobers (and previously, JPR Williams2 and Mike Procter3) show how important professional sports (even though rugby was amateur) to me at an early age. After all, I was a few weeks short of my 12th birthday when I saw Sobers in the flesh. For a few years, I was a junior member of Bristol RFC and Gloucestershire CC, allowing me entrance to the members' area and a much better view of the games. It wouldn't be for another year before sports began giving way to music as my primary hobby, or as I should say, obsession.

I don't think that I realised at the time, but I was lucky to see Sobers in the flesh because it seemed that once a player had reached international level, he stopped playing at the club/county level. As I noted in the obituary of JPR Williams, I saw him a week or so before his international debut and would never have seen him again. I was very surprised at some stage to discover that Bristol RFC was the home club of John Pullin who played hooker for the English rugby team and even captained it at one stage: I had never seen him play for the club.

And as for music: I remember that sometime in 1968 I bought a mini-guitar that had four strings (it wasn't a ukelele) and tuned it in some strange way. I suddenly started writing songs although they have been lost forever and I have no idea what they might have been about. I do remember that I was in France4 in the spring of 1969 and wrote some form of a song on some odd stringed instrument; I realised afterwards that I had written a copy of 'Eleanor Rigby'.

I learnt my first guitar chords at the summer camp of 1969, along with writing the lyric for a song. This was the true rebirth of my interest in music which grew and grew and no doubt had a negative influence on my performance at school.

Internal links
[1] 2119
[2] 1706
[3] 1722
[4] 239



This day in blog history:

Blog #Date TitleTags
9419/07/2007What I did at work todayProgramming, ERP, Thermal printers
74019/07/2014Statistics with SQL (Firebird)Programming, Delphi, SQL, Firebird, Statistics
96419/07/2016When the music's overDCI Banks, Peter Robinson, Police procedurals
124319/07/2019Making the Greece holiday videoHoliday, Home movies, Andros, Athens, Greece
164319/07/2023If this is jazz then I'm all for itAmbient music, Matthew Halsall
179019/07/2024Sorting on two columnsProgramming, Delphi, Office automation

Saturday, July 18, 2026

Sir Garfield Sobers, RIP

Sir Garfied Sobers - or as he was known in my childhood, Gary Sobers - died yesterday  a few days short of his 90th birthday. and was the consummate cricketer of my childhood. His name was in the record books at the time (the 1960s) for having made the highest score in test cricket, 365 not out, but he was also a fearsome bowler.

Although I must have watched him play for the West Indies on television, I was also privileged to see him play in the flesh in June 1968 when I was a junior member of Gloucestershire CC. I remember the occasion although not the date (Copilot found it instantly, 22–24 June 1968). 

During the match, there had been intermitten showers, and indeed the players had left the pitch during Sobers' innings. When play resumed, Sobers scored 98 runs before getting out. Even though he hadn't made a centurty, he received a standing ovation from the around the ground, and especially in the member's enclosure where I and my friends were. I remember trying to touch him - touch a  cricketing god! - but I don't remember whether I succeeded in doing so. 

As Copilot put it, Sobers’ 98 was described as one of those innings where the number didn’t matter. He dominated the bowling, lifted Nottinghamshire’s innings, and played with that effortless authority that made spectators feel privileged just to be present. A standing ovation for 98 — as if he had reached a hundred — is exactly the kind of reception Sobers inspired. County crowds adored him. They knew they were watching the greatest all‑rounder in the world, and they treated him accordingly.

Two months later, Sobers entered the history books again by being the first player to score six sixes in a single over off six consecutive balls in first-class cricket. 

From the Guardian obituary, I learnt that he captained West Indies in 39 Tests, with a sense of adventure in keeping with the character of someone who loved to gamble at racecourses around the world. All this he did while pursuing rum, women and the sort of hedonistic lifestyle that makes the tales about Botham seem like nursery rhymes (in his autobiography, Sobers dealt candidly with his jousts with the bottle in his early adult life).

Anothing sporting legend of my youth has passed away.



This day in blog history:

Blog #Date TitleTags
26318/07/2010The in-basket 3 (whole lotta programming)Programming, Delphi, In-basket, Combo box
73518/07/2014Research proposal submissionDBA
96318/07/2016Someone's tiredGrandfather
124218/07/2019Sending data to a procedurePriority tips
178918/07/2024Back to normal (computer)Computers

Friday, July 10, 2026

A new driving licence

 Five months ago, I wrote 1 that 'my driving licence - the small, plastic covered, real licence arrived. Looking closely at it, I see that the expiration date is 03/08/26, which just happens to be my 70th birthday. There is no mention of how I get a new licence after that: presumably I apply at the Ministry of Transport's website then wait another few months for the new licence to arrive in the post. In other words, this entire saga will repeat itself!'.

I had got the notion that I would be sent a medical form towards the expiration of the licence so that I could have my eyes checked once again and have my GP confirm that I am medically capable of driving. But no form has arrived, so the other day I went back to the transport ministry's website where I was informed that 'your licence is about to expire'. Tell me something that I don't know. All I had to do to renew the licence was pay an exorbitant 269 NIS fee and then I received on the spot a new licence that is valid for six years.

When I write 'a new licence', I mean that I received a PDF of the licence that I printed out. The real 'small, plastic covered' licence is 'in the post', but I won't hold my breath until it arrives.

Internal links
[1] 2076



This day in blog history:

Blog #Date TitleTags
9110/07/20071970 - Nice enough to eat/Habonim camps IIHabonim, Sandy Denny, Nick Drake, Blodwyn Pig, Nice enough to eat, 1970, Joe Boyd, John and Beverley Martin
73610/07/2014Analysing ExcelDBA, Excel
87610/07/2015Vinyl log 18 - 10 JulySandy Denny, Vinyl log, Fairport Convention
140710/07/2021Funeral playlistPersonal, Father
195910/07/2025More bad writingTom Clancy