Just another tech blog

06
Jan
2019

Securing Apache HTTP servers on Linux

In this post, we are going to increase the security of the server by reducing the information shared by the server to the client. By itself it is not an active protection such as a firewall or any kind of instruction prevention system. Although Apache does offers various modules such as the mod_security and mod_evasive. But we won’t focus on that part in this post. Well, when talking about security, there are tons of other mechanism to be installed and considered anyway. #1 Disable server banners When you tell the exact version number of your server software, a...

04
Jan
2019

Excel Summieren in einem bestimmten Zeitrahmen (in German)

Heute geht es um die Frage, wie man in einem ExcelSheet Daten wie beispielsweise eine Zahlung über einen bestimmten Zeitrahmen summieren kann. Im nachfolgenden Beispiel, habe ich eine fiktive Zahlungstabelle erstellt und wir möchten für den März erfahren wie hoch die Ausgaben bzw. Einnahmen waren. Wie ihr in dem Screenshot sehen könnt, bietet Excel hierfür die Funktion SUMIFS an Ihr könnt es natürlich auch ohne eine Tabelle machen. Dann würde in dem Beispiel die Formel heißen Mit dem ersten Argument Table10[Zahlung] bzw. C2:C44 sagt ihr Excel, dass es über die Spalte summieren soll. Über die letzten 4 Argumente...

Featured

03
Jan
2019

Securing HTTP header for Apache HTTP servers on Linux

In this post, I am going to show you, how to increase the security of your webpage for your visitors. We will configure Apache to add more information in the HTTP header, which helps the browser to identify and block potential attacks. But please keep in mind, that we just provide information such as which types of resource do we use (e.g. JavaScripts, CSSs, Fonts, and so on.) and where to get them (locations) but in the end, the browser decide whether it respects these information or just ignoring them. Commonly, the major browsers such as Chrome, Mozilla...

30
Dec
2018

Tips for landing a new job

I guess most of us went down that road at some point and understand, that beside the diplomatic and official answer, there are plenty of reasons for leaving the current company, e.g., expectations were not met, promises were broken, no further growth for your career, supervisors, and and and ;). But this post ain’t about why I left my company or why you should leave yours. It is about how I managed to get my new job and the experience I made during that period. #1 Keep going until the end If you – for whatever reason –...

12
Dec
2018

Are stored procedures faster than queries?

In some companies including leading ones stored procedures are labeled as bad practice and banned forever, in others they are praised for better performance. Let’s take a closer look into it. Caching the execution plan Let’s start from the performance perspective. Whenever you submit a query to the database system, it will need to create a query execution plan. This is an ordered set of step, which tells the database how to get your data. Every query requires a query plan before it is actually executed. Since there are different way how to get there, the DB will...

09
Nov
2018

ERR_TOO_MANY_REDIRECTS by WordPress on LAMP stack with nginx/HTTPS as reverse proxy

I wanted to setup my new WordPress blog on my (new) server running on Ubuntu to have nginx/HTTPS as the reverse proxy for my Apache HTTP Webserver (LAMP stack). Although they are great materials, following the 2 tutorials of DigitalOcean gave me a hard time due to the ERR_TOO_MANY_REDIRECTS caused by WordPress: How to install WordPress with LAMP on Ubuntu Configure nginx as webserver and reverse proxy for Apache Reason for ERR_TOO_MANY_REDIRECTS Please be aware, that the ERR_TOO_MANY_REDIRECTS can have different (and !multiple!) causes. Although most of the blog articles and forum discussions, that I read during my research of...