Issue 107 — June 2, 2016
Featured
SQL Server 2016 Now Generally Available — Includes updateable, in-memory columnstores, R integration, and improved cross-platform analytics (such as with PolyBase).
Microsoft tools
Comparing CHAR and VARCHAR Types in Different DB Engines — Database storage engines frequently spring up surprises - this roundup looks at the various ways MySQL, SQLite, Postgres, Oracle and SQL Server deal with CHAR and VARCHAR types.
Vertabelo tutorial
See inside your Redis database. New memory mapping from RedisGreen — RedisGreen builds a map of your Redis memory usage, tracking the size of keys over time, helping you track down problems and gain new insights.
RedisGreen sponsored
BigBash: Convert SQL SELECTs to Bash One-Liners — Converts select statements to Bash one-liners that are executable directly on CSV, log files & similar files.
Zalando SE tools
Looking Inside The MySQL 5.7 Document Store — A quick demonstration of how MySQL’s new document storage feature works.
Alexander Rubin tutorial
Extending The Redis Database — A 10 minute discussion with Redis creator Salvatore Sanfilippo about Redis’ new module system.
Rachel Roumeliotis
Monitoring Cassandra at Scale — Yelp uses Cassandra heavily and while it’s built to deal with failure, robust monitoring is essential at their scale.
Joseph Lynch tutorial
Jobs
Work on a Better Stack — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 3,500+ companies instantly.
Hired.com
In brief
On-demand Webinar: Turbocharge Your SQL Queries In-Memory with Apache® IgniteTM — Learn how to boost performance 1,000X and scale to over 1 billion transactions per second with your SQL-based applications.
GridGain In-Memory Data Fabric sponsored
Ben Darnell tutorial
Noam Hasson tutorial
Nicolás Bevacqua tutorial
Igor Bobriakov tutorial
David Fitzjarrell tutorial
Upstats tutorial
Datanami opinion
One Call to Rule Them All — Access SQL and NoSQL databases across multiple servers with a singular REST API. Free, open source platform.
DreamFactory tools sponsored
Garry Lachman code
Guardian Project code
The Netflix Tech Blog story