Kategoria: English

English is my second language. Not much here I’m afraid.

Economical mumbo-jumbo

Whilst browsing the Internet I recently ran into an interesting (and probably totally unreallistic) idea: universities should be free from charge for all students. Their (i.e. universities’) income should be funded exclusively off a tax charged unconditionally from all alumni for the first years after they graduate. This would – in theory – lead to…

Next prime date

Dates in Ireland are usually written as DD MMM YYYY i.e. 5 Sep 2016 or 12 Jan 2000 and so on. However, from database perspective (which is my personal favourite) I like storing date values as integers of YYYYMMDD i.e. 20160905 or 20000112 etc.

0, 1, 8, 144 (EN)

While surfing the Internet I recently found an interesting (although completely incomprehensible) proof of a conjecture stating that 0, 1, 8 and 144 are the only perfect squares in the famous Fibonacci sequence. For greenhorns: Fibonacci sequence starts with 0 followed by 1, then each subsequent terms is a sum of two preceding terms: 0,…

Dates clusterfuck: MSSQL vs Excel

Dates are usually the most error-prone element of various computer systems. There are so many different date formats, standards and representations. On top of this there are different calendars, too. Overall one could probably get a PhD on the topic without even scratching the surface of it.

How to create an empty file in Windows cmd shell

I faced an interesting[citation needed] task recently. For each file sent over via the ftp channel I was supposed to generate an empty *.OK file and send it over immediately after the main file transfer was completed. This allows the receiving party to process the file on their side with minimum delays. Let’s say we…

Xenial Xerxus and WordPress – upgrading your VPS

It is very important to keep your software updated. Forget to upgrade your apache to the latest version and you’re screwed. Forget to install recent security patches and you’re pwned. And so on. So, when I logged on to my VPS this morning and saw a big message saying that „…blahblahblah new version of Ubuntu…

UTF != UTF

I have recently faced a very annoying issue with one of the ETL processes. Very annoying issues are often easily resolvable in simple ways[citation needed] and thankfully this was one of them. However, before I managed to solve it, I wasted a whole bunch of otherwise perfectly usable minutes which is something I always loathe.…