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 – …

Read More »

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.

Read More »

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 …

Read More »

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.

Read More »

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 …

Read More »

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 …

Read More »

WordPress: conditional widgets

Have you ever pondered over how to make a WordPress widget (in)visible only on certain pages, or categories, or just on the home page etc? If you haven’t then don’t. It is pretty much boring. However, if you are losing your sleep over widgets conditionality (is this even a word?), …

Read More »

Sh*t happens

  As Confucius used to say, shit happens. He was a smart lad so there is no point not to believe him. Shit that happens to happen is usually a bad shit. More or less. Ocasionally you discover that some of the bad shit happens only to unravel a surprisingly …

Read More »

apt

I’m not a fan of any particular OS. Horses for courses. Certain operating systems are tailored for certain tasks, period. For the end user, Windows seems to be the optimal choice. I know. It’s sometimes clunky, a bit unstable and so on. It is certainly not the best possible OS …

Read More »