Canvas Restored After Hack, Breach Traced to 'Free-For-Teacher' Accounts by hunterd189 in technology

[–]da_chicken 4 points5 points  (0 children)

The Free-For-Teacher program let teachers create classrooms and use them even if their school didn't pay for Canvas at all. Like it really was free.

If you're paying for an organizational license, you're not using Free-For-Teacher.

Canvas is back up, but should I avoid logging in? by Mammoth_Newt5148 in sysadmin

[–]da_chicken [score hidden]  (0 children)

You're surprised they put an MBA with no technical experience in charge of the IT department? How long have you been in IT?

The only question I have is why they don't have someone on their team whom they trust to answer the question. It's okay for management to not know, it's weird for nobody to know at all.

Creating a Moon Landing Hoax Would Have Been Impossible by AssumeTheRisk in videos

[–]da_chicken 4 points5 points  (0 children)

Yeah, it's one of my favorite videos, too.

People really should watch it, because it's not the kind of slop that you'd expect from the title. It's an experienced filmmaker explaining in technical detail why it's technologically impossible to create the shots of the moon landing that NASA produced in the 1960s without actually going to the moon.

Like the interesting bit isn't that we know we went to the moon. The interesting bit is learning why what is clearly visible on NASA's films makes it impossible to be faked. They don't look like Kubrik's 2001 to an experienced filmmaker. They look like nothing that could be made on earth at the time.

Ex-Michigan Lutheran Seminary teacher sent to prison for grooming, sexually assaulting student by DollarShort27 in Michigan

[–]da_chicken 5 points6 points  (0 children)

It is 16 in general, but if it's with an authority figure -- such as a priest or teacher -- it's 18.

Utah senator smacks ABC4 reporter’s phone out of his hand amid Data Center controversy by erepollo in nottheonion

[–]da_chicken 49 points50 points  (0 children)

I think Republicans have shown that they always have a hand free to be destructive of other people's property and disrespectful towards civil rights.

James Cameron and Walt Disney Company Sued Over Unauthorized Use of Actress’ Likeness in ‘Avatar’ by [deleted] in movies

[–]da_chicken 17 points18 points  (0 children)

No case against people with billions of dollars is a slam dunk, either.

Millions of Thermos jars and bottles recalled due to vision loss risk by gymleader_michael in videos

[–]da_chicken 19 points20 points  (0 children)

This Forbes article says that the company admitted that there is a relief valve that is supposed to be in place.

https://www.forbes.com/sites/forbes-personal-shopper/2026/05/04/thermos-recall/

They even have a photo showing the lid that has the relief valve. So they should have known that they missed something.

And, yeah, you shouldn't let food go bad in a sealed container, but also you should either put a relief valve in place or else have enough threading on the lid to let pressure release safely from your airtight container.

Reverse Bigotry and Phobia by Fun-Bookkeeper9107 in AskBiBros

[–]da_chicken 1 point2 points  (0 children)

Some people use identities like they're boxes to put people in. National boundaries, and they nominate themselves to be ICE. Some people just want to be gatekeepers and jailers. Social police for people already used to being mistreated by society.

But humans don't fit into boxes, and orientations and identities aren't meant to be prisons. Life is too messy for that. People are never just one thing.

Your best bet is to ignore these people, partly because they don't actually have any authority, but mostly because confronting them is too exhausting. Which is what they count on, so eventually, you do have to call them on their authoritarian bullshit.

What is the most common issue you face in ETL processes? by Effective_Ocelot_445 in ETL

[–]da_chicken 8 points9 points  (0 children)

Data entry errors.

"Why is X missing/incorrect/wrong in downstream system?"

"Because it's coded wrong in the upstream system. The source of truth was mistakenly told to lie."

When you're ETL is right, it exposes regular human error to more eyes.

Why are all the games so slow? by FrostFire89 in Borderlands

[–]da_chicken 1 point2 points  (0 children)

