Passwords

Keep it secure Until I used a password manager I struggling several times with passwords. Now I use on the PC (https://keepass.info/) and on my mobile https://minikeepass.github.io/. The file I share on my home owncloud installation. With this in place, I can use generated strong passwords longer then 20 characters long. I have on demand […]

Read more "Passwords"

Pivot query update with Excel

Update of an Excel database query to update pivots A database query (e.g. ODBC database connection to a MySQL db) to update a pivot is a very powerful mechanismn. Usually to refresh the pivot the user has to trigger it manually. To refresh several files automatically I used the following scripts as a combination of […]

Read more "Pivot query update with Excel"