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 »