With Amazon Redshift SSD, querying a TB of data took less than 10 seconds December 07, 2021 by Abe Dearmer The AWS team announced the release of an SSD version of Amazon Redshift on January 24, 2014.
How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 1) December 07, 2021 by Mark Smallcombe 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:
How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 2) December 07, 2021 by Mark Smallcombe 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.
How to improve performance of "UPSERT"s when running "COPY commands December 07, 2021 by Abe Dearmer 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.
Treetop's Confusing Behavior December 07, 2021 by Mark Smallcombe This article will walk you through some of those gotchas hoping that you can save precious time and energy
What is the U.S.-EU Safe Harbor Program? December 07, 2021 by Abe Dearmer In a nutshell, the Safe Harbor program enables certified American companies to safely handle personal and potentially sensitive data from European customers and partners.
When Should You Consider Using Amazon Redshift? December 07, 2021 by Donal Tobin Let’s talk about when you might want to consider using Amazon Redshift, a leading data warehousing solution from AWS.