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…
Software Developer Career Day Presentation for Elementary School
Last year I participated in a Career Day at school to show what Software Developer is and what they do. I created PowerPoint to make it interesting for the 1st grade kids. Presentation ended with an interactive programming session in which kids programmed a dumb robot i.e. me to complete a task of throwing a…
Webmin: 1 Package Available But Nothing to Update
I am using Webmin to host multiple Websites. As a best practice, I am updating the packages whenever any update is available and reported on Webmin Admin Panel. From past couple of days, Webmin reported 1 package is available for update but when I click on the link, it showed “No packages available to be…
WordPress Multisite – Error Establishing a Database Connection
When you are moving a WordPress multisite website to a different url, you may get the error “Error establishing a database connection”. Based on the error description, you will likely try to verify database connection, username and password but still you are facing the error. In fact, this error is not related to database connection…
How to Add and Use New JSDoc Tag Using Plugin?
I am working with JSDoc 3.6.4 to document JavaScript library. I want to mark certain functions available for Pro version so I want to add a new JSDoc tag “@pro” to indicate that certain features available in Pro version. How to Create a New JSDoc Tag? If we want to have a new tag supported,…
Host ASP.NET Core 3 with Apache Using Webmin
If you are using Webmin to administer your Linux box, here are the steps to run ASP.NET Core application with Apache. Prerequisites Ubuntu 18.04 / 20.04 Webmin I assume that you have setup your server, Webmin and everything is up and running. Install .Net Core Here is a compilation of commands to install the .Net…
How to Install Webmin to Host Multiple Websites
I have multiple Websites and recently started using Digital Ocean to host multiple Websites. I have created Ubuntu 18.04 / 20.04 64 bit droplet to use following software. Update on 5 Feb, 2021: This tutorial works for Ubuntu 18.04 and Ubuntu 20.04. Web Server (Apache or Nginx) Database Server (MySQL) Email (Dovecot, Postfix) Webmail Client…