Why SQL Is Simply Awesome —
Lukas Eder, founder of Data Geekery, waxes lyrical on SQL and dispels some commonly repeated fallacies while looking at its strengths.
How Airbnb Partitioned Its Main Database in Two Weeks —
A walk through how Airbnb used MySQL’s replication on Amazon RDS to partition the database with only brief downtime and without writing any bookkeeping or migration code.
AWS Database Migration Service —
Amazon has unveiled a preview of a new AWS service to help you migrate databases to AWS without any downtime. It supports all widely used databases.
How to Make a Box-and-Whisker Plot in SQL —
Understanding how your data is distributed is critical for any analysis. Box-and-whisker plots are great for summarizing distributions and comparing distributions across datasets. Here’s how to create them in SQL.