Division Notation xkcd.com/2687/ m.xkcd.com/2687/

Collecting metrics in a hybrid or cloud or container environment can be challenging. Speedgain for Databases now can collect operating system metrics from the database itself, no need for extra access to operating system level anymore. #Db2 #dba #SQL #tuning #cpu #ram

One of the things that amazes me about learning #MySQL is that I'm learning more about #Db2 in the process. So many "I wonder how Db2 does that?" and "Db2 doesn't do that, does it?"

Differences between #Db2 and #MySQL: using `CREATE TABLE X LIKE Y` in MySQL includes creating the indexes on Y. In Db2, the indexes are not created on Y.

Differences between #Db2 and #MySQL: in Db2, index names must be unique within the DB (or tenant). In this context, a Db2 DB is roughly equivalent to a MySQL server instance. In MySQL, index names only need be unique for that table.

Comparing MySQL and Db2: Table and Index Structure datageek.blog/en/2022/10/27/…

Is there some cognitive-science reason why if you finish a talk and immediately ask "any questions?" nobody will have any but if *one* person asks a question you will immediately get five more?

It sure feels like Twitter is about to become a toxic cesspool, particularly for women. Where are people going instead for technical community content and connection? Already on Reddit, LinkedIn, and the #Db2 discord. Not about to use Facebook for non-personal stuff.

The thing I miss most about #Db2 while working with #MySQL : the Db2 optimizer and Db2's explain. This is not a surprise - it was what I expected with switching platforms.

Learn from my fail. Archiving #Db2 logs directly to #aws S3? Watch your archive log directory after restore to another server or into another DB. Could be writing logs where you don't want to.

The reason unions are badass is if a billionaire walks into your office and starts demanding you work 12 hours a day 7 days a week to prove to him you deserve your job, you and your coworkers can legally make that one of the worst days of his life.

Elon Musk False dichotomy. Should be: . Freedom of speech w/ no accountability . Responsible freedom of speech

Comparing Db2 and MySQL: NULL in Indexes datageek.blog/en/2022/11/03/…

Have #Db2 in a #k8s managed environment? Did you notice the #rhel Kernel parameters are not persistent? May need to make code adjustments for the optional ones not managed by DBM to make sure they load on reboot. tinyurl.com/mr2v992u

Generated columns are a barely known but surprisingly well-supported SQL feature. Their main use is to put constraints (and indexes) on values derived from other values of the same table row. modern-sql.com/caniuse/genera…

I am exploring Mastodon. Join me or let me know your username so I can follow you. hachyderm.io/@ember

Daylight Saving Time is increasingly hard to notice when my digital are devices are like, "What? Nothing happened. We know what time it is." And my stove is left blinking and screaming, "IT HAPPENED! TIME SHIFTED UNNATURALLY! THEY'RE ALL LYING! ONLY I KNOW! ONLY I REMEMBER!"

Comparing Db2 and MySQL: Explain datageek.blog/en/2022/11/08/…

SQL's booleans are TRUE, FALSE, or a secret third thing

That's it, no more Twitter for me. Come find me on Mastodon at @[email protected] or on LinkedIn at linkedin.com/in/ember-crook…