Ember Crooks

Passionate data blogger ( Mastodon: Opinions are my own. she/her/hers

[Ember Crooks @ember_crooks]

That's it, no more Twitter for me. Come find me on Mastodon at @[email protected] or on LinkedIn at https://t.co/S5jZ4LCHMP

[Senior Oops Engineer @ReinH]

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

[Ember Crooks @ember_crooks]

Comparing Db2 and MySQL: Explain https://t.co/zhwiBoIRJG

[Joseph Scrimshaw @JosephScrimshaw]

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

[Ember Crooks @ember_crooks]

I am exploring Mastodon. Join me or let me know your username so I can follow you. https://t.co/FYJP28YrDM

[Modern SQL @ModernSQL]

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.

https://t.co/IX4Z6fyW37

[Mike Krafick @MKrafick]

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. https://t.co/3RmuN7ZlZJ

[Carolyn Porco @carolynporco]

@elonmusk False dichotomy.

Should be:

. Freedom of speech w/ no accountability
. Responsible freedom of speech

[Ember Crooks @ember_crooks]

Comparing Db2 and MySQL: NULL in Indexes https://t.co/iMXmpqDjX9

[Mike Krafick @MKrafick]

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.

[Ember Crooks @ember_crooks]

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.

[Ember Crooks @ember_crooks]

@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 @ember_crooks]

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.

[Laurie Voss @seldo]

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?

[Ember Crooks @ember_crooks]

Comparing MySQL and Db2: Table and Index Structure https://t.co/yDXHWuaUPc

[Ember Crooks @ember_crooks]

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.

[Ember Crooks @ember_crooks]

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.

[Ember Crooks @ember_crooks]

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

[Ember Crooks @ember_crooks]

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

[Ember Crooks @ember_crooks]

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