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

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…

Unexpected Career Turn

It’s amazing that I’ve had a 22-year career in tech, and until last week, I had never been laid off. Last week, I was a victim of the 20% layoffs at Shopify. Along with me came very talented people with…

MySQL: Quotation Marks

My article on DB2 Basics: Quotation Marks has 962 views so far this year, so I thought it might be time to write a similar article on using quotation marks with MySQL. General quotation marks For the most part, you…

Scaling Relational Databases

“Relational databases don’t scale!”. This is the claim that database experts have heard over and over again, and yet we spend our careers scaling databases. I immediately translate this in my head to either “I threw hardware at the problem…

Choosing the BEST RDBMS

When I started working as a DBA in 2001, the relational database management system choices were more limited and the choice itself was often left up to a system architect. Rarely did developers have a say, and even DBAs only…

Using ChatGPT to Write SQL

Working in technology, I’ve heard a number of things about ChatGPT from various news sources. I was particularly interested hearing some teachers saying it was the end of being able to properly detect students cheating when writing papers. Then I…