Author: Derik Hammer

Introduction to Azure SQL Data Warehouse Track: Business Intelligence / Architecture Level: 100 Abstract: On-premises data warehouse solutions are typically a large up-front capital expense…

If you are a human and are seeing this field, please leave it blank. Fields marked with a are required. First Name Last Name…

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…

Microsoft Azure provides a convenient feature when creating a new Azure SQL Data Warehouse database. You can create the database from a backup of…

Earlier this year, I wrote about Failure Integrity Power Transparency and Respect. This was taken from the perspective of a person who is learning…

SQLHammer.com has been quieter than usual this year. I have not written nearly as many blog posts as I would like. The reason for…

I need your help. I am working on improving my department’s problem solving skills. This is going to manifest in a lot of one-on-one…

> The key to success is failure. There is much truth in that statement. It is also like a prism which can be perceived…

My company is in the middle of a migration to Amazon Redshift. Data warehouse design standards have been in question now that our platform…

SQL Server has a feature for partitioning tables and indexes. Partitioning can be implemented at many levels, however. You can create multiple tables for…