Issue 102 — April 28, 2016
Featured
10 SQL Tricks That You Didn’t Think Were Possible — A fun, and very extensive, walkthrough of the possibilities and properties of SQL you may have overlooked.
Lukas Eder opinion
What I Learned From Programming Databases — "Programming a database is possibly the most instructive project one can ever complete as a software developer."
Philip O'Toole story
Neo4j Pushes Graph DB Limits Past a Quadrillion Nodes — "There is effectively no limit to the sizes of graphs that people can run with Neo4j 3.0," said Philip Rathle of Neo.
Datanami tools
Open Source Rising: Rapidly Building Adoption with Postgres on IBM POWER8, Red Hat — Learn more about RapidBuild program that supports the adoption of Postgres with a tuned, configured, price-performance solution developed by trusted ecosystem partners IBM, Red Hat, EDB, and reseller Avnet.
EnterpriseDB sponsored
Managing the New York Stock Exchange with SQL Server — An interview with Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange.
SQL Server Radio
Power Tools: Sorting Through The Crowded Specialized Database Toolbox — With so many choices today, matching the right database to the requirements isn’t getting any easier.
Ars Technica opinion
Training Firm's Unexpected Growth Exposes Weakness of Relational Tech — The tale of how one company ran into problems as they rapidly scaled.
Datanami story
Inside Capacitor, BigQuery’s Next-Gen Columnar Storage Format — BigQuery / Dremel engineer Mosha Pasumansky deep dives into BigQuery storage. He discusses how the new Capacitor storage engine improves efficiency.
Google tutorial
Jobs
The Easiest Way to Find a Job — Hired lets you sit back while job offers come to you. When you complete your profile, instantly apply to 3,500+ companies on the platform who will contact you with job offers, including salary and equity up-front. Try it today.
Hired.com
In brief
Microsoft news
Philip Rathle news
Alexey Kovyazin tutorial
Tyler Langlois tutorial
Emil Drkušić tutorial
OK I GIVE UP tutorial
A 2 Minute Intro to the MySQL Document Store — MySQL Document Store lets you work with relational tables and schema-less JSON collections in parallel.
YouTube video
Axel Morgner opinion
Have you got SQL fingers? — Try SQL Prompt and you’ll be able to write, refactor, and reformat SQL effortlessly in SSMS and Visual Studio. Find out more.
sqlprompt tools sponsored
ThingieQuery: An SQL Plugin/IDE for Excel — An Excel plugin that lets you do things using SQL on Excel spreadsheets.
ThingieQuery tools
JetBrains tools
Apache Foundation tools
NoDb: Simple File System Storage for .NET Core — Because "not all projects need a database".
Joe Audette tools
One Call to Rule Them All — DreamFactory's autogenerated REST APIs work across multiple databases on a multitude of servers. Free, open source platform.
DreamFactory tools sponsored
Markus Siemens code
SQLite code
SQL to NoSQL: Top 6 Questions Before Making The Move — What to consider when moving from the world of relational databases to a NoSQL document store.
Glynn Bird
Joshua Blender story