Reasons for that: economy and layoffs – we have zero control on neither; at certain point, companies and organizations started to discriminate against older workers in terms of hiring and firing (layoffs), due to their potentially higher salary, higher healthcare expense, and so on.
Surprising, at least for now, AI is the not main reason for the tech layoffs, per the YT video below.
Note we have no controls over the layoffs, especially in terms of the company’s decision. In theory we have some influence such as do our job well, but this is not guaranteed to help one avoid layoffs.
Some of the things I can think of or I am doing
Blogging (make some ads money from Google, very hard). The downside of this one is it takes lots of traffic to generate a bit ads revenue. Similar for the YouTube video creation. For me this is even harder than the eBay.
Selling on eBay (is eBay increasing becoming a flea market, btw?). One side benefit of selling on eBay is declutter, as well as reduce, reuse and recycle theme. Reducing the carbon footprint is rewarding for me.
Part-time gig (e.g., adjunct teaching at Webster U). Note this is not scalable as it’s mainly selling time for money.
Stocks: note this one is risky. But it potentially could have more rewards (again, this depends on many factors, such as the capital one has).
It looks we have some minor issues on the web page above: mainly on the right side “Frequently Asked Questions“. Two things I noticed, and below is 1st corrected one:
All students practice at least 16 drills annually. They consist of at least:
10 Fire Drills 2 Active Intruder Drills 2 Earthquake Drills 2 Tornado Drills
(this part is at the bottom, should be moved up)
Why should my child participate in active intruder drills?
Drills are a way for students and staff to practice and be prepared to act in a crisis. Active intruder drills are clearly identified as “Only a Drill,” and we have members of our staff who are trained to assist students with special needs. All students should be trained so that they are not only able to use these skills taught at the school, but also in any dangerous situation they may encounter outside of school.
Touchy topic, is alert system such as #Centegix#crisisAlert helpful or worth the money during intruder / active shooting situation? Has any college (in addition to K to 12) implemented it? #schoolSafety#majorsSurvey2023
My quick thoughts: knock on the woods, 我们学区/学校相对来说是安全的。当然，世界上没有绝对的安全。我来美国27年，00年到圣村，05年搬到Creve Coeur，后来就一直住在拉肚学区。经历过Columbine high school, sandy hook elementary (new town), 近年德州Uvalde 小学，圣村CVPA （central visual and performing arts high school, Stl city) 等。从一开始不理解为什么美国人需要枪到现在不理解为什么美国人需要冲锋枪(assault rifles, AR series). 当然还有September 11 – it’s another big topic.
(Update 09-18-2024) Now I remember when my old daughter was in the middle school, once they had some similar hoax on the TikTok, and one day a lot kids (or their parents decided) not to come to school, after seeing the thing on TikTok.
I don’t have any positions. Note IPO usually stands for “it’s probably overpriced” – this is Warren Buffett’s words, not mine. Last but not least, in the general sports apparel/shoes category, not specialized sports, Nike is the king. And I don’t see any one even Amer Sports‘s parent Anta Sports to shake things up. Adidas tried, and was not successful so far. Btw, Jim Cramer of CNBC also just bashed the stock $AS in this evening (02-01-2024) Mad Money show.
Recent demand spurred a request from Bayer to increase existing nonstop service on Lufthansa from three to five days a week.
Looking to the future, Bayer is interested in nonstop scheduled service to São Paulo, Brazil to reach their South American markets. https://t.co/xaKrkqrCV9
The air ticket from mid-west USA to China is getting more expensive after the cut of American Airlines (AA) and United Airlines (UA) ORD to PVG or PEK flights since pandemic in 2020. There are some alternatives nowadays. Besides the cross Atlantic routes below, there are direct flights from Delta Detroit (DTW) to Shanghai (PVG), and from AA Dallas (DFW) to Shanghai (PVG). In fact I took the Delta DTW to PVG (note it’s not daily) last March: I wrote 2 blog posts for that trip – ChinaTrip Spring 2023 – Logistics, and China Trip Spring 2023 – Observations And Thoughts.
Note air tickets and their pricing are always dynamic, and if you are interested in the direct flights from Chicago (ORD) to mainland China (ORD or PEK), please check with the United Airlines’s website, as well as 3rd party websites such as flychina.com (look for “中美直飞航班“) or simpleflying, or aggregator website such as expedia.com. For American Airlines I don’t see they will add back the direct flight from ORD to China in the near future, because they already have the direct flights (daily) from Dallas to Shanghai now.
Cross Atlantic routes
There are some new routes pops up in recent years: mainly fly via Chicago (ORD) and London (LHR), or Frankfurt. If we want to reduce the number of stops, Frankfurt is a viable option (I looked at the dates in June/July, it’s about $2,765 for STL/PVG round trip). Note this is 3 times a week flight (LH449):
Louis Lambert International Airport (STL) to Frankfurt, Germany. The airline uses Airbus A330-300 aircraft for their three-time a week service (with arrivals and departures every Wednesday, Friday and Sunday).
This one stops at Vancouver and lands at HKG. It works out for us: I mean the route. We also got the connecting Amtrak tickets from STL to ORD, and also from HKG to the mainland via trip.com.
Also there are hotel costs: my wife thinks those hotel points are free. They are not. I found out the most expensive hotels are in Vancouver (we want to stay near YVR).
Again websites we used for air tickets are: Expedia.com (Air Canada), trip.com (HKG to mainland)
My CSP card approved the Air Canada ticket purchase at Expedia.com. But it won’t let me purchase a smaller amount one way air ticket from HKG to NBG. Tried couple times. It triggered fraud alert. Later I got it cleared. It seems I could not use the CSP card for Vancouver hotel booking at Expedia as well. Tried Amex Gold to buy the mentioned air ticket: same results. No alerts but not going through either. Eventually I went to trip.com and used another credit card (Amazon Chase) to get it working. The reason I used Amazon Chase is it doesn’t have foreign transaction fee, and it seems to me trip.com is based in Singapore. I think I tried the CSP there at the 1st step too.
For the Vancouver hotel booking at expedia.com, I used another no foreign transaction fee credit card (Hyatt Chase). I know Expedia is based in the US, but the hotel is in Canada.
Last but not least, I used the CSP as a backup card for the hotel in NGB. I also checked with my friend in NGB to make sure that they have taxi there when we arrive there late at night.
Adding kids to the hotel room
This will cost more in some cases: e.g., the expedia.com booking at Vancouver, I noticed some hotels raised price as soon as I added my kids. In the extreme case: DoubleTree Beilun, it offers me the Presidential Suite as soon as I input in my 2 kids. I get by this issue by only inputting 2 adults (my wife and I). Obviously during check-in we will show kids’ ID etc.
This also reminds me one more thing: as my kids get older, they will likely need a separate room from me 🙂
Last but not least, as I get older, I want to stay at nicer place too. So probably no more Jinjiang Inn or Home Inn.
Some after thoughts
I calculated the total cost, it’s about $1,700 per person, which is cheaper than alternative ways such as via London. The downside is the length of the travel including those stopovers. To alleviate the travel fatigue, I tried to book nicer hotels as much as possible.
Last but not least: I realized although I chose the “option of choosing seats” at expedia.com, in reality though, I need to pay up at Air Canada website in order to choose the seat for the ORD to YVR flights (from and to). They do allow me to choose my seats (and my wife and kiddos’ seats) for the YVR to HKG flights (again from and to). Below explained why. This also vaguely made me to recall shortly after the financial crisis in 2008 and 2009, airlines usually asked passengers to pay a small amount of money for luggage, probably ranges from $10 to $50 for those short haul regional slights. In bitter cold winter days, people tried to avoid this fee, by drop offing the luggages at the gate, then wait in the cold temperature for the luggage at the bridge upon arrival. I was thinking: is this the America that I came in summer 1997 🙁
We had 2 snow days right out of the gate this month, once because it was extremely cold (1/16 Tuesday), another time it was due to the freezing rain and black ice on the road. Basically the road become a skating rink (1/22 Monday).
The green firetruck hit the blue car (nobody inside), barely missed the house, fortunately no one got hurt
Both my kids loved snow days. In the process I also learned the typical Americans’ ritual to get snow days: such as “Wear your pajamas inside out.” On serious note, black ice (ice on the concrete or asphalt) is dangerous both for the cars and the pedestrians. I have 1st hand experience on both. Once my minivan was spinning like the firetruck above at the Briarcliff club house parking lot. Another couple times I was walking like a duck crossing the Olive road, or walking near Olive and Spoede road.
School buses and the drivers for school buses would encounter the same issue. And the teachers and staff too. Plus the parents (guardians) drive or walk kids to school. This is a no win situation in terms of going to school. And we can always learn or have school on a normal day.
School lunch
Last 2 weeks, my old daughter got hurt during tennis clinics (group class). And I sent her to places to make sure she is okay. Once I bought her Chick fil a on the way back from provider to school around lunch time. She liked that. I think the school lunch is probably not as good or flavorful as the chick fil a sandwich.
My younger daughter does bring lunch to school on Fridays. So yesterday morning at the bus stop, right before the bus coming, she said: I forgot to bring the lunch. I said: I can either do carpool to drop you off, or I can drop you off at the next bus stop that your friends will also be there. We did the latter.
(Original) Some people may know I worked at CAD industry for a while: I actually explained a bit here (search for “my 1st employer”).
I heard about Bentley Systems many years ago, but until fairly recently, to be precise in year 2020, it came to public market. Here is their IPO prospectus filed in Sept 22, 2020. In last year or so, I traded and still own some of their stocks $BSY (note this class of stocks has less voting power compared to the Bentley families, and this is quote common in tech stocks, btw. More explanation in the next paragraph). And in last few days, the stock dropped quite a bit and I added a bit more in the last few days too.
Their main competitor includes another former employer of mine: AutoDesk $ADSK. I didn’t stay at AutoDesk as long as the 1st employer of mine. Unlike AutoDesk and many medium sized software companies, Bentley has a small quarterly dividend: 5 cent per share. Note the Bentley families still has the voting power. It’s probably one of the few family controlled software companies in the world. Many software companies are public and has no controlling shareholder: with the exception of Alphabet (Google), Meta Platform, and Hashicorp $HCP etc. Founders usually have control of the company via Dual Class Stock. In a way Berkshire Hathaway has a similar structure too: A share has way more voting power than B share, and Warren Buffett and his family has the control.
It seems they just exceeded $1 b annual revenue in year 2022 (here are the link to their annual reports in recent years).
Future and risk factors
Family control. No check and balance from outside shareholders. Note this is true for many companies. The exception is usually when a stock underperforms the market for a long time, an activist shareholder may emerge, e.g. Nelson Peltz vs. Disney at this time.
Likely lower growth or even negative growth in China, both in terms of R&D and end market. This is similar to many west/US tech companies. APAC (Asia Pacific made up about 18% of the revenue, so this is still manageable).
US recession, or no growth. Possible, but software companies usually sell products in multiple years, eventually the growth will come back, even with the economy cycle.
If you just want to look at the contractor list, it’s here.
Basic Knowledge
Living in the USA usually also means driving and owning a home. And we need some knowledge about the cars and the house. Even if we live in condo or apartments – in those cases we typically don’t need to mow the lawns and in the case of apartment, the leasing or the management company usually is responsible for things such as refrigerator, HVAC (AC and furnace), cooking stove, built-in microwave, windows and doors. And sometimes carpets too: if it’s worn out. We need to know basics such as the AC is usually for summer, heat is for winter; windows usually has a screen, lock the dead bolt for the main door over the night – in the good old days, I left the keys in the door overnight a few times, with family, kids and so on, I am more careful on those type of things.
Once, the furnace at my condo had issues, as you can read from this blog post (search “minor scare”). After that I learned a bit more about how the heat is generated in our home in winter. Note there are two main energy sources for the furnace: electricity – which is the one at my old condo, and the gas – which is more common in the Single Family Homes in the area.
Single Family Home(SFH)
If one owns a home, it will need more knowledge and work. For example, the home owners are usually responsible for the trees in the front and back yard. The tree requires quite a bit of work, in addition to picking up the broken limbs, branches, the leaves and sometimes the sweet gums (or other nuts) if the tree produces lots of nuts such as acorn.
Sometimes broken tree branches hang on the tree. I think it’s best to remove them, because it could potentially fall, and hit someone or something. It actually happened to me once: the broken branch hit my roof, and caused a small damage. I knew the branch was there, and I was hoping it didn’t fall. Hoping is never a strategy, btw. Recently when this sort thing happened again, I contacted the tree company and asked them to take out the dead tree branch, in addition to trimming the branches. Trimming is a common task too, especially when the branch is approaching a electric wire, or the roof.
Sometimes, when the temperature is extremely low, such as this week, I found the garage door cannot automatically close. It seems the door needs some lubrication. I think I probably need to do some research on YouTube and do it. The door worked fine when the temperature bounced.
The Major’s Contractor List
The Google sheet view only is here. If you like to contribute or participate as an editor, please email me: minjie DOT xu AT gmail DOT com, and we can go from there. I did think about post it on GitHub, so that we can have some version history etc. But I haven’t decided it yet.
“They brought them in from other areas of the company. The new leadership team – from my director down – they all came from St. Louis, Missouri. They said they were all buddies there.”
“That entire team came down. They were from the military side. My impression was their mindset was – we are going to do it the way we want to do it. Their motto at the time was – we are in Charleston and we can do anything we want.”
“They started pressuring us to not document defects, to work outside the procedures, to allow defective material to be installed without being corrected. They started bypassing procedures and not maintaining configurement control of airplanes, not maintaining control of non conforming parts – they just wanted to get the planes pushed out the door and make the cash register ring.”
(Original) I recall the famous Warren Buffett said that investing is somewhat like investigative journalism. A lot of my day work (software development) is in some way like that. Reading other people’s code. Trying to understand and ask what and why.
The failure of Boeing 737 MAX is in someway due to “lack of curiosity” from top all the way down.
Let’s throw the baby out with the 🛀 water. I think they did okay except the MAX disaster (both literally and figuratively). Still something they can overcome as a company – but again this will take a leap of faith and we are sorta trying to bet a turnaround story. Hindsight is…
My tweet on Boeing stock today 01-16-2024: I have a small long position now
Also, came across two Cramer’s takes on Boeing, this one is recent. Another the second one was a few years ago shortly after the 2nd 737 MAX plane downed.
I started software development journey from Oct 2000 in the US (my LinkedIn profile here), for about 8 years my main focus was the C++ CAD software development, and I didn’t use much Database or SQL in my day job. I did take a graduate level database course when I was in Rolla in year 1999 or 2000.
I started to use database, SQL and Oracle PL/SQL for my day job from 2010, when I started working for a small consulting company that does work for the Union Pacific Railroad. The application I worked on uses quite a bit of Oracle PL/SQL partially because during the time of development (around 2000 to 2003), PL/SQL was the “new and hot”, and also Oracle itself was the mainstay in the enterprise application/database development platform too. Later on at Mastercard I learned the Master Reward System (or platform) used PL/SQL extensively too, as one of my colleagues put it, it’s really the heart of the system. This is also confirmed by one of the former developers’ LinkedIn profile (John McGuinness).
Lead developer and technical owner of back end of MasterCard Rewards Loyalty System.
Used C++, Korn Shell, PL/SQL, and Java in a Sun Solaris Environment.
Btw, once in 2005, I recall my “formerly IT/software engineer” mortgage broker and I had a quick talk after the closing of the house (condo to precise), and I recall he was doing VB (Visual Basic) before his mortgage career, and we tend to agree “software development using database as backend” is funner. Green is always greener at neighbor’s yard. I think it applies in the software development field as well 🙂
My own DB experiences – Working in progress as of 01-14-2024
Below are some of my observations on the relational DB in various production environments across multiple applications.
Unidev (contractor for Union Pacific Railroad): year 2010, when I 1st touched the DB, Oracle SQL and PL/SQL, C++.
Arch Coal (now Arch Resources): I used SQL server, it’s a small app in which I created both backend (C# .NET web services), and front end (iOS on iPad).
Btw, for own mobile apps, iOS apps, I used parse and google firebase (no longer active maintained).
Mercy: I used both Oracle and MySQL (we have different apps using different databases for backend).
Mastercard: Oracle (the main backbone for the MRS, see below), and Postgres (a small database for the Pay with Rewards app), this is the most substantial app I ever worked on – Mastercard reward system (MRS), Exadata: which is the high performance Oracle/Sun Sparc dedicate DB hardware. At MC I had opportunity to work on some performances issues on our SQL, both in the web application and the batch application, including promotion.
I also touched upon the Oracle Advanced Queues for the Pay with Rewards app I mentioned above. Overall I gained most of my DB exposure when I was working at MC. Before working at MC, I think I consider myself still a newbie on the DB (I was more confident on the java, and web apps dev side of things), after the MC gigs I was much more confident on both the DB as well as web admins (Site Reliability Engineering, using Google’s term).
A very subtle yet interesting observation: at MC they have teams such as software engineering (dev team), business operation (Technical/Production Support + Site Reliability Engineering), Database Engineering (DBA team) etc. At my current place we have dev team, Dev Tools team (somewhat like Dev Ops), dedicated Production Support team, and Data Management team (DBA team). Overall from my experience, only the MRS at MC has a dedicated application DBA. Most places don’t have a DBA with in-depth DB knowledge.
Enterprise Fleet Management (current employer): Oracle and Postgres (no production yet), some issues around DB (frequent locking, and concurrent DB connection exceeding alert limit, this happened at MRS too).
When the system hangs due to the exhaustion of database connections (basically DB server got overloaded), DBA’s usual workaround is killing the blocking session. In the extreme cases, they have to restart the DB server – but this could cause outage if there is no secondary DB server.
Application DBA is a DBA that has knowledge on the application database, in other words, he/she may be familiar with the data model in the database, and sometimes could provide valuable input to the performance and optimization of the database design, and database queries.
Outage
To avoid outage, we could have a primary and secondary database and database servers. Basically during normal operation, we use the primary DB server. Keep in mind the data is sync’ed (one way) from the primary to the secondary all the time (sometimes this is called data replication on Oracle). In the event, we need to take the primary DB server down, we can start up the secondary server 1st, switch the application DB connection to the secondary server, and this way we avoid an outage. When the primary DB server is available again, we can cut the application traffic back, keep in mind, when we switch back and forth, we need to make sure the data is kept up to date: for example, the case of switching back to the primary server, we need to replicate the data from secondary server to the primary server 1st. There are existing software solutions for that, e.g., Oracle GoldenGate is a popular choice for Oracle DB replication.
Web app <=> [ Primary server ] => secondary server
Some tips:
Always backup before deleting.
In addition to relational DBs, we need to be aware of object datastores (sometimes people called NoSQLs) such as MongoDB.
We can do Entity Relational (ER) model using MySQL Workbench for the WordPress MySQL DB – I think the Data Modeler role at MC (and other large organizations) may used similar tools to check the data modeling. It seems many small organizations don’t have this capability. The ER model is a very good way to introduce new developers to the system.
