Keep it secure Until I used a password manager I struggling several times with passwords. Now I use on the PC ( and on my mobile 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"