Ubiq BI

How to Get Current Date and Time in MySQL

Sometimes you may need to get date from datetime, or get current datetime. Here is how to get current date and time in MySQL.

Sometimes you may need to restrict access to URL, file or directory. Here is how to deny access to URL, Files & Directory in Apache.

Learn how to limit access to directory and subdirectory in NGINX using deny and allow access control directives.

Sometimes you may need to convert lowercase to uppercase or uppercase to lowercase. Here is how to convert case of string in PostgreSQL

Sometimes you may need to limit access to URL. Here is how to restrict access to URL in NGINX.

SQL Reporting and Dashboard Tools allow you to visualize SQL query results in charts & dashboards, and share them with others.

You can configure server side includes to add dynamic web content. Here is how to enable server side includes in Apache.

You can easily concatenate columns & strings in PostgreSQL. Here is how to concatenate strings in PostgreSQL.

NGINX log rotation allows you to rotate logs without piling up. Here is how to configure NGINX log rotation.