Sqlcomics

Joins are essential. The SQL Corgs introduce you to INNER joins in this animated short.

Take Me There

Why do we “normalize” relational databases, and what are the basics? Awkward Unicorn explains, with a little help from their friends.

Take Me There

Freyja the corgi shares her tips for learning SQL: SELECT, FROM, and WHERE.

Now that I’m getting the hang of this, I think I’m going to do a whole series of shorts on SQL syntax essentials, plus tips and tricks!

Take Me There

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

Take Me There

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

Take Me There

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

Take Me There

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.

Take Me There

Most modern hardware supports RCSI and Snapshot isolation beautifully.

Take Me There

Indexed views are amazing: they’re like an auto-updating table based on the definition of the view. Whenever rows change in the tables defined in the view, those changes are also applied to the indexed view.

Take Me There

SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking.

Take Me There