MSM

Nearly everyone either bought a new home or refinanced within the last 12-18 months due to historically low rates. This also means that almost all mortgages are pretty much capped out in terms of loan to value.

If houses lose 30% of their value, a substantial amount of people would be underwater and would likely be better off walking away. Could be very bad.

Yep. But looking at it as a shareholder, I don't think this should have been a negative.

Spending a lot of time to work with an individual client in order to make $1k-$2k or whatever they make ushering a loan over to fannie or freddie is not good business- especially during the recent market.

I see this everywhere but I can't see how it's true.

I'm guessing that a company's largest expenses are (probably in order, too): People, Technology, Office space.

Most companies, especially smaller companies, do not actually own the office space they are in, they lease it. Commercial real estate crashing would greatly reduce one of their top 3 expenses... how is that bad for the bottom line?

Him signing the check doesn't matter to me either way.

However, there's some irony in the fact that we got money, printed out of nowhere, signed by the previous president, and yet there are people that act like inflation is solely a "current administration" problem.

This administration has created a ton of money, but I also remember a previous administration going out of their way to literally put their name on the stimulus checks that were sent out following their trillions of dollars of stimulus passed...

I see statements like this a lot, and I have to say they don't compute to me at all. They are eerily similar to the "cancel culture" conversation that comes up whenever someone quits out of their own volition.

Who is forcing your wife to shut down her day care, and how? If a subset of parents are uncomfortable sending their kids to day care for the foreseeable future, just tell them to come back when they're comfortable. Did your wife forget that it's her daycare?

>Should we tell people to get their BMI under 25 too? >What about drinking and smoking?

There's a lot of investment in trying to fix these problems already, or at least offset the costs. For example, there are "sin taxes" for things like cigarettes and alcohol, which means smokers and drinkers are paying disproportionately more taxes than those that don't.

You could argue that overweight folks are also paying disproportionately more simply by buying more food than someone who weighs 20% less.

All that aside though- forcing fat people to get skinny isn't a valid comparison to forcing people to take a vaccine. One takes a couple minutes and the other is something requiring an hour or more of dedicated time per day for potentially years (or a whole lifetime!).

Let's say, hypothetically, there existed a free shot which would immediately make its recipient a perfectly lean 20 BMI and grants all the benefits of health and exercise without the work. How many people would choose not to take it, and how would society view those that decided to walk around weighing 400lbs? That's really the apples to apples comparison here, and I think you'd find there would be very few folks walking around at 400lbs in that scenario.

Think of the golfer as LeBron James and the caddy as an NBA analyst.

The analyst knows that a specific defender is weak when driving to their left, but the 43 year old 5'2" overweight analyst will never score a point against that defender regardless of how well he knows him. However, the analyst can feed that info to LeBron who turns it into an extra 3 points per game.

From the article "we’ll also share more details on an exceptions process for those who cannot be vaccinated for medical or other protected reasons."

I have no connection to Google, but I'm really, really, impressed that Google was okay with him sending these comics, internally, to upwards of 15 THOUSAND employees. Some of these are pretty scathing- drones in Google colors, the repeated suggestion (acknowledgement?) that the ethics are less and less of a concern, etc. If I posted something along these lines internally at my company, which I think is quite open in the grand scheme- I'd be out the door or given a stern talking to a minimum.

It does have some sugar, it's just very small amounts:

https://smartlabel.unileverusa.com/048001213487-0001-en-US/i...

I do wonder how the addition of a tiny amount of sugar, less than the amount of added salt, could even be noticed... let alone enough to request the "real" American version

What makes you think that it wasn't also happening during the last administration?

"Most" boys play some kind of sport. I have to assume it's the vast majority. My argument is that in those kids' lives, I would wager many of the authority figures that they spend significant time with and respect the most are men.

Blaming women as a whole makes no sense to me.

The only way that you can be surrounded by women for your entire upbringing is if you don't engage in sports. Sports are typically hours per day. Coaches are absolute authority figures, and there are very few female coaches.

I can't think of any men that never played sports but are somehow punished for being "so masculine"

The fact that the metric here is "Market Share" tells me that this is most likely a big nothing burger.

Market Share makes sense if you're talking about retail, or browsers.. but a static recurring payment? Why would Netflix care if a customer decides to also pick up another streaming service, effectively cutting their market share in half, while they keep full revenue.

There's a dozen+ streaming services out there that people have picked up, but in my personal experience, very few, if any, people I know have cancelled Netflix- they're just spending more and more money on streaming as time goes on.

Personally I never set up auto pay. Why? Because it hits a little harder (and you pay more attention) when you're actually typing it in every month.

Sure, there's a risk I might miss a payment and get dinged, but you're guarding against Comcast quietly raising your bill $25/mo, or not realizing how much you're truly spending on your credit card every month. Otherwise I agree with the list.

There are a number of countries with very high renewable usage that are in cold climates. Denmark comes to mind, where, on average, it's right around freezing for months at a time. Hell, they have turbines in the extremely corrosive oceans, getting blasted by freezing rain and they make it work.

Last I saw they got something like 50% of their power from wind.

Anyone who is using this event to say that renewables are a bad idea is selling a completely false narrative.

At many companies that's how you could define all the roles!

It's different depending on the company.

https://www.levels.fyi/ has a breakdown for some of the largest companies but I typically think of it as:

Eng -> Senior -> Staff -> Principal -> Distinguished

with my simple explanation being:

Eng - Able to contribute to the team

Senior - Expert on the team

Staff - Expert in your organization

Principal - Expert in your domain

