Skip to main content

Posts

Showing posts from October, 2017

How to compare multiple files?

The context For a project, we had to create over 100 virtual machines (VM), each one with specific caracteristics: OS, # CPU, RAM, # disks, disk space... About 1/3 VM are Windows, 2/3 Linux. I maintain a MS Access Database with the requested VM. The project is near ending; for quality control, I need to validate what is delivered vs. what was requested. My sysadmins went on almost(*) all the VM to get the caracteristics; the result is 2 text files, one for Windows and one for Linux. *: This is important. I don't have all the VM yet, hence I will have to do this process again; this have to be taken into account in my solution. How to compare the data? Method 1: by hand Boring, tedious and highly error prone. Forgotten. Method 2: using Excel I tried that first. But I'm not a king on Excel, and because the caracteristics are quite different between Linux and Windows, is't hard to make comparisons. Abandoned. Method 3: using Access This is actuall...

MS Access: embedded INNER JOIN

How to embed INNER JOIN in MS Access SELECT ... FROM ( ( T1  INNER JOIN  T2 ON ... )        INNER JOIN  T3 ON ... )      INNER JOIN T4  ON ...;

Roland TR77

A new rhythm box in my studio: Roland TR77. Released in 1972 but sold alonside the 70's , mine was built in November 1976. Many latin rhythms: Chacha, Beguine, Mambo, Samba,  Rumba, Bossa Nova, ... Very good sound, a lot of modulation. A very interesting instrument. The Mambo could be heard, among many Polymoog filter sweeps, in one of my favorite song: "Song For Guy" by Elton John.