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

Czytaj dalej »

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.

Czytaj dalej »

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 …

Czytaj dalej »

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.

Czytaj dalej »

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 …

Czytaj dalej »