gregw2

44 ms·

481.
by gregw2 3y ago
Updates and deletes in ROLAP dimensional data models are usually performed via explicit ETL jobs, not triggers nor particularly update/delete cascading triggers. When a customer record is deleted in a source system, you typically do no
482.
by gregw2 3y ago
If you are scientifically-minded, I think you should consider how the second law of thermodynamics makes problems for your hope/assumption that AI can generate with equiprobability both good and bad outcomes. If you are monotheisticall
483.
by gregw2 3y ago
I don't know why this was implemented in MySQL's implementation but here's an example scenario where the general capability where you have a logical foreign key but not necessarily uniqueness in the pyhsical target. Pardon t
484.
by gregw2 3y ago
This paper, at least by my skimming, seems to describe Redshift's historic SERIALIZABLE ISOLATION level, but does not mention Redshift's newer SNAPSHOT ISOLATION capability. https://aws.amazon.com/about-aws/wh
485.
by gregw2 3y ago
For me, it's dedicated time focused on the subject area without operational distractions, a little more sticking your head out of your company and meeting other people with similar interests but much different contexts, and a chance to
486.
by gregw2 3y ago
At times like these, I'd imagine that deity wishes we were more proactive too... https://www.openbible.info/topics/being_a_light (Verses the parent poster may be referring to: https://www.openbible.info
487.
by gregw2 4y ago
I saw the project name and my first impression was gpt4 based. Having a pun or wordplay with an appeal to virtue doesn’t make it not misleading. It’s misleading. Rethink. How about calling it GPTJ4All which is more honest, or if you think y
488.
by gregw2 4y ago
Sorry for your loss. Been there, kinda. I got a job at IBM in the mid 90s. They sold the division to Loral before I started but I decided to stay in the position. Then congress cancelled the 2billion dollar contract. I was laid off before I
489.
by gregw2 4y ago
Thanks, makes sense. (Looks like the poster commenting about glibc has corrected themself.)
490.
by gregw2 4y ago
It’s not clear to me why the top rated reply which seemed extremely knowledgeable in discussing Linux kernel auto zeroing of memory mentioned a bunch of caveats including mentioning “some memory management libraries may reuse memory” but di
491.
by gregw2 4y ago
“Novel threat?!” Just “Errors?” You underplay this, however unwittingly. (Sorry for the long post here.) I lived in New York suburbs and had a firefighter friend who by his commanding officers was encouraged not to go down there (reasons un
492.
by gregw2 4y ago
Good question. I don’t have a poll but three observations. 1) People’s tastes vary. But millions of units have sold so people are open to it. 2) My non-techy 60+ year old aunt tried my Quest and kept raving about it and bought one. 3) It ha
493.
by gregw2 4y ago
…active well-funded regulation… …since a common anti-regulatory strategy is to strangle the funding…
494.
by gregw2 4y ago
You look at who got accepted to Harvard but didn’t go.
495.
by gregw2 4y ago
There are two types of funny. Ridiculous-funny and insightful-funny. And sometimes insightful-funny is confused with clever-funny.
496.
by gregw2 4y ago
Interesting. I'm curious if -- and to what extent -- these detection techniques overcome the techniques Scott Aaronson and Hendrik Kirchner are working on during Scott's sabbatical at OpenAI ( https://www.scottaaronson.c
497.
by gregw2 4y ago
How does Lume know what to fill in on the target table if a record effective end date isn’t in the source system but is a property of when the data was fetched? How does Lume know to update the record effective termination date of a target
498.
by gregw2 4y ago
The demo shows you transforming As-Is data to As-Is data. Is this a full refresh each time or incremental (do you have to tell it the incremental columns or can it "tell"?) Can you create audit timestamps in the target which track
499.
by gregw2 4y ago
re: "corporate clients, who get this stuff removed"... I am currently at a Fortune 100 company and only wish my IT department would keep up with / disable all the ways automated MS(N) news feeds keep cropping up via Edge and
500.
by gregw2 4y ago
i have been curious and thought about this topic in some form or another a fair bit, so I beg your patience with my long post. Karma points on HN are a psychological gamification to encourage posters to write good posts and avoid bad posts
501.
by gregw2 4y ago
Thanks! Can you detect deleted rows as part of that? Do you have support for the target table maintaining history via record effective and termination dates with a current record indicator, or do you just support maintaining current state a
502.
by gregw2 4y ago
More context, less favorable to the CTO (ie the company's side of the story): https://news.yahoo.com/tusimple-co-founder-resigns-internal-...
503.
by gregw2 4y ago
Is it a full refresh from the source each time, or is it incremental, and if incremental, what assumptions do you make or not make about keys, dupes, etc?
504.
by gregw2 4y ago
Why not buy a hedge? Their risk committee met 18 times. Because HoldForMaturity assets can't be hedged? Or it cuts into profit and affects your stock and management bonuses which they weren't used to giving up, and your share loss
505.
by gregw2 4y ago
The moral hazard risk you mention is real. But likewise no bank can rest easy for two reasons: 1) the lending programs setup to backstop banks (not depositors) in the current situation expire in a year. Not all the bank supports can be expe
506.
by gregw2 4y ago
She and the CEO sold a ton of stock in Dec 2021 and the bank risk committee met 18 times in 2022 so the writing was probably on the wall in Dec 2021
507.
by gregw2 4y ago
I get that a "true libertarian" (shades of "no true scotsman?") wouldn't want any of my suggestions about legislation and that private insurance is available (as my original post mentioned). I understand "liber
508.
by gregw2 4y ago
From a Libertarian perspective why would we not: 1) have Congress+FDIC create a new form of deposit insurance that goes up to 10-25 million dollars[1] that is to be used for a new form of account legally dedicated to payroll; funded by a ne
509.
by gregw2 4y ago
If taxpayers help wealthy depositors get more than their insured amounts, (and more than a normal liquidation of assets) that is a bailout It may or may not be the right thing to do, but it most definitely is a bailout.
510.
by gregw2 4y ago
Less discussed than Alaska, Texas uses it's oil money per its constitution to fund its university which seems pretty shrewd mitigation to the resource curse at a high level. Also no income tax for its citizens. Sample details: https:&

More ›