• 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 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
• 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
• 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
• $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
• Predicting Exponential Growth with SQL https://www.periscope.io/blog/predicting-exponential-growth-with-sql.html 3 comments 11/6/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