Latest SQLComics

SQL Corgs Explain Inner Joins

on April 15, 2024

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

LOOK HERE

Awkward Unicorn Explains Database Normalization

on April 3, 2024

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

LOOK HERE

SQL Basics (SELECT, FROM, WHERE) with Freyja the Corgi

on April 1, 2024

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!

LOOK HERE

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

Latest blog posts

Coping with the Pandemic (T-SQL Tuesday #132)

on November 10, 2020

This post is part of the monthly TSQLTuesday blog event. This month’s topic is from Taiob Ali.

Taiob asks how are we coping amid the pandemic.

Continue reading

Down Tools Week 2020 (10 minute video/podcast episode)

on August 6, 2020

It’s Down Tools Week at Redgate.

In this episode, I share what “Down Tools Week” is, what I’m working on this week, and why I think it’s a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization.

Continue reading

Things That Shouldn't Be Normal in Database Development (28 minute video/podcast episode)

on July 30, 2020

Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development– but which are incredibly common.

Continue reading

Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)

on July 16, 2020

I’m not an expert on collation in SQL Server, but there are a few important facts which I’ve had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more.

Continue reading