Achmad Hadi Kurnia achmadhadikurnia

## optimize_vhdx_file.bat
Optimize-VHD -Path c:\path\to\data.vhdx -Mode Full

## docker_create_mongo-express_container_with_network.bat
docker network create mongo
docker run --name mongo-express --network mongo -e ME_CONFIG_MONGODB_SERVER=mongo -p 8081:8081 mongo-express

## docker_create_nginx_container_with_volume.bat
docker run --name nginx -p 8080:80 -v nginx:/usr/share/nginx/html -d nginx

## docker_create_mariadb_5-5_container_with_volume.bat
docker run --name mariadb-5.5 -e MYSQL_ROOT_PASSWORD=password -e MYSQL_ALLOW_EMPTY_PASSWORD=true -p 33060:3306 -v mariadb-5.5:/var/lib/mysql -d mariadb:5.5.64

## .gitignore_global
# Node
npm-debug.log

# Mac
.DS_Store

# Windows
Thumbs.db
desktop.ini

## docker_create_mysql_container_with_volume.bat
docker run --name mysql -e MYSQL_ROOT_PASSWORD=password -e MYSQL_ALLOW_EMPTY_PASSWORD=true -p 3306:3306 -v mysql:/var/lib/mysql -d mysql

## query_to_string_replace.sql
UPDATE table
SET field = REPLACE(field, 'replace string', 'replace to')
WHERE field LIKE '%replace string%'

## docker_create_mongo_container_with_volume.bat
docker run --name mongo -p 27017:27017 -v mongo:/data/db -v mongoconfig:/data/configdb --network mongo -e MONGO_INITDB_ROOT_USERNAME=root -e MONGO_INITDB_ROOT_PASSWORD=password -d mongo

## query_to_delete_all_except_latest_x_records.sql
DELETE FROM table WHERE id NOT IN (
  SELECT id
  FROM (
    SELECT id
    FROM table
    ORDER BY id DESC
    LIMIT x
  ) temporary
);

## docker_create_redis_container_with_volume.bat
docker run --name redis -p 6379:6379 -v redis:/data -d redis
	docker network create mongo
	docker run --name mongo-express --network mongo -e ME_CONFIG_MONGODB_SERVER=mongo -p 8081:8081 mongo-express
	# Node
	npm-debug.log

	# Mac
	.DS_Store

	# Windows
	Thumbs.db
	desktop.ini
	UPDATE table
	SET field = REPLACE(field, 'replace string', 'replace to')
	WHERE field LIKE '%replace string%'
	DELETE FROM table WHERE id NOT IN (
	SELECT id
	FROM (
	SELECT id
	FROM table
	ORDER BY id DESC
	LIMIT x
	) temporary
	);