Data, Process, Insights & things I write about
Some time ago I needed a way to control how long a database query would (at least) take. The purpose for this was to test out timeout behaviour of components that trigger and wait for the query result. While the… Read More » Advanced Database magic with Tableau
One of the aspects of home computers like the C64 or the Amiga 500 that made them so interesting to me - well behind gaming of course - was that those machines were something one could know well. It was possible to know… Read More » Three small wins
The data visualisation tools Tableau Server and Tableau Cloud are well known - in the circles that use such tools - for the broad range of ways data can be made into a picture. Dashboards can be built from many… Read More » Tableau Loops
Tableau Server, for those not familiar with it, is a system for creating, managing, and sharing visual analytics and all the things that go into it. While users can create data sources and visualisation workbooks, just… Read More » PostgreSQL DB restore lite
Tying off loose ends can be very satisfying. When the detective eventually reveals the crucial connection between facts that have been out in the open the whole time and is finally able to name the killer: amazing.… Read More » Tying off a loose end in TRON
Working in professional and corporate IT means there is a lot of planning, testing, and review happening. Costs are to be predicted, risks to be identified and evaluated, and project plans need to be laid out ahead of… Read More » Moving Backups from AWS S3 to Backblaze
Something (hopefully useful) for the all the Tableau repository warriors: Table schedules holds, as the name implies, the definition of schedules in Tableau Server. Unfortunately for the SQL user, the information about… Read More » Tableau repository schedules decoded
Apart from writing blog posts I have written answers to many questions on several Q&A sites like StackOverflow and SAP Community. Some of those answers received good feedback and/or the answer surprised me once I worked… Read More » Answers Pinboard
Recently we got a new Macbook in our household, seeing that the previous one was from 2013 and would not allow new versions of macOS to be installed. Part of setting up the new laptop is to move all data from the old one… Read More » Using a Mac still comes with some pleasant surprises
When reading Some opinionated thoughts on SQL databases recently, I felt reminded of an observation that I have made in the past: the way SQL is commonly used and presented is way too low-level. Read More » Write better SQL!