• Show HN: The Lazy Analyst's Guide to Faster SQL https://www.periscope.io/optimizing-sql 6 comments 6/5/2015
• Count distinct performance compared on top 4 SQL databases https://www.periscope.io/blog/count-distinct-in-mysql-postgres-sql-server-and-oracle.html 7 comments 27/1/2014
• Use SQL subqueries to count distinct 50x faster https://periscope.io/blog/use-subqueries-to-count-distinct-50x-faster.html 98 comments 24/1/2014
• Use Subqueries to Count Distinct 50X Faster https://www.periscope.io/blog/use-subqueries-to-count-distinct-50x-faster.html 2 comments 24/1/2014

• Optimizing Your psql https://www.periscope.io/blog/optimizing-your-psql.html 3 comments 31/10/2014 databases , unix

• Redshift User Defined Functions in Python https://www.periscope.io/blog/redshift-user-defined-functions-python.html 4 comments 11/9/2015 programming
• The Lazy Analyst's Guide to Amazon Redshift https://www.periscope.io/amazon-redshift-guide 10 comments 9/9/2015 programming
• Connecting to a Redshift Cluster with a Private IP https://www.periscope.io/blog/redshift-cluster-setup-private-ip.html 3 comments 27/8/2015 programming
• Building Your Own User Analytics System In SQL https://www.periscope.io/blog/how-to-build-your-own-user-analytics-in-sql.html 19 comments 23/7/2015 programming
• Thinking Critically About Mobile Game Retention https://www.periscope.io/blog/mobile-game-retention.html 3 comments 20/7/2015 gamedev
• EXPLAIN and Other Tools for Query Optimization https://www.periscope.io/blog/explain-and-other-tools-for-query-optimization.html 3 comments 9/7/2015 programming
• Comparing IP Addresses in SQL https://periscope.io/blog/comparing-ip-addresses-in-sql.html 14 comments 25/6/2015 programming
• 4 Reasons Not To Use MySQL For Analysis https://www.periscope.io/blog/reasons-not-to-use-mysql.html 19 comments 18/6/2015 programming
• 10 Rules for a Better SQL Schema https://periscope.io/blog/better-sql-schema.html 253 comments 3/6/2015 programming
• Optimizing Query Management on Redshift https://periscope.io/blog/optimizing-query-management-on-redshift.html 5 comments 28/5/2015 programming
• Getting the First Row per Group 5X Faster https://periscope.io/blog/first-row-per-group-5x-faster.html 5 comments 20/5/2015 programming
• Splitting Comma-Separated Values In MySQL https://www.periscope.io/blog/splitting-comma-separated-values-in-mysql.html 17 comments 2/4/2015 programming
• Understanding SQL's Null https://www.periscope.io/blog/understanding-sql-null.html 48 comments 17/3/2015 programming
• The Lazy Analyst's Guide To Postgres JSON https://periscope.io/blog/the-lazy-analysts-guide-to-postgres-json.html 5 comments 12/3/2015 programming
• Exact Row Counts for All Tables in MySQL and Postgres https://periscope.io/blog/exact-row-counts-for-every-database-table.html 7 comments 5/3/2015 programming
• $3000 Data Warehouse — Redshift vs. Postgres https://www.periscope.io/blog/redshift-and-rds-postgres-benchmarked.html 10 comments 26/2/2015 programming
• Counting Comma-Delimited Values in Postgres, MySQL, Amazon Redshift and MS SQL Server. https://www.periscope.io/blog/counting-comma-delimited-values-in-postgres-mysql-amazon-redshift-and-ms-sql-server.html 8 comments 5/2/2015 programming
• Pimping your psql https://periscope.io/blog/pimping-your-psql.html 56 comments 22/10/2014 programming
• Beyond random() — Normal Distributions in SQL https://periscope.io/blog/beyond-random-normal-distributions-in-sql.html 7 comments 11/9/2014 programming
• Using Self Joins To Calculate Retention, Churn, And Reactivation Metrics https://periscope.io/blog/use-self-joins-to-calculate-your-retention-churn-and-reactivation-metrics.html 5 comments 27/6/2014 programming
• How To Optimize Lifetime Distinct Counts Using Window Functions https://periscope.io/blog/calculate-your-lifetime-metrics-in-milliseconds.html 14 comments 24/6/2014 programming
• Predicting Exponential Growth with SQL https://www.periscope.io/blog/predicting-exponential-growth-with-sql.html 3 comments 11/6/2014 programming
• Hashing Tables to Ensure Consistency in Postgres, Redshift and MySQL https://periscope.io/blog/hashing-tables-to-ensure-consistency-in-postgres-redshift-and-mysql.html 3 comments 3/6/2014 programming
• HyperLogLog in Pure SQL https://periscope.io/blog/hyperloglog-in-pure-sql.html 12 comments 30/5/2014 programming
• How to Sample Rows in SQL 273X Faster https://periscope.io/blog/how-to-sample-rows-in-sql-273x-faster.html 25 comments 14/5/2014 programming
• How To Calculate Confidence Intervals in SQL https://periscope.io/blog/how-to-calculate-confidence-intervals-in-sql.html 3 comments 9/5/2014 programming
• SQL range joins give you accurate histories http://periscope.io/blog/range-join-gives-you-accurate-histories.html 8 comments 22/4/2014 programming
• Count distinct performance compared on top 4 SQL databases https://www.periscope.io/blog/count-distinct-in-mysql-postgres-sql-server-and-oracle.html 44 comments 27/1/2014 programming
• SQL: Using Subqueries to Count Distinct 50x Faster https://periscope.io/blog/use-subqueries-to-count-distinct-50x-faster.html 143 comments 24/1/2014 programming

Linking pages