Latest SQLComics

Rita the Raccoon Writes SQL

on March 28, 2024

I learned to make short form videos with my drawings this week, and, well… things are about to get weirder.

LOOK HERE

Nested Loops

on March 24, 2024

Nested loop join operators tend to look quite innocent in an estimated query execution plan. But life ain’t always so simple.

LOOK HERE

Meet the SQL Server Query Optimizer

on March 11, 2024

Thanks to Erik Darling for pointing out that it needed a little teeth.

LOOK HERE

Plan Caching in SQL Server v1

on March 4, 2024

I drew out a first visualization of how the shared plan cache in SQL Server is used when you run a query. I’m pretty sure I’ll refine and and elaborate on this in the future, so let’s call this the v1.

LOOK HERE

Latest blog posts

Resources for Learning Python

on November 10, 2015

I’ve been thinking about taking up a new programming language as a hobby for a little while. There’s a vibrant software community here in Portland, and working in more languages than TSQL opens up lots more opportunities for fun. I have no intention of becoming a full-time Python programmer, I just believe it’s fun to code and good to challenge your brain in new ways.

Continue reading

Are You a Woman in Tech Working with SQL Server? Join the SQLWIT Slack Channel!

on November 5, 2015

Update Nov 2021: This slack channel has been inactive for a bit of time now.

Are you a woman in technology that works with SQL Server or other databases? You might like to join our new slack channel - sqlwit.slack.com.

Continue reading

Taking the time to write about something makes you learn more

on August 24, 2015

You know how sometimes you learn something, then you start to see it everywhere you look?

Continue reading

How I learned to write TSQL

on August 17, 2015

I primarily work with SQL Server, but my favorite book on TSQL is the one that I learned with: The Transact SQL Cookbook.

Continue reading