How to copy-paste multiple variables between SSIS packages.
If you work with SSIS you probably hit this wall many, many times: there’s a package with zillion variables and you need to copy some / all of them to another package.
There is no copy-paste thingy in the UI for a variable so that’s a dead end. Czytaj dalej Copy variables between SSIS packages
About the Redis caching engine.
Remember my recent post on mysterious improvement?
(Yep, if you don’t read Polish you’re out of luck. Sorry. Should have warned ya.)
I usually don’t do technical WordPress advisory stuff here on my blog but this entry is an exception. Today we’ll see how to make our blog run rather than just walk. From a slightly different angle this time.
Let’s start from the most important question: is our blog too slow? Czytaj dalej How to speed up WordPress blog: REDIS
What happens when the same word means two different things in two languages.
I’ve been actively using this language for over 10 years now and still cannot refrain from laughing on the word „supersedes”
In my home tongue it means „a supertoilet”: „super” is a universal prefix that works more or less the same in most languages and „sedes” is simply a toilet (or, to be absolutely precise, it goes semantically somewhere between „toilet bowl” and „toilet seat”). Czytaj dalej Supersedes
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 10% tax charged unconditionally from all alumni for the first ten years after they graduate. This would – in theory – lead to situation where „better” schools would be feeding job market with „better” professionals which in turn would make them (again, just hypothetically) more money. Czytaj dalej Economical mumbo-jumbo
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 Next prime date
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, 1, 1, 2, 3, 5, 8, 13, 21, 34, … and so on, indefinitely. Czytaj dalej 0, 1, 8, 144 (EN)
A little bird told me that car insurance prices are going up again this year – both in Ireland and in other EU countries.
Czytaj dalej Reflected-sound-of-underground-spirits, again
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 Dates clusterfuck: MSSQL vs Excel
I faced an interesting 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 are sending 5GB of csv data in the CUSTOMER_2016.csv file. As soon as the transfer is done, we need to send an empty CUSTOMER_2016.csv.OK file. Czytaj dalej How to create an empty file in Windows cmd shell
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 is now available, please upgrade blahblahblah…”, I decided to give it a shot. Czytaj dalej Xenial Xerxus and WordPress – upgrading your VPS
I have recently faced a very annoying issue with one of the ETL processes. Very annoying issues are often easily resolvable in simple ways 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.
By writing this entry I am hoping to save you from wasting those precious minutes yourself. Czytaj dalej UTF != UTF
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?), you will be able to restore your inner peace very soon. Just keep reading. Czytaj dalej WordPress: conditional widgets