--- title: "This week's database news, issue 58" publication: "DB Weekly" issue: 58 published_at: "2015-05-15" canonical_url: "https://dbweekly.com/issues/58" --- This week's database news, issue 58 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/58) DB WeeklyIssue 58 — May 15, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [Please Stop Calling Databases CP or AP](https://martin.kleppmann.com/2015/05/11/please-stop-calling-databases-cp-or-ap.html?utm_source=dbweekly&utm_medium=email)Martin KleppmannSometimes database architectures are described as ‘CP’ (consistent but not available under network partitions) or ‘AP’ (available but not consistent under network partitions) - Martin Kleppmann presents a compelling argument for why such terminology doesn’t help us a lot. [Google Launches Cloud Bigtable, A Scalable And Performant NoSQL Database](http://techcrunch.com/2015/05/06/google-launches-cloud-bigtable-a-highly-scalable-and-performant-nosql-database/?utm_source=dbweekly&utm_medium=email)TechCrunchCloud Bigtable is a new Bigtable-based data storage system with Apache HBase API compatibility. Bigtable powers services like Gmail and Google Search itself, so it makes for an interesting offering. [Learn SQL Interactively on Khan Academy](http://cs-blog.khanacademy.org/2015/05/just-released-full-introductory-sql.html?utm_source=dbweekly&utm_medium=email)Khan AcademyKhan Academy has unveiled a complete introductory SQL course complete with an interactive, in-browser editor and testing environment. [10 Quick Tips for Redis](http://objectrocket.com/blog/how-to/10-quick-tips-about-redis/?cm_mmc=data_nosql_Redis-tips_dbweekly-newsletter)ObjectRocketSponsoredRedis has come a long way from being a small personal project from Antirez, to being an industry standard for in memory data storage. With that comes a set of best practices that most people can agree upon for using Redis properly. [Check out](http://objectrocket.com/blog/how-to/10-quick-tips-about-redis/?cm_mmc=data_nosql_Redis-tips_dbweekly-newsletter) 10 quick tips on using Redis correctly. [![ObjectRocket\](http://s3.amazonaws.com/nlga/uploads/item/image/37407/i.png)](http://objectrocket.com/blog/how-to/10-quick-tips-about-redis/?cm_mmc=data_nosql_Redis-tips_dbweekly-newsletter) [Why The SQL Standard Does Not Need Another Way to Do GROUP BY](http://glennpaulley.ca/conestoga/2015/05/why-the-sql-standard-does-not-need-another-way-to-do-group-by/?utm_source=dbweekly&utm_medium=email)Glenn PaulleyIn [How SQL GROUP BY Should Have Been Designed](http://www.javacodegeeks.com/2015/05/how-sql-group-by-should-have-been-designed-like-neo4js-implicit-group-by.html), Lukas Eder suggests an alternative approach for GROUP BY’s implementation, but Glenn doesn’t think it’s necessary. [Recovering Redis Data with GDB](http://bigeng.io/post/118963807718/recovering-redis-data-with-gdb?utm_source=dbweekly&utm_medium=email)Bigcommerce EngineeringWhen a Redis instance blocked on writing to disk and hung, David Basden got serious with the GNU Debugger. [PostgreSQL vs. MS SQL Server](http://www.pg-versus-ms.com/?utm_source=dbweekly&utm_medium=email)Matthew ByrneA comparison of the two relational databases from the point of view of a data analyst. [Simplify: Move Code Into Database Functions](https://sivers.org/pg?utm_source=dbweekly&utm_medium=email)Derek SiversA provoking and clearly thought out piece around the idea of moving much more code and logic directly into your database (something many DBAs will be nodding their heads about). [Heroku Redis Now Available in Public Beta](https://blog.heroku.com/archives/2015/5/12/heroku-redis-now-available-in-public-beta?utm_source=dbweekly&utm_medium=email)HerokuAs Redis has become more popular, more Heroku users are leaning on external services like RedisGreen to get Redis support in their apps. Heroku are now trialling hosting it in-house, as they already do with Postgres. Jobs - [DevOps Engineer (Austin, TX)](https://uscareers-rackspace.icims.com/jobs/13168/devops-engineer--objectrocket/job?utm_source=dbweekly&utm_medium=email)ObjectRocket by Rackspace is seeking a DevOps Engineer to join our team in Austin. Do you believe Open Source will always innovate faster? Is “Automate Everything” printed on the back of your hoodie? Are you most comfortable on the cutting edge of technology? If this describes you and you’re ready to attack some of the most complex problems in the industry, then it’s time for you to take on the challenge of being a DevOps Engineer at Rackspace. [Apply Today.](https://uscareers-rackspace.icims.com/jobs/13168/devops-engineer--objectrocket/job) Rackspace - [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 - [Gartner: Hadoop Adoption 'Fairly Anemic'](http://www.datanami.com/2015/05/14/gartner-hadoop-adoption-fairly-anemic/?utm_source=dbweekly&utm_medium=email) news Datanami - [Java, SQL Top Google's 'Most Searched' List](http://insights.dice.com/2015/05/15/java-sql-top-google-most-searched-list/?utm_source=dbweekly&utm_medium=email) news Dice - [5 Tips to Optimize Your SQL Queries](http://www.vertabelo.com/blog/technical-articles/5-tips-to-optimize-your-sql-queries?utm_source=dbweekly&utm_medium=email) tutorial Adrian Wiech - [HyperLogLog in Pure SQL](https://www.periscope.io/blog/hyperloglog-in-pure-sql.html?utm_source=dbweekly&utm_medium=email) tutorial Periscope - [Azure SQL Database Point in Time Restore with Second Resolution](http://axilis.com/blogs/vmarsic/Azure-SQL-Database-Point-in-Time-Testore-with-Second-Resolution?utm_source=dbweekly&utm_medium=email) tutorial Vedran Maršić - [How to Find Objects that Contain a Certain String in SQL Server](http://www.madeirasql.com/find-objects-that-contain-a-certain-string/?utm_source=dbweekly&utm_medium=email) tutorial Matan Yungman - [Compressing PostgreSQL JSONB data 12x using cstore_fdw](https://www.citusdata.com/blog/14-marco/156-compressing-jsonb-using-cstore-fdw?utm_source=dbweekly&utm_medium=email) tutorial Marco Slot - [Announcing VividCortex's Free Network Analyzer Tools for MySQL and PostgreSQL](https://vividcortex.com/blog/2015/05/13/announcing-vividcortex-network-analyzer-mysql-postgresql/?utm_source=dbweekly&utm_medium=email) tools VividCortex - [A Graph Database Use Case: Insurance Fraud Detection](http://sparsity-technologies.com/blog/graph-database-use-case-insurance-fraud-detection/?utm_source=dbweekly&utm_medium=email) Sparsity Technologies - [Effective Micro-Caching in Relational Database](http://www.briskat.com/blog/Effective-Caching/?utm_source=dbweekly&utm_medium=email) Hynek Vychodil 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/58) © 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)