Advanced SQL: Common Table Expressions — The latest in a series discussing advanced SQL concepts in the context of how they improve more elementary SQL. This time, temporary in-query tables in the form of common table expressions (CTE).
SelectStar: Turn Database Monitoring Information Into Insight — SelectStar is the only database monitoring solution that digs into today’s modern data tier to provide recommendations, including those that may increase query speeds. Like what you see? You can take action immediately with a single click.
Building a Fast Data Ingestion Pipeline to Redshift — A data team built out a data ingestion pipeline for loading data from S3 into Amazon Redshift. Over a week, they increased its performance 1000x - here's the story of how.
