Aaron Morelli

The Eternal Gospel cross join'd with a 20+ year old product from Microsoft.

[Aaron Morelli @sqlcrossjoin]

@erikdarlingdata anyways, thx

[Aaron Morelli @sqlcrossjoin]

@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)

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

@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

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

@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)

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

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:

https://t.co/AomZKQq4W1

[Air Katakana @airkatakana]

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

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

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

[Aaron Morelli @sqlcrossjoin]

@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)

[Aaron Morelli @sqlcrossjoin]

@erikdarlingdata Well deserved!

[Aaron Morelli @sqlcrossjoin]

@SQL_Kiwi Microsoft really went all out in supporting NZ's 2007 time zone change, didn't they?!
A dedicated blog: https://t.co/ys34EDDhG3

[Aaron Morelli @sqlcrossjoin]

Judging by your "career in information technology", you both are the same guy. :-)

https://t.co/4J8ZWayIRd

[Aaron Morelli @sqlcrossjoin]

@darrylb I was browsing through archived MSFT blogs, hit this, and thought "what are the chances?"
https://t.co/vavFIOA1eI