Happy Surprises in Snowflake
As I’ve been learning about Snowflake, at least once a week, I find small things in the SQL or feature set that just make me happy. I really feel like Snowflake is meant for someone who loves SQL, but also…
Tag SQL
MySQL: Quotation Marks
My article on DB2 Basics: Quotation Marks has 962 views so far this year, so I thought it might be time to write a similar article on using quotation marks with MySQL. General quotation marks For the most part, you…
MySQL’s “partial” Group By
This is one area that was not a surprise to me coming from Db2 to MySQL, as I’ve had to deal with people confused in the other direction for years. Essentially, MySQL allows a syntax for GROUP BY that Db2…
Using ChatGPT to Write SQL
Working in technology, I’ve heard a number of things about ChatGPT from various news sources. I was particularly interested hearing some teachers saying it was the end of being able to properly detect students cheating when writing papers. Then I…
Comparing Db2 and MySQL: Naming Objects and Reserved Words
Every RDBMS has areas where the differences from other RDBMSes are noticeable, and this is one of them between Db2 and MySQL. Most RDBMSes have quirks to the way SQL is written, and this is certainly true of Db2 where…
Comparing Db2 and MySQL: Explain
The goal of this article is to to take one query and use the explain facilities of Db2 to walk through it, and then do the same with MySQL, and then show some of the optimizations I might make for…
Advent of Code 2021 in Db2 LUW SQL – Day 04!
Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 4. It’s…
Advent of Code 2021 in Db2 LUW SQL – Day 03!
Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 3. It’s…
Advent of Code 2021 in Db2 LUW SQL – Day 02!
Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 2. AOC…
Advent of Code 2021 in Db2 LUW SQL – Day 01!
Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 1. AOC…
Advent of Code 2021 in Db2 LUW SQL
This year, I’m going to be working through the Advent of Code challenges in SQL and sharing my progress here on the blog. I don’t expect to complete each challenge and the blog entries on them on the same day…
It Matters Where Your Join Clauses Go
Explicit Join vs. Implicit Join When writing SQL there are two places you can define how tables are joined. The first is explicit, and is specified after the the keyword ON in the join clause like this: SELECT * FROM…