Aaron Morelli
500 posts
Aaron Morelli
@sqlcrossjoin
The Eternal Gospel cross join'd with a 20+ year old product from Microsoft.
Portland, OR, USA Joined Nisan 2012
24 Following108 Followers
@erikdarlingdata E.g. Paul's side-effecting scalar function trick or when that "distinct aggs considered harmful" opt breaks down...
English
@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)
English
@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
English
@sqlcrossjoin i don't use it for that. i use it to do things i either can't do, or don't want to do.
English
if you’re not an alcohol delivery service
you’re just not worth my time…
cc @erikdarlingdata
T. Bernadetti@MrsRoyKeaneo
My new "ring door bell" song. Turn it up!😂
English
@erikdarlingdata So is Keynes the "you don't need a DBA" platforms (Snowflake)? Or Larry Ellison?
English
@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)
English
@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?
English
(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...
)
English
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…
English
Aaron Morelli retweeted
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
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
English
@zodiacon Haha, looking forward to it! :-) Thanks for the reply!
English
@sqlcrossjoin No... the next book is going to be brand new :)
English
@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?
English
@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.😆
English
@SQL_Kiwi @sqlcrossjoin I use Paul. Very reliable and easily plied with alcohol.
English
@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)
English
i know that i am a comparatively small fish in the grand scheme of things, but i am still quite taken aback by the number of data darlings the darling data youtube channel has amassed. a sincere thank you to everyone who has 👍 and 🛎️ over the years.
English
@SQL_Kiwi Microsoft really went all out in supporting NZ's 2007 time zone change, didn't they?!
A dedicated blog: learn.microsoft.com/en-us/archive/…
English
Judging by your "career in information technology", you both are the same guy. :-)
darrylburling.com/about/
English
@darrylb I was browsing through archived MSFT blogs, hit this, and thought "what are the chances?"
learn.microsoft.com/en-us/archive/…
English