Installing MS-SQL on CentOS 7

This setup is using an instance within Google Cloud Platform's Compute Engine, but it should work about anywhere running CentOS 7+. I added this here because I needed to try mssql on Centos, an unsupported distro. Other howto's online I found did not work, or did not completely set it…

Dump a mysql table without locking

If you want to keep your site/application live, you can dump mysql tables online like so: mysqldump --single-transaction --quick -hhostname -uuser -ppassword database > /path/to/destination-sqlbackup.sql --compress = as it says, enabled compression on the connection to the mysql server. This will always speed up bulk loads 10x…