sometimes during database migration, we need To know if our database have NVARCHAR Field , below SQL can check Oracle database if it have NVARCHAR field. select table_name,column_name,data_type from user_tab_columns where data_type like 'NVARCHAR%'; select…
In some VPS case , the disk space is very limited. while if you frequently upgrade Ubuntu , more and more disk space will be taken. To solve this, simply run below command will remove…
Since Wordpress is installed under /wordpress/ url. and root / URL do not have any important content. so we need redirect URL / to URL /wordpress/ hear is the Nginx code to redirect so at…
For a https site, certification is mandatory, So how to get those certification. In this example, we will use acme.sh to apply certification, So first install acme.sh curl https://get.acme.sh | sh -s email=example@yourmail.com request certification…