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

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

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!

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

1. My New Crush: PowerPivot When it comes to R2, PowerPivot is the big charmer for me. It’s as much fun as my spiralizer, and that’s saying a lot. If you don’t know what a spiralizer is, it’s a magical little piece of plastic with a few blades that lets you turn a zuchinni into super long curly strands of veggie pasta, which makes it suddenly more than normal squash. You can also make curly fries, slice onions, and do all sorts of crazy cool things a normal person can’t make with an ordinary kitchen knife.

I have been plotting sessions that I’d like to present at SQL PASS for a little while now, and the June 5 deadline is approaching. Since I’m on vacation this week, I took some time to write up my abstracts. Man, oh man, that was more work than I thought! Condensing ideas into 1000 characters or less and still saying all you want to say isn’t as easy as it seems.

As for all posts on this blog, this post provides no guarantees for the tools described: use at your own risk, and make sure to test all functionality. This came to mind recently just because I wondered– is there any other free tool that does this better?

Times change, but some things stay the same.

This post is about a really little detail that isn’t a big deal.