--- title: "This week's database news, issue 61" publication: "DB Weekly" issue: 61 published_at: "2015-06-05" canonical_url: "https://dbweekly.com/issues/61" --- This week's database news, issue 61 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/61) DB WeeklyIssue 61 — June 5, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [10 Rules for a Better SQL Schema](https://www.periscope.io/blog/better-sql-schema.html?utm_source=dbweekly&utm_medium=email)PeriscopeA mixture of stylistic and practical tips for building an easy to understand and maintain schema for your SQL database. [Announcing Couchbase Server 4.0 Beta](http://blog.couchbase.com/announcing-couchbase-server-4.0-beta?utm_source=dbweekly&utm_medium=email)CouchbaseIncludes numerous new features, the new N1QL (SQL for JSON) query language, multi dimensional scaling, global secondary indexes, a new storage engine, and more. [Top 7 Features Coming to SQL Server 2016](https://redmondmag.com/articles/2015/06/03/features-to-sql-server-2016.aspx?utm_source=dbweekly&utm_medium=email)Redmond MagazineIncludes Query Store, Polybase, Stretch Database, JSON support, row-level security, encryption, and in-memory enhancements. [Introduction to Redis Sentinel](http://objectrocket.com/blog/how-to/introduction-to-redis-sentinel/?cm_mmc=data_nosql_Redis-sentinel_dbweekly-newsletter)ObjectRocketSponsoredRedis 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.](http://objectrocket.com/blog/how-to/introduction-to-redis-sentinel/?cm_mmc=data_nosql_Redis-sentinel_dbweekly-newsletter) [![ObjectRocket\](http://s3.amazonaws.com/nlga/uploads/item/image/38298/i.png)](http://objectrocket.com/blog/how-to/introduction-to-redis-sentinel/?cm_mmc=data_nosql_Redis-sentinel_dbweekly-newsletter) [Introducing N1QL: The SQL Gene in NoSQL](http://blog.couchbase.com/introducing-n1ql-sql-gene-in-nosql?utm_source=dbweekly&utm_medium=email)CouchbaseN1QL is an SQL-like language introduced in the new Couchbase Server 4.0 (above) that brings SQL, NoSQL and JSON together. [SheetSQL: An SQL Engine Inside Google Sheet](https://github.com/Xuefeng-Zhu/SheetSQL?utm_source=dbweekly&utm_medium=email)Xuefeng ZhuSheetSQL builds a SQL engine into Google sheet by storing and retrieving data directly in Google Sheet. [Graph Databases Seen 'Connecting the Dots'](http://www.datanami.com/2015/06/02/graph-databases-seen-connecting-the-dots/?utm_source=dbweekly&utm_medium=email)DatanamiGraph databases are increasingly seen as a way to “connect the dots” as enterprise applications emerge requiring the linking of huge datasets. [YeSQL: Battling the NoSQL Hype Cycle with Postgres [PDF\]](http://momjian.us/main/writings/pgsql/yesql.pdf?utm_source=dbweekly&utm_medium=email)Bruce MomjianThis talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads. [Can Anyone Provide A Sound Argument for Choosing MySQL Over Postgres?](https://news.ycombinator.com/item?id=9586504)Hacker NewsIt’s not easy, but some people fight MySQL’s corner pretty well. Jobs - [Database Administrator (Blacksburg, VA)](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job?utm_source=dbweekly&utm_medium=email)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.](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job) Rackspace In brief - [NoSQL Champ MongoDB Plugs Into SQL Analytics Power](http://www.theregister.co.uk/2015/06/03/mongodb_swallows_sql_tools/?utm_source=dbweekly&utm_medium=email) 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 $115B by 2019](http://www.datanami.com/2015/05/29/forecast-pegs-data-market-at-115b-by-2019/?utm_source=dbweekly&utm_medium=email) news Datanami - [Spark Gets New Machine Learning Framework: KeystoneML](http://www.datanami.com/2015/05/26/spark-gets-new-machine-learning-framework-keystoneml/?utm_source=dbweekly&utm_medium=email) 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](http://www.couchbase.com/press-releases/couchbase-introduces-n1ql-breakthrough-query-language?utm_source=dbweekly&utm_medium=email) 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](http://www.datanami.com/2015/06/04/survey-casts-doubt-on-big-data-hadoop-efforts/?utm_source=dbweekly&utm_medium=email) news Datanami - [SQL Server 2016: In-Memory Columnstore Indexes](http://www.infoq.com/news/2015/06/SQL-Server-MOT-CS?utm_source=dbweekly&utm_medium=email) news InfoQ - [The #1 Enemy of Data Loading in SQL Server](http://www.madeirasql.com/the-number-one-enemy-of-data-loading/?utm_source=dbweekly&utm_medium=email) tutorial Matan Yungman - [How Okta Chased Down Severe System CPU Contention in MySQL](http://developer.okta.com/blog/2015/05/22/tcmalloc/?utm_source=dbweekly&utm_medium=email) A look at how the kernel mutex was slowing down a MySQL install. Okta Developer - [PostgreSQL: The Good, The Bad, and The Ugly](http://lwn.net/SubscriberLink/645020/e1ba36cff8248df0/?utm_source=dbweekly&utm_medium=email) opinion Jonathan Corbet - [SQL Is Alive And Well](http://readwrite.com/2015/06/02/memsql-eric-frenkiel-interview?utm_source=dbweekly&utm_medium=email) 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](http://www.hankinsoft.com/SQLProPostgres/?utm_source=dbweekly&utm_medium=email) tools This beta is available for free. Hankinsoft Development Curated by [Peter Cooper](http://twitter.com/peterc) and published by [Cooper Press](https://cooperpress.com/) for [Rackspace](http://www.rackspace.com/?utm_source=dbweekly&utm_medium=email). Send feedback by simply replying to this mail. Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q4.pdf) Want to post a job? E-mail us or [use our self-serve system.](https://cooperpress.com/jobs) [Unsubscribe](*|UNSUB|*) : [Change email address](*|UPDATE_PROFILE|*) : [Read this issue on the Web](http://dbweekly.com/issues/61) © Cooper Press Ltd. Office 30, Lincoln Way, Louth, LN11 0LS, UK [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)