I bought a new Seagate Exos 18T disk from Amazon, which came in a plain envelop without filling. I spotted dents on the outside disk (no surprise given no protection for this heavy metal piece during such a long journey
Back up data
I have a Synology NAS and disks are redundancy protected to telerate one disk loss and because I had backups of my VM on my NAS, I should be able to re-create such a VM quickly when I lost it,
Be aware of Rentalcars.com
I recently had to cancle a booking with rentalcars.com and found I’d be charged for “deposit” which is about 10% of the overall amount. I don’t see any logic why I could not get full refund as their website stated
Google Domains vs Crazydomains
My domain needed renewal so I started to shop around. Crazydomains offers cheap first-year registration but not on renewals. Also another important factor was TXT records for emails(offered at extra cost by Crazydomains). At the end it turned out Google’s
Remote desktop to Ubuntu from Windows
I configured a new Ubuntu(20.04) desktop and wanted to be able to log into it remotely. Tried many times with xrdp but kept on getting “authentication is required to create a color profile“, “authentication is required to refresh the system
Postgresql identity column “no owned sequence”
Postgresql 10 introduced identity column which offers better manageability than the old fashioned serial. Refer to this post for more detail I followed the post above and converted most of serial columns into identity, worked all good until one day
PostgreSQL logical replication
Logical replication was introduced in PostgreSQL 10. It offers better flexibility than stream replication in a number of ways: Publisher and subscriber can be on different major versions Replication can be done at table level, sharing a subset of the
Use Cloud function to start and stop Cloud sql
We have setup a Cloud sql database for development but would like to save cost by shutting it down during night. This article shows how to achieve this. The overall architecture is Cloud function is used to hold Python code
Bigquery parallel loading
There are many ways to load data into BQ but using Python gives us the most control. Below I’m going to demonstrate loading files into BQ in parallel. My test scenario is: 191 csv files, sizing from 10Mb – 1Gb
Dates in SAP
My first post on SAP based on my working knowledge. I’m not a SAP support or developer so there are still lots of unknown to me There are so many dates in SAP: Baseline date, net due date, invoice date,