Distinguished - ?? - Seems to be that you damn near created your domain. I only see these at the largest companies and a lot of times it's folks that have created popular programming languages or frameworks that the company themselves use.

Again though, the retail investors unload to who?

Everyone knows GME is over valued by an insane amount, who do people expect to be snapping up shares at $500?

Really depends on query complexity. Keep in mind that creating a CTE doesn't really materialize any of the resulting steps' data, it's just a way to encapsulate logic. Chaining together complex CTEs is effectively the same as creating layers of views, which can also be a performance problem.

In the case of a temp table, you're likely intelligently (manually) going through the process of whittling down the data to only what you need and in the most efficient ways possible. Maybe you're filtering by date upfront, then by some other filter, removing as many rows as is possible as quickly as possible. With the CTE(s), it might be creating a list of many filters with a lot of joins in one step, and the optimizer may not understand which filters can remove the most rows the most easily.

I have the same thoughts after reading it. In fact, the author expounds a little bit on your question later, saying:

"An October 2019 study on the mental well-being of crew, commissioned by a group affiliated with the International Transport Workers’ Federation, the big maritime trade union, found that even before the pandemic about a fifth of mariners surveyed said they had suicidal thoughts."

I'd be curious how the suicide rates compare to a non-pandemic year..

Regardless though, I feel like the juicy part of this article isn't the ~6 suspected suicides, it's how messed up the cruise ship companies are and how badly they botched communication in an attempt to cover their asses. They seem to be purposefully misinforming families about what happened with their loved ones. Some of these suspected suicides were found in their rooms and there doesn't seem to be closure as to what exactly happened. I can't imagine being in that situation.

EDIT: After looking into it, it seems like Spark calls both things predicate pushdowns (eliminating unnecessary row group reads via the statistics AND pushing the predicates down to the lowest possible level). You're right, I'm wrong!

>Parquet files contain min/max metadata for all columns. When possible, entire files are skipped, but this is relatively rare. This is called predicate pushdown filtering.

A nitpick, but I wouldn't call this predicate pushdown, it's partition (or segment) elimination. A predicate being pushed down potentially allows files to be skipped through this process though

I'll add to this that because AWS is simply piecing different technologies together under the hood, there are a lot of data type issues.

Another example is that some date/time columns got brought in and crawled as a string. That's a bummer because obviously you want to do native operations of these, datediff, datepart, etc. without having to cast all over the place. We manually set them to timestamp and they work perfect (awesome!), even in Athena, so we thought the problem was solved.

However, once we did anything with those columns in Glue ETL, those fields got set as nulls.

The problem can be fixed of course, but these types of issues happen fairly often and they quietly fail (no errors, just values set to null).

Seems like you're making this a little bit more political than you should be.

If I work for a bank and I find out they have predatory lending (and I had the luxury of being in demand), I'd likely threaten to quit unless that was changed. We see similar things with companies all over the US and it's not usually seen as employees "bawling their eyes out and chanting mantras".

Seems that because this particular instance involves some LGBTQ folks, you assume they're just walking around crying constantly...

In reality this will happen the same way every work place dispute has happened for the last hundred years. Spotify can either tell their employees "sorry, we're keeping it as-is, you can turn your badge in if you are against this decision" or find their employees too valuable and find some middle ground with JRE.

>Are they asymptomatic or do they have ground glass in their lungs? It can't be both.

I think you're under the assumption that this term was just created to fear monger about COVID, but this is not a new term.

From 2013 for example:

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4367726/#:~:tex....

Which, to me, really illustrates the astroturfing going on.

I can go months without ever seeing any reference to the Stasi and, in this single comment section, I see dozens of references? There have been plenty of similar programs through history but a bunch of "Americans" point to the same German group to illustrate their point? It doesn't add up at all.

I see these stats popping up when people express fear and it's crazy to me that we've hit the point where saying "Well, you probably won't even die!" is supposed to assuage concern.

Sure, I probably won't die if I get it.

I'd rather not be laid up in the hospital (or at home even, really), missing work and other important events as I accrue a larger and larger financial burden because of the US's expensive health care. And that's not even considering the impact this could have to my elderly family and friends.

S3 != a data lake.

If you're able to solve the problems that you were previously using oracle or SQL Server for with S3, more power to you, but the truth is that to replicate the functionality of that old Oracle server you'll start with S3, but you'll also want some querying (Aurora? RDS? Hbase?), probably some analytics and ingestion (Redshift? Kinesis? Elastic? Hive? Oozie? Airflow?), along with some security now that you've got multiple tools interacting (Ranger? Knox?), probably some load balancing (Zookeeper?), maybe some lineage and data cataloging (Atlas?), etc.

In my experience what starts with "Just throw some data in S3, forget that old crusty expensive server!" ends with 22 technologies trying to cohesively exist because each one provides a small but necessary slice of your platform. Your organization will never be able to find one person who is an expert in all of these (on the contrary, you can find an Oracle, or DB2, or SQL Server expert for half the money) so you end up with seven folks who are each an expert in three of the 22 pieces you've cobbled together, but they all have slightly different ideas on how things should work together, so you end up with a barely functioning platform after a year's worth of work because you didn't want to just start with a $400k license from Oracle.

Usually you'll keep the transaction logs for a certain period, say for two weeks. That gives you point in time recovery for any moment in that two weeks (assuming you've set up everything correctly!). Logs past that are usually archived or just dumped, but you'll have full backups that go back further.

For your question about the logs growing forever, there are usually points in the process where a transaction log is saved off somewhere else and then can be overwritten, but on a transactional system the logs over a period of a week or two can sometimes be many times larger than the actual data stored at any given time, yes.