Wildcard Let’s Encrypt with Certbot Apache Ubuntu

Wildcard Let’s Encrypt with Certbot Apache Ubuntu

Google started a campaign to make the web a safer place. So they decided to mark all websites using plain old http as “not secure”. Only websites that were using https we marked as “safe” to use. Nobody wants to see their website marked as “not secure” because they didn’t use https. In order to remove the warning message, the website needs a SSL certification. But that costs money. Fortunately, there is a free way to SSL your website. Let’s…

Read More Read More

Create Employee Work Shift Schedule using PIVOTS

Create Employee Work Shift Schedule using PIVOTS

Once in awhile, it is required of you to create visualizations of the data you have in the database. For example, you have a set of data of employees and when they start their shift and when it ends. But you would like to create a chart for the day to see which employees work together. Fortunately, creating this chart is easy in SQL Server using Common Table Expressions (CTE) and Pivot. The sample data we will use is the…

Read More Read More

How to add Google Maps Autocomplete to a search box

How to add Google Maps Autocomplete to a search box

Most of the time when creating a registration form, you will ask the user to type in the city they live in. And you want to make the user’s life easier by auto completing the city name as they type. Ever wondered how to add Google Maps autocomplete for a textbox? Using a free service from google, you can easily add the autocomplete to any textbox. The sample below demonstrates how it’s done and the highlighted rows are the important…

Read More Read More

%d bloggers like this: