Posts

These are my latest posts.

• Fix java version for Flutter

  2022-02-06

  I had some issues with building Android applications in Flutter. With the following as error message:

• Installing pyodbc with Microsoft SQL Server driver on a M1 Mac

  2022-02-05

  The following is a breif scratchpad on the steps taken to install and get pyodbc to work with a Microsoft SQL Server connection on a M1 Mac.

• Benchmarks of running Wireguard on an Ubiquti Dream Machine (UDM)

  2021-10-02

  Install instructions and benchmarks of running Wireguara on an Ubiquti Dream Machine.

• Accessing an Azure Keyvault from an Azure Function

  2021-09-16

  The following describes how an Azure Function written in Python3 can access secrets stored in an Azure Keyvault using ManagedIdentityCredential.

• Writing a file from Azure Blob to Google Analytics 360 with file upload

  2021-09-16

  The following describes how an Azure Function written in Python3 can read a file from Azure Blob Storage and upload it Google Analytics 360 for be used as a custom data source. The function uses the uploadData API described in Google Analytics Management API.

• Detetcting outliers in SQL Server

  2021-07-08

  The following is a short note on how to detect outliers in SQL Server.

• Organizing photos with Elodie

  2021-05-09

  We have a quite large photo archive, but the biggest problem is that it is totally unorganized. A few days ago I found the organizer Elodie, a simple python script that reads exif data from photos and organizes them into folder based on date and geo-location. Elodie also computes SHA256 sums of all photos to make sure that no duplicates exists.

• Building a DNS watchdog for Merlin ASUS WRT

  2021-05-04

  I’m running Adguard on my Supervised HomeAssistant install. And as this is working great there are the occasional dropouts when my Synology NAS (that is running HomeAssistant) are having problems. This is a short writeup on the requirements and how the script is implemented. Everything is based on the scriping functionality in Asuswrt-Merlin which is the Firmware I’m running on my RT-AC68U.

• Migrate from one 512 GB SSD disk to a 1TB SSD disk on Synology DSM with no free disk slots

  2021-04-28

  My “old” (Fri Oct 26 15:45:49 2018) 512 GB SSD disk have been alarming that it is running end of life so a new 1TB SSD disk will replace it. This is my own notes on what I did.

• Extracting data from Google Analytics 360 as an Azure Data Factory job

  2020-11-01

  Sometimes a it is not possible to query Google Big Query to extract Google Analytics 360 data. There exists an API to access GA data but it is quite undocumented.

• Useful shell commands on my Synology NAS

  2018-03-28

  I’m gathering some useful commands that I’m using over SSH on my Synology NAS. Most are just for myself to remember what I’ve done but others might find them useful too.

• Let's encrypt for Apache vhost running on FreeBSD.

  2018-03-15

  The following is a quick scratch down of how I have configured Let’s encrypt on one of the FreeBSD jails I’m hosting (running Apache24).

• Script to extract movies from an img file.

  2014-02-11

  The following scipt can be used to extract movies from an img file. The minlength=600 reflects that the movie must be 600 seconds to be included.

• Encrypt a sparsbundle file in os X

  2012-08-01

  The following command can be used to encrypt a sparsebundle in OS X.

• Remux and transcode mkv movies.

  2011-11-03

  Various codes to modify mkv movies.