A common task when either reporting or doing data analysis is to extract data from a database table or view and then lookup corresponding values from either previous or next rows. A good example of this was a recent KPI report I made for E-commerce where the KPI depended not only on the total daily …
Author archives: Bob Peers
The Right Tool for the Job
During my career I’ve heard this countless times and to some extent it’s just taken as granted that you should always use the right tool for the job. Isn’t this obvious after all? Why would you knowingly choose the wrong tool? But the conversations often miss the realities surrounding the choice. Decisions are not made …
WordPress File Size Limits on Nginx
So my WordPress is up an running and inevitably I hit a few roadblocks on the way. While trying to upload a video I encounter the classic ‘HTTP error’ that seems to be almost always due to file size limits on the server. In my case the fix was simple but requires changing both setting …
Sixteen Years of Learning
One of the greatest things about the internet is that nothing is forgotten. Of course this has also turned into one of it’s greatest risks with the rise of social media. I used to run my own website starting in 2003 until around 2013, when I removed the site. It was written by myself in …
Hello world!
This image sums up how things are going to be around here. It won’t be narrowly focused, maybe not even focused at all. More of an experiment in ‘Doing fun things with technology’™. The main purpose of this site is to have a place to store my own content. Sounds really retro, blogs are so …