DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 159 — June 16, 2017
What's New in SQL:2016 — The new ISO standard introduces row pattern recognition, JSON, listagg and many other features. Unsurprisingly, support is currently quite low but should increase over time.
Markus Winand   tutorial  
SQLite 35% Faster Than The Filesystem? — A look at how SQLite can be both faster and more space efficient when dealing with small blobs versus the standard filesystem. Related Hacker News discussion.
SQLite   story  
How to Optimize Cassandra Database Performance — 3 ways to ensure that your Cassandra workloads are operating at peak efficiency
SelectStar   sponsored  
SystemML, the 'SQL for Machine Learning,' Is Now a Top-Level Apache Project — Developed to provide the ability to scale data analysis from a small laptop to large clusters without the need to rewrite the entire codebase.
Susan Hall   news  
Amazon Aurora Introduces Database Cloning Capabilities
Amazon Web Services   news  
TimescaleDB Focuses on Query Power and Scale
The New Stack   news  
How to Document SQL Server Database Objects
Jefferson Elias   tutorial  
When to Use Bind Values and When to Use Inline Values in SQL
Lukas Eder   tutorial  
How to Migrate from SQL to MongoDB — Learn why today's most innovative companies are migrating to MongoDB.
MONGODB   sponsored  
The Different Types of NoSQL Databases — Key-value stores, document stores, column stores, and graph databases.
Roopendra Vishwakarma   tutorial  
Mosaic: Processing A Trillion-Edge Graph On A Single Machine — A look at an interesting architecture: “Unless your graph is bigger than Facebook’s, you can process it on a single machine.”
Adrian Colyer   story  
Using UUID or GUID as Primary Keys? Be Careful — You can use UUIDs as the primary key to avoid certain scaling problems, but should you? Tom proposes an alternative.
Tom Harrison Jr   opinion  
How to Properly Monitor Elasticsearch
Eric Bernsen   tutorial  
SQL Server 2016 Row Level Security In Action
Gavin Draper
What You Need to Know about SQL Server's Distinct Windowed Aggregate Calculations
Itzik Ben-Gan   tutorial  
SQL Server 2017 Graph Data Features In Action
Gavin Draper   tutorial  
Running SQL Queries Against Baby Names from Social Security Card Applications
Denis Gobo   tutorial  
All the developer services you want, wherever you want them — Manifold enables you to purchase everything from RedisGreen to CloudAMQP with one account, on one bill.
Manifold   tools  sponsored  
oi: Blazingly Fast Ordered Data Intersection Tool — Grep request logs in the blink of an eye.
Marcin Tojek   tools  
Soundwave: A Configuration Management Database
Pinterest Engineering   tools  
« Prev
Next »