Category Featured

Generating Data in Snowflake

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…

Application-Level Sharding

There are many ways to scale databases. One I was less familiar with before my last job is application-level sharding. While there are tools that work on some platforms to help you achieve application-level sharding (like Vitess with MySQL), the…

What is Snowflake?

Disclaimer: this article is only my opinions. I do not represent Snowflake. I realized after writing last week’s article that some people might be like me a few months ago, and not really understand what Snowflake is and how it…

My New Direction: Snowflake!

I am so excited about the new job that I’m starting on July 5th! I’m joining the Field CTO office at Snowflake as a Principal Architect, Data Performance. In this role, I’ll be tackling the thorniest performance issues that clients…

Db2 Basics: Table Spaces

Table spaces are one of the more powerful tools in Db2 that are largely invisible. We used to have to spend a lot more time on table space management. Basics and Terminology Some of the terms here are rarely needed…