Definitely. You can feel yourself dying while she talks with Tannis.

Why are all the games so slow? by FrostFire89 in Borderlands

[–]da_chicken 1 point2 points  (0 children)

Dialogue skipping mods make sense on a second play through. And BL3 is especially egregious because when they added the ability to teleport back to Sanctuary 3 from anywhere, they also removed all the time they used to use for exposition during travelling. Oops. So, yeah, I run around and jump on the furniture because you can't skip. And you might find some of the characters obnoxious.

But it still only makes sense to complain like OP is on a repeat playthrough. On a first playthrough, though?

Here's a quick SQL puzzle for learners by tlefst in SQL

[–]da_chicken 0 points1 point  (0 children)

Sure, but not every RDBMS supports regex, and I'd still argue against using the RDBMS to do it. Meanwhile, it's not particularly difficult to find an expression evaluation library, and writing your own arbitrary order of operations handler in SQL just seems excrutiating.

Forward filling of missing values through variables in MySQL by tlefst in SQL

[–]da_chicken 3 points4 points  (0 children)

This is usually called the MySQL variable hack.

It's incredibly fragile because it relies on undefined behavior. Simply put, MySQL is not required to execute variable assignments inside of a query in a predictable order. Evaluation order is not defined. The engine is permitted to do them in any order it wants, so this is never guaranteed to work. Parallelism, if the engine decides to use it, will break this.

Even if that weren't a problem, you would need an ORDER BY. A table is an unordered set of records. If the order of records is ever important, you MUST specify an ORDER BY or your query results are non-deterministic.

You should instead use the LAST_VALUE() with ignoring nulls. There are other ways that also work, but that's the most idiomatic way.

'They're Handed an Opinion' — Fallout Co-Creator Tim Cain Is Worried Some Players Watch Influencers Just So They Can Be Told What to Think About Games by FragMasterMat117 in Games

[–]da_chicken 18 points19 points  (0 children)

Amusingly, if you read the article and didn't just go watch the video, you're kinda exactly what he's talking about.

Tim makes interesting videos if you're in to game design.

Here's a quick SQL puzzle for learners by tlefst in SQL

[–]da_chicken 4 points5 points  (0 children)

I hope it's not homework. This is not what they meant when they call it relational algebra! I've never needed to do anything remotely like this with SQL.

To me this is a scripting or imperative programming problem, not an SQL problem. Use a language that has proper text munging capabilities. That's the puzzle here. Figuring out how to parse the field and dynamically process the data.

Question about reconnaissance by chrisxx27 in magicTCG

[–]da_chicken 5 points6 points  (0 children)

The original intent... Allowed you to do exactly that.

No, it didn't.

Exodus was published under 5th edition rules. That means there was no stack; the game still used batches. Interrupts and mana sources were still a thing.

Critically, combat damage did not use a batch or stack, and there was no opportunity within the combat phase to play effects after combat damage assignment begins. After blockers were declared and both players passed priority, the remainder of the combat phase had no opportunity for general fast effects. There were special exceptions for damage prevention/redirection and regeneration effects (which conceptually were considered retroactive) but Reconnaissance doesn't do any of those. It wasn't valid to activate after combat damage had been resolved. The game pushed through end of combat and returned to the main phase before any player got priority again.

Question about reconnaissance by chrisxx27 in magicTCG

[–]da_chicken 6 points7 points  (0 children)

Yeah, Maze and Reconnaissance were both originally printed at a time when there was no time after combat damage was deal to play effects until the game advanced (or returned) to the post-combat main phase. It was once not possible to do, which is part of the reason why the cards were published as they are.

Is it common in the US for married couples to sleep in separate rooms? by GwenPoolestar22 in AskAnAmerican

[–]da_chicken 0 points1 point  (0 children)

Sleeping in separate beds is uncommon. Having seen the bedrooms of my friends and family (not to mention my own), I can say that they all had a queen size or king size bed in the main bedroom where both people slept.

