100 Things I Hate About Views: Undeclared Data Types in Columns
Views let you do dumb things by accident in SQL Server. Then they make you have to think way too hard to fix them.
By Kendra Little on March 14, 2025
Views let you do dumb things by accident in SQL Server. Then they make you have to think way too hard to fix them.
By Kendra Little on March 10, 2025
“Is it just me, or is SQL Server quality slipping?”
I asked myself that question for couple/few years until I faced up to it: SQL Server is well into a period where Microsoft investment is waning, and Microsoft regularly isn’t able to deliver the features they promise.
By Kendra Little on March 2, 2025
I listened to “Surviving the A.I. Endgame” this weekend and realized: I’ve become one of the believers that AI advances are very likely to completely change tech and knowledge roles as we know them over the next 10 years. This is going to dramatically shrink the workforce across MANY roles (and many of those impacted will be outside of the tech sector). It isn’t that people won’t be needed anymore, but far fewer people will be needed.
By Kendra Little on February 13, 2025
SQL Server’s free state-based version control tooling was introduced under the “Data Dude” brand, then became known as “SQL Server Data Tools” (SSDT). Its extension for the (now dying) Azure Data Studio IDE is called “SQL Database Projects.” If you need to find documentation, you often need to know to search for specific component names like SQLPackage.exe, which is a command line utility used to deploy SSDT Projects AKA SQL Database Projects.
on April 15, 2024
Joins are essential. The SQL Corgs introduce you to INNER joins in this animated short.
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.
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!
on March 28, 2024
I learned to make short form videos with my drawings this week, and, well… things are about to get weirder.
Copyright (c) 2024, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.