Month: October 2020
Multiple Fail2ban.sqlite3 Files Consuming Too Much Disk Space
I have recently upgraded my Digital Ocean droplet from 18.04 to 20.04 LTS. After the upgrade, I realized that droplet was consuming 80% of disk space. I have a basic droplet with 1GB RAM, 1 CPU, 25 GB hard disk to host multiple site and it is a good enough configuration for my need. But…
Drupal 7, 8: Your Server Does Not Support Installing Modules & Themes
On my Windows 10 machine, I installed Drupal 7 and 8 on IIS Server. When I wanted to install modules, it gave the following error. Error: Your server does not support installing modules and themes. This issue is related to permission only. Windows Configuration Windows 10 IIS Express PHP 7.1 (As FastCGI on IIS) Application…
Upgrade Ubuntu Server 18.04.x to 20.04.01 LTS On Digital Ocean
I was running Ubuntu Server 18.04 LTS version on Digital Ocean for hosting couple of Website. As Ubuntu 20.04.01 was recently released, I wanted to upgrade it so that I don’t have to worry about upgrading the server for next couple of years. I was using Ubuntu 18.04.x 64 bit that came built in with…
TSQL: Split String into Multiple Columns With Built-in Function
Let’s assume that you are working with SQL Server database and you need to build an ad-hoc report and split the string data into separate columns. Your data contains specific delimiter and you want to parse the data into respective columns. For example, your data column FullName contains “LastName, FirstName”, you would like to parse…
TSQL: Split Full Name into First Name and Last Name Columns
If you need to create an ad-hoc report and split full name into first name and last name, online search will suggest to create a custom user defined function. Sometimes, it is not possible to create an user defined function for single ad-hoc report because you need to follow change control process of your organization…