Tagged | SQL

• Forecasting SQL query resource usage with machine learning

  (blog.twitter.com)

  #machine-learning #DBMS #SQL #systems

• How to Identify and Tune a Problematic Query with SQL EXPLAIN

  (www.cockroachlabs.com)

  #debugging #DBMS #SQL #data-engineering

• How InnoDB Handles TEXT/BLOB Columns

  (www.percona.com)

  #DBMS #SQL #systems

• Solving Bottlenecks With SQL Indexes and Partitions

  (www.toptal.com)

  #DBMS #performance #SQL

• Improving Application Performance with Duplicate Indexes

  (www.cockroachlabs.com)

  #DBMS #performance #SQL

• Real-Time Small Business Intelligence with ksqlDB

  (www.confluent.io)

  #DBMS #apache-kafka #SQL #analytics

• 18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part One)

  (www.percona.com)

  #DBMS #scaling #SQL

• [Performance Optimization] Writing Better Ruby Tests for SQL Queries

  (tech.pic-collage.com)

  #testing #RoR #performance #SQL #web

• sqlalchemy_batch_inserts: a module for when you’re inserting thousands of rows and it’s slow

  (benchling.engineering)

  #DBMS #performance #SQL

• Automating MySQL schema migrations with GitHub Actions and more

  (github.blog)

  #software-engineering #DBMS #SQL #practices

• Configuring SQL Server for High Availability in the Cloud

  (hackernoon.com)

  #software-architecture #scaling #SQL #cloud

• Speeding Up SELECT Queries with Parquet Page Indexes

  (blog.cloudera.com)

  #DBMS #performance #SQL #data-engineering

• Engineering SQL Support on Apache Pinot at Uber

  (eng.uber.com)

  #DBMS #distributed-systems #SQL #big-data #data-engineering

• The Curious Case of the Table-Locking UPDATE Query

  (blog.heroku.com)

  #debugging #DBMS #SQL

• Using Kafka to throttle QPS on MySQL shards in bulk write APIs

  (medium.com)

  #DBMS #apache-kafka #SQL #data-engineering

• Anomaly Detection With SQL

  (towardsdatascience.com)

  #SQL #analytics #statistics

• How We Built a Vectorized SQL Engine

  (www.cockroachlabs.com)

  #software-architecture #DBMS #SQL #data-engineering

• Multiplexing (Mux) in ProxySQL: Use Case

  (www.percona.com)

  #DBMS #performance #SQL #data-engineering

• Why Database Schema Optimization Matters

  (www.percona.com)

  #DBMS #performance #optimisation #SQL

• SQL Server Index Analysis and Optimization

  (towardsdatascience.com)

  #DBMS #performance #optimisation #SQL

• SQLsmith: Randomized SQL Testing in CockroachDB

  (www.cockroachlabs.com)

  #software-engineering #QA #testing #DBMS #SQL

• How PostgreSQL and Grafana Can Improve Monitoring Together

  (grafana.com)

  #monitoring #infra #SQL #PostgreSQL

• A Richer Activity, Part 1

  (medium.com)

  #DBMS #SQL #big-data #data-engineering

• Distributed SQL: An Evolution of the Database

  (www.cockroachlabs.com)

  #DBMS #distributed-systems #SQL

• Pre-Modern Databases: OLTP, OLAP, and NoSQL

  (www.memsql.com)

  #DBMS #noSQL #SQL #history

• 40x faster hash joiner with vectorized execution

  (www.cockroachlabs.com)

  #DBMS #performance #SQL #cockroachDB #internals

• Using Parallel Query with Amazon Aurora for MySQL

  (www.percona.com)

  #performance #optimisation #AWS #SQL

• Pipelining Consensus Writes to Speed Up Distributed SQL Transactions

  (www.cockroachlabs.com)

  #DBMS #performance #distributed-systems #SQL #systems

• A Deep Dive Into Data Quality

  (towardsdatascience.com)

  #data-science #SQL #big-data

• Sharding writes with MySQL and increment offsets

  (hackernoon.com)

  #software-architecture #DBMS #performance #SQL #backend

• Operating Vitess

  (medium.com)

  #software-architecture #DBMS #SQL #backend

• HyperLogLog in Presto: A significantly faster way to handle cardinality estimation

  (code.fb.com)

  #DBMS #performance #SQL #big-data

• Joinery: A Tale of Un-Windowed Joins

  (engineeringblog.yelp.com)

  #software-architecture #algorithms #performance #SQL

• Managing Real-time Event Streams and SQL Analytics with Apache Kafka on Heroku, Amazon Redshift, and Metabase

  (blog.heroku.com)

  #apache-kafka #SQL #real-time #event-queue

