19 Resources for Learning About Database Design Errors — A look at numerous online resources for avoiding poor database design that can lead to many problems and cost both time and money.

Using AWS Aurora (Amazon's MySQL-Compatible Database) — Advait Shinde shows how his company uses Amazon Aurora to improve scalability by decreasing replica lag and bypassing limitations inherit in enterprise-grade relational databases like AWS RDS.

Analyzing A Million Songs on AWS Redshift — A look at extracting data from 1 million songs, uploading it to AWS Redshift via S3, and running some analysis via psql.

Unlimited Scalability Unprecedented Speed with the GridGain In-Memory Data Fabric — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture which can connect SQL, NoSQL, and Hadoop databases. GridGain is an enterprise-ready solution built on Apache Ignite™.

Postgres Query Plan Visualization — Understanding query plans and EXPLAIN output can be tricky, even for an experienced user. This is a great tool to help better understand how a query is operating.

KeRF: A Next-generation Time-Series and Tick Database — A columnar tick database and time-series language for Linux/OSX/BSD/iOS/Android. Natively speaks JSON and SQL. Ideal for trading platforms, low-latency networking, high-volume analysis of realtime and historical data, etc.

Binomial Options Pricing in SQL — How to set up a discrete binomial tree using the binomial options pricing model to value derivatives in SQL, and apply this in an example of pricing a 3-period call option.

Gartner Sees Analytics Boom as More Data is Shared — “forecasts greater uptake of emerging analytics technologies like semantic and graph analyses, simulation, complex event processing and neural networks”