Category: Uncategorized

Track: Developer / Performance Level: 200 Abstract: The DBA is constantly ringing your phone complaining about why you did not include an index to support…

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…

Our zatz-its are wise. Our zatz-its are dispersed. We have questions to ask the zatz-its, so we corral them in a warehouse. Now everyone…

Amazon Redshift was announced in November of 2012 and became the first cloud data warehouse, opening a whole new segment of technology. What is…