Issue 149 — April 7, 2017
Building A Scalable Time-Series Database on Postgres
is a new open-source time-series database optimized for fast ingest and complex queries.
SQLite 3.18 Released
has been added, a mechanism for attempting to optimize the database and improve long-term query performance.
Apache Quickstep: A SQL-Based Performance-Focused DB Engine
— Originating in 2011, but now being incubated at Apache, Quickstep competitively runs SSB and TPC-H benchmarks on a single node and is designed to support the latest in hardware technology for faster performance.
Webinar: Better Azure SQL Performance
— Learn how to reduce development times by getting a better understanding of how your Azure SQL workloads are really performing.
A Data Model for an Electric Power Distribution System
— Vertabelo's database modelling scenarios continue to get more niche but it's always interesting to see how a professional database designer approaches the challenges involved.
Business Intelligence Performance Benchmarks with Google BigQuery
— A deeper look at Google’s BigQuery, and how it stacks up in the BI-on-Big Data ecosystem.
Redis Flash: Double Performance on NVMe SSDs
— Redis Flash on
AWS I3 instances
(which have NVMe SSDs) gets up to 2.5x performance compared to on I2s.
Meet Ray, The Real-Time Machine-Learning Replacement for Spark
Data Compression Improvements in Amazon Redshift Bring Compression Ratios Up to 4x
Getting Started with Apache Cassandra (with Ruby)
Language-Specific Views in MongoDB 3.4
— Building multiple filtered, language-specific views of a common collection using collations & partial indexes.
Docker: Getting Started with Python, Redis, and NGINX
Record Linking with Apache Spark's MLlib and GraphX
— A scalable approach to fuzzy data matching.
Distributed COUNT(DISTINCT) with HyperLogLog on Postgres
Deploy a Couchbase + Node Webapp as Docker Containers
Backing Up SQL Server Databases Hosted on Azure VMs
Why is January 1, 1753 The Minimum Date Value in SQL Server?
— It’s Philip Stanhope, 4th Earl of Chesterfield’s fault.
How Can I Impress at a DBA Job Interview With Little Experience?
How to find and fix the slowest code in your .NET application
— Find bottlenecks in your code or database & boost performance with ANTS Performance Profiler.
Try it free now
Ifrit: An SQL to MongoDB Query Compiler for Data Aggregation
— Written in PureScript, a language that compiles to JS.
Prophet: Forecasting At Scale from Python and R