Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…
- MySQL: size of your tables – tricks and tips
- Using a trigger to parse non-conforming data in MySQL
- On Rocks and Sand
- Securing PostgreSQL as an Enterprise-Grade Environment
- How to Reduce Syntactic Overhead Using the SQL WINDOW Clause
- Backing up Percona Server for MySQL with keyring_vault plugin enabled
- MySQL and Memory: a love story (part 1)
- Why Optimization derived_merge can Break Your Queries
- Tracking High Availability for PostgreSQL with Heartbeat
- Using the keyring_vault Plugin with Percona Server for MySQL 5.7
- Minimize MySQL Deadlocks with 3 Steps
- PostgreSQL Backup Strategy for an Enterprise-Grade Environment