DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 81 — November 27, 2015
Featured
50 Shades of NULL — Subtitled “How a Billion Dollar Mistake has Been Stalking a Whole Industry for Decades”, this is a look at the history of nil/null values and how NULL works in SQL.
Lukas Eder
What NoSQL Solution Should You Choose? — Quick summaries of MongoDB, Elasticsearch, OrientDB, Hadoop, and Cassandra, focusing on what each can and can’t do.
Kuzzle    opinion   
Heroic: A Time Series Database from Spotify — Heroic is an open-source monitoring system originally built at Spotify to address the problems being faced with large scale gathering and near real-time analysis of metrics.
Spotify    code   
Have you got SQL fingers? — Watch these free SQL Prompt tips videos for SQL writing hints from top SQL Server MVPs. SQL Prompt is the SQL code productivity add-in for SQL Server Management Studio and Visual Studio. Find out how easily you can write SQL.
Red Gate Software    sponsored   
Organize Complex Queries Using SQL's 'WITH' — SQL:1999 introduced the ‘WITH’ clause to define “views” within queries. These with-queries are only visible in a single statement and can be used to improve the structure of this statement without polluting the global namespace.
Markus Winand
Apache Geode: A Distributed, In-Memory Low Latency Database — The Apache-incubated open source version of a commercial in-memory database called GemFire.
Apache
HyperLogLog in Pure SQL — Hyperloglog is a very interesting algorithm and you can have an extremely efficient version directly in Postgres. And if you’re not up for building and pulling in your own extensions here’s a raw SQL implementation of it.
Periscope
10 Use Cases Where NoSQL Will Outperform SQL — Written by a director at Couchbase.
Network World    opinion   
Jobs
Freelance with Companies like Airbnb, IDEO, & JPMorgan — Work with top clients, set your own rates, and work from anywhere as an elite Toptal developer. Join the most exclusive network of top software engineers in the world.
Toptal
In brief
4 Upcoming Database Conferences: Winter 2015-2016
Leandro Toniut    news   
What End of Support for SQL Server 2005 Means for CIOs
CIO    news   
Recent Improvements to Redis Lua Scripting
Salvatore Sanfilippo    news   
Redis Performance Dashboard and Autoscaling from RedisGreen — Seamless scaling and analytics backed by support from engineers who have been scaling Redis for years.
RedisGreen    tools    sponsored   
Adding Summary Statistics to your SQL Table
Periscope    tutorial   
Understanding ElasticSearch Performance
Josh Rendek    tutorial   
A MySQL Data Analysis Example In 3 Easy Steps
Agata Kwapien    tutorial   
Bulk Transformations of Couchbase Data Using Apache Spark with an External Source
Matt Ingenthron    tutorial   
How to Monitor Neo4j-Based Application Performance with Ruxit
Wolfgang Beer    tutorial   
Generated Primary and Foreign Keys for Distributed Databases
Dick Dowdell    tutorial   
pg_paxos: High Availability Data Replication for PostgreSQL
Citus Data    tools   
The Ultimate list of Top SQL Monitoring Tools
Cloudmonix    tools   
Choosing a Database for Analytics
Segment    opinion   
How to Achieve Outstanding Performance with MongoDB Monitoring
Martin Goodwell    opinion   
« Prev
Next »