AWS

Amazon Redshift Unexpected Commit

Amazon Redshift Unexpected Commit

If you are familiar with sqlhammer.com, then you know that I heavily specialize in the Microsoft Data Platforms. My experiences with Microsoft, and specifically the SQL Server products, established an expectation that explicit transactions would always commit/rollback successfully or there…

Amazon Redshift Temporary Tables

Amazon Redshift Temporary Tables

My company is in the middle of a migration to Amazon Redshift. Data warehouse design standards have been in question now that our platform is changing. One development team asked me whether they would be allowed to use temporary tables…

What is a cloud data warehouse?

What is a cloud data warehouse?

Amazon Redshift was announced in November of 2012 and became the first cloud data warehouse, opening a whole new segment of technology. What is a cloud data warehouse exactly? On-premises data warehouse While cloud data warehouses are relatively new, at…

AWS Database Migration Service

AWS Database Migration Service

I have begun writing a few blog posts focused on launching your databases into the cloud. Specifically targeted on database migration methodologies. Choosing a migration method involves making a lot of decisions up-front. This post will assume that Managed Relational…