• Article: Back to the Future with Relational NoSQL

  (www.infoq.com)

  #DBMS #noSQL #SQL #data-modeling

• Cross-Shard Queries & Lookup Tables

  (medium.com)

  #DBMS #distributed-systems #SQL #systems

• Enforcing Transitive Constraints in SQL

  (benchling.engineering)

  #DBMS #SQL #data-modeling

• How We Built a Cost-Based SQL Optimizer

  (www.cockroachlabs.com)

  #software-architecture #DBMS #SQL

• ATM Fraud Detection with Apache Kafka and KSQL

  (www.confluent.io)

  #data-pipeline #machine-learning #apache-kafka #SQL

• An Introduction to Join Ordering

  (www.cockroachlabs.com)

  #DBMS #SQL #cockroachDB #internals

• SQL at Scale with Apache Spark SQL and DataFrames — Concepts, Architecture and Examples

  (towardsdatascience.com)

  #DBMS #scaling #apache-spark #SQL

• SQL vs. Flux: Choosing the right query language for time-series data

  (blog.timescale.com)

  #DBMS #programming-languages #SQL

• Machine Learning in Google BigQuery

  (ai.googleblog.com)

  #machine-learning #data-analytics #SQL #cloud

• Presentation: Streaming SQL to Unify Batch & Stream Processing w/ Apache Flink @Uberu

  (www.infoq.com)

  #data-pipeline #stream-processing #SQL

• To Shard, or Not To Shard: That Was The Holiday 2017 Question

  (tech.wayfair.com)

  #software-engineering #DBMS #SQL

• Presentation: Gimel: PayPal’s Analytics Data Platform

  (www.infoq.com)

  #SQL #analytics #big-data #storage

• A Look at MyRocks Performance

  (www.percona.com)

  #monitoring #DBMS #performance #SQL

• Calling C functions from BigQuery with Web Assembly

  (blog.sourced.tech)

  #web-assembly #SQL #C

• Deep Neural Network implemented in pure SQL over BigQuery

  (towardsdatascience.com)

  #SQL #neural-net

• Visualize This! MySQL Tools That Explain Queries

  (www.percona.com)

  #dev-tools #SQL #MySql

• Queryparser, an Open Source Tool for Parsing and Analyzing SQL

  (eng.uber.com)

  #logging #SQL #analytics #parsing

• Big, fast, easy data with KSQL

  (www.oreilly.com)

  #data-stream #apache-kafka #SQL

• Fun with Views and CTEs

  (hashrocket.com)

  #dev-tools #DBMS #SQL

• ProxySQL Firewalling

  (www.percona.com)

  #security #SQL #firewall

• Analyzing the Performance of Millions of SQL Queries When Each One is a Special Snowflake

  (heap.engineering)

  #DBMS #performance #SQL #analytics

• Scaling Distributed Joins

  (blog.memsql.com)

  #performance #distributed-systems #SQL

• Taking KSQL for a Spin Using Real-time Device Data

  (www.confluent.io)

  #data-pipeline #stream-processing #apache-kafka #SQL

• Bad Practices in Database Design: Are You Making These Mistakes?

  (www.toptal.com)

  #DBMS #SQL #practices

• Getting Started Analyzing Twitter Data in Apache Kafka through KSQL

  (www.confluent.io)

  #stream-processing #data-analytics #apache-kafka #SQL

• To SQL or not to SQL

  (capgemini.github.io)

  #DBMS #noSQL #SQL

• Scalable SQL Made Easy: How CockroachDB Automates Operations

  (www.cockroachlabs.com)

  #automation #distributed-systems #SQL #cockroachDB

• Why SQL is beating NoSQL, and what this means for the future of data

  (blog.timescale.com)

  #DBMS #noSQL #scaling #SQL #history

• Real Transactions are Serializable

  (www.cockroachlabs.com)

  #SQL #cockroachDB #serialization

• JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage

  (blog.jooq.org)

  #optimisation #SQL

• Introducing KSQL: Open Source Streaming SQL for Apache Kafka

  (www.confluent.io)

  #data-stream #apache-kafka #SQL #real-time

• MySQL Has Transactions, Sorta

  (hashrocket.com)

  #DBMS #SQL #MySql #PostgreSQL

• Implementing Backup

  (www.cockroachlabs.com)

  #SQL #cockroachDB #backup

• Periscope Data | Geographic Analysis in SQL: Measuring Polygon Area from Latitude and Longitude

  (webflow-blog.periscopedata.com)

  #data-analytics #SQL #GeoData

• API, Zero Downtime Deployment and SQL Migration: Theory and Case Study

  (blog.octo.com)

  #software-architecture #infra #SQL #migration #availability

• Using Higher-Order Functions to Build Queries in Knex.js

  (spin.atomicobject.com)

  #javascript #SQL