Install OpenVPN on ec2
yum update -y amazon-linux-extras install epel yum install -y epel-release yum install
Backup multiple database
DECLARE @prefix VARCHAR(64) = 'Dev_LDS_Dev_LSS' DECLARE @path VARCHAR(256)
Recover a database
ALTER DATABASE [DBName] SET EMERGENCY; GO ALTER DATABASE [DBName] set single_user
Find table in databases
DECLARE @prefix VARCHAR(64) = 'Dev_LDS_Dev_LSS' DECLARE @dbname VARCHAR(256)
how to check table dependence sequence in ms sql
set nocount on drop table if exists #reduce; drop table if exists
Install Dgraph with docker
Official docker images Github open source code Install with docker-composite, docker-compose.yml
Install kafka cluster
The prerequisite: before you can install kafka you are required java jdk8+
Install zookeeper cluster with docker
Start docker on each node, change ZOO_MY_ID accordingly sudo docker