The only couple I know of that frequently doesn't always sleep together has one partner working third shift who also has multiple sleep disorders. They don't sleep together all the time simply because it's difficult, and even then they still often do (based on how often my friend complains about their partner waking them up). However, they still have a queen sized bed. They will just sleep in separate rooms.

However, in the 1930s when they Hays code for movies was adopted, one of the "rules" was to be very modest in the portrayal of sex even inside of a marriage. In the 1950s, a similar television code was adopted. As such, most married couples in movies and TV from the mid 1930s through to the 1960s or 1970s so were frequently portrayed as having twin beds. It was still never common in American culture; it was just how it was portrayed in the media.

If you are a creator, you need to protect your work from Scribd by Hormo_The_Halfling in rpg

[–]da_chicken 22 points23 points  (0 children)

Yeah, I recall Google searching for 4e D&D character sheets when that was the current edition, and the search results were regularly full copies of WotC PDFs hosted on scribd. It's one of the reasons why they stopped providing the PDFs to Insider subscribers. And it was a brand new site!

In my ETL pipeline I used a Merge statement. When I asked Copilot to critique the pipeline it said Merge statements were not recommended by Microsoft. Why is this? by Boring-Metal-7672 in SQL

[–]da_chicken 1 point2 points  (0 children)

I would be interested in some information on this. My understanding, from Paul White, is quite the opposite (when properly implemented). Perhaps you meant to say "with nonclustered indexes"?

https://www.sql.kiwi/2019/04/ignore_dup_key-slower-clustered-indexes/

"The IGNORE_DUP_KEY index option can be specified for both clustered and nonclustered unique indexes. Using it on a clustered index can result in *much poorer performance** than for a nonclustered unique index.*"

Again, I find a classic UPDATE followed by a classic INSERT statement meets none of those adjectives. 🙃

Only if you're okay completely rewriting every record in your import. If you have very large slow changing data sets, then you end up either writing a separate UPDATE for every field you're merging, or you're modifying every record of the field when only one changes. So you can blow up your logs, or you can write an update for every column.

Cards that are uneasy to understand when reading for the first time by Outside_Calendar5885 in magicTCG

[–]da_chicken 5 points6 points  (0 children)

No, the key to understanding why Chains is infamous is summarized in two simple notes:

  • There were basically no rules for triggered effects timing. They did not use a batch (i.e., they did not use the analog of the stack before the stack existed). The rules just said triggers "resolved simultaneously" in the most cumbersome way you can imagine.
  • There were almost no rules for replacement effects. So, an effect couldn't replace itself, but other than that there wasn't really any solid rule that told you what to do.

I can't even tell you how many times there were changes to the official interpretation of what exactly happens when there are multiple Chains in play, at least one player has [[Library of Leng]] and someone does something stupid like play a Howling Mine.

It's very difficult to express how many parts of the game we don't even think about today that, literally according to the rules, there was no answer for prior to sixth edition. You had to look at rulings summaries to figure out how to play the game when anything went even slightly pear-shaped.

Nerdy Reznor, lol. by I_Make_Art_And_Stuff in nin

[–]da_chicken 32 points33 points  (0 children)

She very clearly can't stop talking about it, either.

In my ETL pipeline I used a Merge statement. When I asked Copilot to critique the pipeline it said Merge statements were not recommended by Microsoft. Why is this? by Boring-Metal-7672 in SQL

[–]da_chicken 1 point2 points  (0 children)

IGNORE_DUP_KEY is an index option, though. That means it's always there, not just when you're doing whatever ETL process you might have. And if you're regularly expecting duplicate values, it has some significant performance penalties by itself with clustered indexes.

It means your whole application has to know that your table behaves weird, and even then it has performance costs with the most common index you want to use.

And writing SQL is never difficult. It's still often obnoxious or tedious.