by Ember Crooks | Jan 31, 2023 | Featured, mysql, sql
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 and most RDBMSes do not allow.… Read the rest
by Ember Crooks | Jan 26, 2023 | Featured, mysql, 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 heard a teacher...
by Ember Crooks | Jan 18, 2023 | cloud, data movement, DB2, Featured, Roll For DB, RollForDB
Alright, so I’m playing around with something. I’ve developed a bit of a TikTok addiction after exploring the platform to connect with my 14-year-old. One of the post types I’ve enjoyed is the “Roll for ______” type, where the content...
by Ember Crooks | Dec 6, 2022 | DB2, Db2vsMySQL, Featured, mysql, sql
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 some things were there before the SQL-92 standard...
by Ember Crooks | Dec 1, 2022 | data movement, DB2, DB2 Basics, Featured
One of the things that learning a new platform (MySQL) has taught me is just how critical the most basic topics are, so I thought I’d do an overview of how to get data out of a Db2 (on Linux, Unix, or Windows) database.… Read the rest
by Ember Crooks | Nov 8, 2022 | DB2, Db2vsMySQL, Explains, Featured, mysql, sql
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 the query and why.… Read the rest
Recent Comments