SQL

SQL news, information, and how-to advice

database data center futuristic technology
language type words

Digital explosion of data and numbers

How to bring BI and analytics to modern nested data structures

Nested data structures are a boon to modeling, storage, and query performance, but pose challenges to traditional BI tools. Here’s how to overcome them

NASA Apollo 8 - December 24, 1968 - Earthrise

Cosmos DB review: Database for a small planet

Multi-model Azure database combines global reach and a choice of five consistency models, allowing you to trade off cost for consistency

speedometer 124549393

TiDB: Performance-tuning a distributed NewSQL database

A brief introduction to the open source hybrid transactional and analytical database and how to tune write operations for maximum performance

racing speed speedometer fast

Review: Neo4j supercharges graph analytics

When it comes to tracking relationships, Neo4j is faster, more flexible, and more scalable than relational databases

abstract tunnel showing speed and motion and connectivity

SQL unleashed: 17 ways to speed your SQL queries

It’s easy to create database code that slows down query results or ties up the database unnecessarily—unless you follow these tips

analyzing performance of wireless mobile connectivity data statistics

An intro to Studio 3T, a MongoDB IDE

The growing third-party market is a key indication that MongoDB has moved from mere maturity to one of the dominant players in this market

metal briefcase survival kit

CockroachDB review: A scale-out SQL database built for survival

CockroachDB is a distributed SQL database built on top of a transactional and consistent key-value store that can withstand datacenter failures

free neon sign

Top 5 open source tools for MySQL administrators

Look to these excellent tools to improve CLI and web admin, SQL queries, schema migration, and replication and recovery in your MySQL environment

hipster running with laptop

Why old-school PostgreSQL is so hip again

Postgres is old as dirt, yet over the past five years it has panned out as pure gold

abstract fire rays 100152558

Spark tutorial: Get started with Apache Spark

A step by step guide to loading a dataset, applying a schema, writing simple queries, and querying real-time data with Structured Streaming

bolts of light speeding through the acceleration tunnel 95535268

Real-time machine learning with TensorFlow, Kafka, and MemSQL

How to build a simple machine learning pipeline that allows you to stream and classify simultaneously, while also supporting SQL queries

holiday lights neurons network stream

What is Apache Spark? The big data analytics platform explained

Fast, flexible, and developer-friendly, Apache Spark is the leading platform for large-scale SQL, batch processing, stream processing, and machine learning

statistics stats big data analytics

Dremio: Simpler and faster data analytics

Built on Apache Arrow and Apache Parquet, Dremio brings self-service to data analysts and SQL queries to NoSQL data sources

bolts of light speeding through the acceleration tunnel 95535268

7 keys to better MySQL performance

As size and load grow, performance tends to slow. Keep these keys in mind to keep MySQL running smoothly

I love MySQL license plate heart

What’s new in MySQL 8.0

Better Unicode support, better JSON and document handling, and long-requested features like window functions are part of the next big release for the popular open source database

bossies 2017 database analytics

Bossie Awards 2017: The best databases and analytics tools

InfoWorld picks the best open source software for large-scale search, SQL, NoSQL, and streaming analytics

road to future forward idea cloud road

8 technologies transforming the database

That database has come a long way from tables of rows and columns, and the journey is far from over

sun in clouds solar

10 tips for better search queries in Apache Solr

Get started with Solr’s specialized search query functions such as filter queries and faceting

Load More