Ember Crooks

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

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

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

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!"

I am exploring Mastodon. Join me or let me know your username so I can follow you. @ember" target="_blank" rel="nofollow noopener">hachyderm.io/@ember

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…

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

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.

@elonmusk 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/…

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 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.

@erwin_hattingh Mastodon looks interesting, but seems kind of shared with little communication between the shards. No idea what moderation looks like there, but appears to differ by shard. Also checking out counter social.

@ember_crooks I agree; let’s see and wait how twitter ‘evolves’, but it’s future doesn’t seem bright … 🤔 Mastodon seems a possibility ? but haven’t had a look yet. Or else, maybe less social media and it’s (negative) side effects.

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.

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?

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

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.

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.

@Db2_Whisperer @aweininger Interesting. What unit is the result in? Seconds?

@Db2_Whisperer I might once they announce dates and a location.

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?"