Databases

“This is My Architecture”: Behind the Scenes of Periscope Data’s Architecture

January 2, 2018

Amazon Redshift’s Hardware Upgrade Improves Query Speed by up to 5x

October 17, 2017

Using Python to Write a Create Table Statement and Load a CSV into Redshift

July 12, 2017

How to Get Started With AWS Spectrum in Minutes

June 6, 2017

How Joins Work

February 1, 2017

Data Warehouse Management: Redshift, Bigquery, and Snowflake

October 21, 2016

Converting MySQL Syntax and Functions into Redshift

May 26, 2016

Concatenating Rows in Redshift, Postgres, & MySQL

November 12, 2015

Building the Periscope Data Cache with Amazon Redshift

October 22, 2015

Understanding Distributed Analytics Databases, Part 2 — Data Distribution

October 8, 2015

Understanding Distributed Analytics Databases, Part 1: Query Strategies

September 30, 2015

Connecting to a Redshift Cluster with a Private IP

August 27, 2015

Setting up Your Redshift Cluster

August 20, 2015

How to ETL Data into and out of Amazon Redshift

July 30, 2015

Explain and Other Tools for Query Optimization

July 9, 2015

4 Reasons Not To Use MySQL For Analysis

June 18, 2015

10 Rules for a Better SQL Schema

June 3, 2015

Optimizing Query Management on Redshift

May 27, 2015

Helpful Redshift Admin Queries

April 30, 2015

The Lazy Analyst's Guide To Postgres JSON

March 12, 2015

Exact Row Counts for All Tables in MySQL and Postgres

March 5, 2015

$3000 Data Warehouse — Redshift vs. Postgres

February 26, 2015

Importing Data into Redshift from MySQL and Postgres

February 19, 2015

Counting Comma-Delimited Values in Postgres, MySQL, Amazon Redshift and MS SQL Server.

February 5, 2015

Demystifying Redshift — What's Up with My Disks?

January 22, 2015

Redshift Maintenance 101

January 15, 2015

Changing Dist and Sort Keys on Giant Tables in Redshift

December 24, 2014

Cross-Database Joins

November 17, 2014

Optimizing Your psql

October 23, 2014

Hashing Tables to Ensure Consistency in Postgres, Redshift and MySQL

June 3, 2014

Faster Redshift Queries with Materialized Views — Lifetime Daily ARPU

May 15, 2014

Count Distinct Compared on Top 4 SQL Databases

May 1, 2014