Data Warehouse

Musings of a DevOps Data Pro

Musings of a DevOps Data Pro

Continuous delivery and automation are a couple of core concepts of DevOps. As a Data Professional, I have spent countless hours pushing through the resistance of people who feel the data tier should be left out of source control, automated…

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…

NYC Yellow Cab Data in Azure SQL Data Warehouse

NYC Yellow Cab Data in Azure SQL Data Warehouse

Microsoft Azure provides a convenient feature when creating a new Azure SQL Data Warehouse database. You can create the database from a backup of the Microsoft sample database, AdventureWorksDW. This is super fast and easy. It also has huge tables…

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…