Cloud Integration How Dow Jones Uses Amazon Redshift to Build a Cloud-based Data Platform Table of Contents A struggle for data Designing the new data platform Best practices for querying data New use cases for data The Future of Dow Jones’ Data Platform Why... Abe Dearmer Read More
Cloud Integration With Amazon Redshift SSD, querying a TB of data took less than 10 seconds The AWS team announced the release of an SSD version of Amazon Redshift on January 24, 2014. Abe Dearmer Read More
Cloud Integration How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 1) We recently discovered an issue running queries from EC2-Classic instances onto a Redshift cluster in EC2-VPC. We ran through a number of troubleshooting steps including: Mark Smallcombe Read More
Cloud Integration How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 2) We set out to edit all our Chef recipes to deploy our new DHCP client configuration files so we can quickly deploy them to all our instances. Mark Smallcombe Read More
Cloud Integration How to improve performance of "UPSERT"s when running "COPY commands UPSERT is the operation to merge new records with existing records using primary keys on a table. While some RDBMSs support a single UPSERT statement. Abe Dearmer Read More
Cloud Integration Treetop's Confusing Behavior This article will walk you through some of those gotchas hoping that you can save precious time and energy Mark Smallcombe Read More
Cloud Integration What is the U.S.-EU Safe Harbor Program? In a nutshell, the Safe Harbor program enables certified American companies to safely handle personal and potentially sensitive data from European customers and partners. Abe Dearmer Read More