I want to share with you one of the useful oneliners I’m using to find recently updated files on our Linux machines. Let’s start simple: What do we have here?…
This is rather a specific situation, but I thought that it can be useful to share our expertise since someone else can have the same problem too. In one of…
After a recent update to the OpenVPN on one of our Ubuntu-based machines, we noticed that the VPN connection stopped working. In the OpenVPN logs on the server, I found…
Have you tried to restore the development database when suddenly such an error occurred? In the MS SQL Server with a connection to ColdFusion, this is a common problem. ColdFusion…
Some of the websites we are taking care of are old. By old, I mean the websites written over ten years ago. It is not easy to migrate them to…
We are using SOLR to search pages and documents on some of our client’s websites. SOLR contains the module that is crawling sites and places the website’s contents in the…
In my case, text processing is mostly reviewing logs and looking for things that are stored in them. Sometimes dig through the Git repository or trying to find a setting…
What do I calculate the hash of multiple columns for? I’m working with API that is limiting the number of calls per hour. I don’t want to send the same…
Are you familiar with Common Table Expressions (CTE)? Common Table Expressions are widely used to simplify queries, make them more readable and maintainable. For instance, when I want to check…
Keap (formerly Infusionsoft) offers a powerful Rest API. I’m working with it to keep one of our client’s Keap contacts in sync with the data stored in the web application…