SQL server

Select query for production (nolock) Table lock simulation Backup Command line database backup using SqlCmd tool (localhost database) Restore Command line database restore using SqlCmd tool (localhost database) Link tablespace to filegroup Get active connection Try catch block Ram by Read more…

Postgres

Clone a database with an existing local one Connect to the database with a user with proper right and make sure that the sourcedb does not have opened connection. Database dump Database restore Get table fields Try catch block

Certbot – SSL certificates

Certbot it’s an cool tool that automatically enable HTTPS on your website deploying Let’s Encrypt certificates. How to Centos not snap – not anymore supported Snap install See the official guide https://certbot.eff.org/lets-encrypt/centosrhel7-apache To create the certificates Your certificates are deployed Read more…

Backup folders

Rsync, which stands for “remote sync”, is a remote and local file synchronization tool. It uses an algorithm that minimizes the amount of data copied by only moving the portions of files that have changed. Here an example