DB Weekly
Issue 52 — March 20, 2015
Periscope
Tony Hoare invented the null reference in 1965 and he considers it a ‘billion-dollar mistake’ for the amount of trouble it has caused. Even today, SQL’s null value is the cause of several common mistakes.
Facebook
An open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
JP Toto
If you administer an SQL Server database but you’d like to expose all the data you’ve collected in more interesting, effective, and searchable ways, this is worth a read.
Rackspace
Sponsored
Normally, point releases in technology are not always newsworthy. For many legacy applications, the only glaring differences are subversive bug fixes and enhancements to keep up with competitive pressures. The Apache HadoopTM application is an exception because the technology is evolving so fast and in such high demand that each point release comes with notable improvements and several new tools that are actively changing the way users are running their queries, architecting their environments and developing their use cases. Learn More.
Databricks
Matt Kalan discovers Spark is easy to integrate with MongoDB for doing large scale analysis.
O'Reilly Radar
While you can exercise the features of a traditional database with a million rows, for Hadoop it’s not nearly enough. Think billions of rows instead.
Mode Analytics
Are you or someone you know looking to find a good resource for learning SQL? Here’s a great walkthrough of the basics.
Jobs
-
Database Administrator (Blacksburg, VA) Rackspace is seeking a Senior Database Administrator in our Blacksburg, VA office. The Senior DBA will be responsible for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation. Learn More.
Rackspace
In brief
-
Hello World, ZeroDB Here news
‘We’re building an end-to-end encrypted database that lets you run queries without exposing the decrypted data to the server.’
ZeroDB -
Announcing The RethinkDB 2.0 Release Candidate news
RethinkDB -
MongoDB 3.0.1 Released news
Fixes some issues from 3.0.0 and recommended to all 3.0 users.
mongodb-user -
Embedded Analytics Goes Mainstream news
Datanami -
MongoDB 3.1.0 (Developer Only Release) Released news
mongodb-dev -
Amazon RDS for PostgreSQL Adds Support for 9.4.1 news
Amazon -
MemSQL Brings Geospatial Analysis to In-Memory, Distributed Databases news
MarkedWired -
How to Backup your AWS Cloud-based PostgreSQL Database tutorial
N2W Software -
Visual Representations of SQL Joins tutorial
From 2009 but still good.
CodeProject -
Tinder is Scaling with MongoDB and Some Help from ObjectRocket
The New Stack -
Performance Testing MongoDB 3.0: Throughput Improvements Measured with YCSB
MongoDB -
Why I Choose PostgreSQL Over MySQL/MariaDB opinion
Dice News -
Dropping A Column in SQLite Is A Blood Bath opinion
Baudouin -
Generate Test Data Instantly with dbForge Data Generator for SQL Server tools
Devart