Ember Crooks

Ember Crooks

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, spent a year working with high-volume MySQL, and is now learning Snowflake. Ember shares both posts about her core skill sets and her journey learning Snowflake. Ember lives in Denver and work from home

Snowflake and Reserved Words

One of the things that fascinates me about SQL is the extreme limits on reserved words, especially when compared with most procedural languages. I’ve written about using reserved words for IBM Db2 and MySQL. I thought I’d explore the issue…

Querying Across Databases in Snowflake

A colleague at Snowflake was working on a white paper recently. In the paper, they stated that querying between different Snowflake databases is no slower or more difficult than querying within a Snowflake database. A non-technical person asked for a…

Types of Caching in Snowflake

In my early days as a Db2 DBA, it was occasionally easy to be a performance hero. In those days, on 32-bit systems, the default size of Db2’s default buffer pool (primary data cache) was 1,000 4k pages. For many…