DB Weekly
Issue 59 — May 22, 2015
MemSQL
MemSQL is a real-time database for transactions and analytics and it’s now open to everyone in the form of a free ‘community edition’ release.
The Daily WTF
A 4986 character SQL query with surprisingly little duplication. If you fancy trying to work out what a query is doing in your lunch hour, start here.
Microsoft
NoSQL continues to have an impact outside of its niche with Microsoft rolling JSON support into SQL Server. Jovan Popovic shows off how it’ll work.
Rackspace
Watch as Tinder CTO, Ryan Ogle, as he gives you an inside look into their IT strategy and the real-world solutions that are helping them scale their business, manage big data, and navigate digital trends. View Now.
Raymond Li
Covers C4.5, k-means, SVM, PageRank, Bayes and others. If you want simple, straightforward explanations, check it out.
Yahoo Inc.
MySQL Performance Analyzer is an open source, Java-based project for MySQL performance monitoring and analysis.
Peter Geoghegan
Why is Postgres pursuing a non-standard variant of UPSERT rather than SQL’s MERGE? A developer explains why: they’re quite different things.
Hacker News
Some discussion around the implications of a recent tweet by Gary Bernhardt leaning on the idea that servers with 6TB of memory can help alleviate ‘big data problems’.
Jobs
-
Senior Database Administrator (Austin, TX) ObjectRocket by Rackspace is seeking a Mid-to-Senior level DBA to join our Engineering team to work on our scalable, highly-available DBaaS platform. Anyone can manage a single application - we manage and maintain thousands of production databases supporting billions of operations. You’ll be part of a highly capable and motivated team working on solving the hard problems of scalability, availability, and performance on a global platform. Apply here.
Rackspace
In brief
-
In-Database R coming to SQL Server 2016 news
"With this update, data scientists will no longer need to extract data from SQL server via ODBC to analyze it with R. Instead, you will be able to take your R code to the data."
Revolution Analytics -
A Lockbox in The Cloud: Microsoft Research Project Reveals New Method for Keeping Data Private news
Next at Microsoft -
Workload Analysis with MySQL's Performance Schema tutorial
GitHub Engineering -
Getting the First Row per Group 5X Faster (with SQL) tutorial
Periscope -
Think Twice, Join Once: Distinct On in PostgreSQL tutorial
Noel Herrick -
Using MySQL's Experimental HTTP API with Ruby tutorial
Ilya Bylich -
Why The Hate for MS Access? opinion
Reddit -
Faster Responses: Data and Query Caching using Redis opinion
Shivang Doshi -
Why Auto Increment Is A Terrible Idea opinion
Clément Delafargue