Aaron Morelli @sqlcrossjoin

The Eternal Gospel cross join'd with a 20+ year old product from Microsoft. sqlcrossjoin.wordpress.com Portland, OR, USA Joined April 2012

Tweets

500
Followers

102
Following

24
Likes

28

Aaron Morelli @sqlcrossjoin

3 months ago

@erikdarlingdata anyways, thx

0 0 0 15 0

View Details

Aaron Morelli @sqlcrossjoin

3 months ago

@erikdarlingdata E.g. Paul's side-effecting scalar function trick or when that "distinct aggs considered harmful" opt breaks down...

1 0 0 13 0

View Details

@erikdarlingdata, seems like a good day to ask the SOTU on how the latest Claude Opus handles advanced query tuning challenges, where the right answer is some obscure technique described only on top-end blogs (your/Obbish, Paul White's, etc)

1 0 0 44 0

View Details

Aaron Morelli @sqlcrossjoin

3 months ago

@erikdarlingdata Understandable, tho I was asking b/c that LLM ability/inability represents the gap between your skillset and a bright/persistent non-specialist trying to figure out a tough tuning problem

1 0 0 32 0

View Details

Aaron Morelli @sqlcrossjoin

5 months ago

@erikdarlingdata @sqL_handLe Just below your thread in my feed:

0 0 1 45 0

View Details

Aaron Morelli @sqlcrossjoin

7 months ago

@erikdarlingdata So is Keynes the "you don't need a DBA" platforms (Snowflake)? Or Larry Ellison?

1 0 0 37 0

View Details

Aaron Morelli @sqlcrossjoin

8 months ago

@SQL_Kiwi @erikdarlingdata (Win11 sucks on my dated laptop so I'm wiping and putting XFCE Linux on it and playing around with some open source DBs... but would still love to experiment with my fave DB)

0 0 0 96 0

View Details

Aaron Morelli @sqlcrossjoin

8 months ago

@SQL_Kiwi do you know if the optimizer code and behavior is essentially the same on Linux containers? (Not that you'd ever waste time on that :-) ) As in, if I follow along with your and @erikdarlingdata 's blog posts, should I expect to see the same things?

1 0 0 74 0

View Details

Aaron Morelli @sqlcrossjoin

8 months ago

(I'd been watching some old Paul Randal Pluralsight courses and he demonstrates a tail-of-the-log backup when the MDF has been deleted, and I got curious if ChatGPT would get this right. No. It just lost your user data pursuing forensics... )

0 0 0 20 0

View Details

Aaron Morelli @sqlcrossjoin

8 months ago

I know we're all using the cloud now so this doesn't matter anymore (:-P), but ChatGPT does not understand tail of the log backups: chatgpt.com/share/68fbd09a…

1 0 0 14 0

View Details

Air Katakana @airkatakana

8 months ago

the korean government lost all of its data, because it put all of its servers in one physical location with no backups

Air Katakana @airkatakana

8 months ago

the south korean government placed all of the servers for hundreds of critical government services in one physical location a single battery setting on fire brought all of them down. it has been a week and only 15% of services have been restored

46 169 2K 1.5M 223

885 3K 30K 2.0M 5K

View Details

Aaron Morelli @sqlcrossjoin

10 months ago

@zodiacon Haha, looking forward to it! :-) Thanks for the reply!

0 0 1 28 0

View Details

Aaron Morelli @sqlcrossjoin

10 months ago

@zodiacon I'm looking at purchasing all 4 of your books off Leanpub; are any of them going to receive a new edition soon that I should wait for?

1 0 0 51 0

View Details

Aaron Morelli @sqlcrossjoin

a year ago

@erikdarlingdata @SQL_Kiwi This is confirming my theory that the prime audience of these apps are dudes like me who are not only middle-aged, but also over-the-hill and feeling it.😆

0 0 0 133 0

View Details

Aaron Morelli @sqlcrossjoin

a year ago

@SQL_Kiwi @erikdarlingdata , random Q, but do either of you use "PKM" (Personal Knowledge Management) tools for managing the vast amounts of obscure details you accumulate in your careers? (e.g. Logseq, Obsidian, Roam Research)