
I often start with just a query id and a general description of a performance problem. Almost as often as I’m looking at query profiles or the equivalent in internal tools, I like to see more about the context of…

One of the most basic building blocks of Snowflake query performance is partition pruning. Let’s explore partition pruning, identifying when it is occurring, and why it matters for query performance. Micro-Partitions Snowflake stores data in micro-partitions. Micro-partitions are proprietarily structured…

This was one of my favorite types of blog entries to write when I worked with IBM Db2, and I’d like to revive it for Snowflake queries. I spend a good part of my day job helping people solve SQL…

As someone who regularly makes up scenarios to demonstrate concepts – both professionally and in my free time, I was very used to Db2’s answer to data generation – which is basically either fun with recursive SQL, pay for the…

This blog entry compliments a webinar on February 8th where I will be a panelist answering questions on Amazons RDS for Db2. Register for “Introducing Amazon RDS for Db2”now. I was lucky enough to be invited to speak at IDUG…

I have answered this question so many times and in so many different ways. Conceptually, my article Db2 Basics: The Role of Databases covers the concept of a database or database management system, why we need them and how we…

I had the idea of recording my rolls to prove that I’m taking whatever the the SQL random function gives me. Here’s my first attempt at that: Video showing roll for database rolls for this article Rolls Roll TypeRoll ValueRoll…

I’d really like to thank Shopify for laying me off back in May. I am so much happier in this role, and already starting to feel competent, only six months in. Don’t get me wrong, I have a ton to…

IBM, the Death Star, and rise of the Resistance. In the spring of 2018, Ember and I attended a dinner with members of the Db2 Technical Advisory Board (TAB). This was a collection of respected Db2 end-users, clients, and consultants…

There are plenty of guides to setting up a trial of Snowflake online, but as part of my “Roll for Database” series, I want to have the basics of setting up a free trial of any platform I work with,…

The revelation that Snowflake doesn’t (currently) use b-tree indexes may be shocking to some who are used to a more traditional rdbms environment. It is interesting, therefore, to walk through some of the generalities of the methodologies to understand why…

I’ve spent 20 years of my career working with IBM Db2, then a year working with MySQL, and now my database platform of choice is Snowflake. When I was moving from Db2 to MySQL, there were a number of “WTH?”…