DB Weekly
Issue 61 — June 5, 2015
Periscope
A mixture of stylistic and practical tips for building an easy to understand and maintain schema for your SQL database.
Couchbase
Includes numerous new features, the new N1QL (SQL for JSON) query language, multi dimensional scaling, global secondary indexes, a new storage engine, and more.
Redmond Magazine
Includes Query Store, Polybase, Stretch Database, JSON support, row-level security, encryption, and in-memory enhancements.
ObjectRocket
Sponsored
Redis Sentinel provides a simple and automatic high availability (HA) solution for Redis. If you’re familiar with how MongoDB elections work, this isn’t too far off. Learn more about Redis Sentinel.
Couchbase
N1QL is an SQL-like language introduced in the new Couchbase Server 4.0 (above) that brings SQL, NoSQL and JSON together.
Xuefeng Zhu
SheetSQL builds a SQL engine into Google sheet by storing and retrieving data directly in Google Sheet.
Datanami
Graph databases are increasingly seen as a way to "connect the dots" as enterprise applications emerge requiring the linking of huge datasets.
Bruce Momjian
This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads.
Hacker News
It’s not easy, but some people fight MySQL’s corner pretty well.
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
-
NoSQL Champ MongoDB Plugs Into SQL Analytics Power news
"MongoDB is tapping the power of business intelligence and data visualisation, working on a connector for SQL-compliant data analysis tools."
The Register -
Forecast Pegs Data Market at 115ドルB by 2019 news
Datanami -
Spark Gets New Machine Learning Framework: KeystoneML news
KeystoneML is designed to be a faster and more sophisticated alternative to SparkML.
Datanami -
Oracle, MySQL, Cassandra and MongoDB Among Developers to Benefit from Couchbase's N1QL news
"N1QL brings the power of SQL to the document data model, which removes one of the biggest barriers to broader enterprise adoption of NoSQL."
Couchbase -
Survey Casts Doubt on Big Data, Hadoop Efforts news
Datanami -
SQL Server 2016: In-Memory Columnstore Indexes news
InfoQ -
The #1 Enemy of Data Loading in SQL Server tutorial
Matan Yungman -
How Okta Chased Down Severe System CPU Contention in MySQL
A look at how the kernel mutex was slowing down a MySQL install.
Okta Developer -
PostgreSQL: The Good, The Bad, and The Ugly opinion
Jonathan Corbet -
SQL Is Alive And Well opinion
A slightly odd interview that ties SQL’s future success into the increasing role of distributed systems.
Read Write -
SQLPro for Postgres: A Mac OS X Postgres Manager tools
This beta is available for free.
Hankinsoft Development