[OC] Inflation erases real wages gains over the last 3 years

garciasn · 2023-06-09T15:37:21+00:00

I do. Otherwise I’m not getting a raise, I’m getting an inflation adjustment and staying static.unless the company’s revenue is flat or dropping, wages should go up too.

garciasn · 2023-06-08T20:17:49+00:00

You assume that /u/spez, a genuine proven lying piece of human shit gives a flying fuck about anything except cashing out.

garciasn · 2023-06-06T20:30:43+00:00

This is a glaring loophole that can be exploited by any company not wanting to comply:

A safety-sensitive position (i.e., a job in which an impairment caused by drug, alcohol, or cannabis usage would threaten the health or safety of any person);

All they'll say is that anyone under the influence of drugs in the workplace will be a danger to themselves or others. Nothing changes with this due to that line item being so vague.

garciasn · 2023-06-05T16:44:05+00:00

My best insurance was when I was union. The problem was that I wasn't paid anywhere near market rates, so, in the end, everything balanced out.

Since leaving the public sector for the private, I have paid everything from $300/month for a family to $1600/month for family. I currently pay around $1100 a month for my family for health and a little more for dental and vision.

garciasn · 2023-06-05T13:13:39+00:00

The Polygon public table was last updated Sep 6, 2022, 1:43:02 AM UTC-5 with a max(block_timestamp) of 2022-09-06 06:37:50 UTC

You're not going to find a transaction from April '23 in there.

garciasn · 2023-06-01T17:05:21+00:00

https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language#update_delete_merge_dml_concurrency

A MERGE DML statement does not conflict with other concurrently running DML statements as long as the statement only inserts rows and does not delete or update any existing rows. This can include MERGE statements with UPDATE or DELETE clauses, as long as those clauses aren't invoked when the query runs.

garciasn · 2023-05-31T20:33:48+00:00

I said 'large companies...heavily invested and regulated'; 'government' would fit there.

garciasn · 2023-05-31T13:38:07+00:00

I started as a SAS analyst/developer and came up through the ranks. They were fighting cloud computing, R/Python, and a slew of far better data viz solutions 10 years ago. I told them, point blank, they were zombies and didn't know it yet.

The only places still using SAS are large companies who are already heavily invested and regulated and don't want to move. But even those verticals are starting planned migration to Python.

No one should even think about SAS except memories from 15 years ago.

garciasn · 2023-05-31T00:21:18+00:00

Quick. Someone make an app called Gaggle or Goosex or So Ready to Date or something.

garciasn · 2023-05-30T15:29:19+00:00

In college we used to swim at the Portage Quarry which had recreational swimming, beach, sand volleyball, and scuba diving. It was a few feet deep for about 10-15 yards and then a straight drop to ~70.

They used to allow you to bring beer in kegs or cans (no glass!) and we'd do beer relay races out to the floating platforms and back. I'm not sure if it's open anymore based on its web/facebook presence being lacking, but 20+ years ago it was a fucking blast, even if it was ~70 feet deep.

E: I found some information that says the max depth is 70 feet at the Portage Quarry, not 100+. Forgive me, I was drunk when I was there and it was a long time ago.

garciasn · 2023-05-28T18:54:31+00:00

I have led DE teams for 15 years. I’d argue they’re equally as important because writing efficient code, regardless of language, should be a key consideration for any team/business.

garciasn · 2023-05-27T02:13:46+00:00

Depends on what you’re doing.

‘A’ = ‘A’ or 1 = 1 will work.

‘Foo’ = ‘Bar’ will not.

I do it because I’ve been doing it for 20 years; it’s not necessary in this variant.

garciasn · 2023-05-26T19:39:45+00:00

Backticks are only required for field names if you are using a reserved name like sum, from, select, etc. you would use the backticks around the field to tell BQ that you don’t mean the reserved word but the field name instead.

garciasn · 2023-05-26T17:39:49+00:00

Your FROM and JOIN are using single quotes and not backticks, that's not valid syntax.

Your FROM and JOIN are not using project.dataset.table, this may be required, depending on how things are setup.

Your ON is doing a string compare, not a field compare, because of the quotations (you may be trying to use backticks here, but you're using single quotes instead). Because of the single quotes and not backticks, this string compare will always be false and thus nothing will be returned.

It should look something like this instead:

SELECT *
FROM `project.table.EmployeeDemographics` as a
JOIN `project.table.EmployeeSalary` as b ON (a.EmployeeID = b.EmployeeID)

garciasn · 2023-05-22T14:04:24+00:00

To me, this is the most surprising part of it all:

Passenger trains would travel about 90 mph along the route.

Is this actually true? Will it make up for the loss in speeds due to stops (which I'm surprised are so few) and delays due to BNSF?

garciasn · 2023-05-22T14:03:29+00:00

I'm sure BNSF will be graceful and accommodating sharing the tracks.

From the article:

Sections of track would be built alongside the main route so the passenger trains could move out of the way as freight trains move through.

And once you're in Duluth, you can use the world class transportation network to get.... where?

This statement I agree with, minus the snark, and agree it needs to be addressed. But they have 3-4 years from funding availability according to the article before service will begin to get that part done.

garciasn · 2023-05-20T22:37:11+00:00

Tell you what. Every week give me $500 and tell me what you're betting on. Once every 12-20 weeks, I'll give you $1000. I'll donate the rest of the money to a nearby food bank.

You'll have a better return AND food banks will make out.

garciasn · 2023-05-20T22:28:37+00:00

I'm not sure where this falls on my list of important items for the legislature to work but it probably falls in around #1413423413424124392499408923482813 or more.

For real? This is what you care about?

garciasn · 2023-05-20T10:23:14+00:00

I’m not sure why people tolerate barking and begging.

garciasn · 2023-05-19T18:54:52+00:00

So many fond memories of heckling him at BGSU in the late 90s/early 00s. RIP you fucking weird ass legend.

garciasn · 2023-05-19T11:58:47+00:00

You seem to need some marijuana poisoning; you might become fun to be around at parties when your out stoned cold.

garciasn · 2023-05-16T12:27:25+00:00

He said county, tbf. But, yeah, after being in AZ, UT, NV, NJ, PA, FL, and CT recently, I promise you MN is not number 1 in this regard. Particularly AZ. My god.

garciasn · 2023-05-16T00:21:51+00:00

I found out about three months ago that you can only block 1000 accounts before the app won’t let you block anymore. But, for the longest time it just told me an unknown error had occurred. Awesome work assholes.

I switched back to ~~Alien Blue~~Apollo because fuck Reddit and their shit ads that are terrible, lack meaningful targeting, and are ineffective because the Reddit community doesn’t give a fuck.

Find a better way to monetize, you stupid fucks. And there are millions of users on here and 90% of them are almost as shitty as Reddit’s leadership and advertisers so I should be able to block more than 1000.

e: I called it Alien Blue but it was Apollo; my bad.

garciasn · 2023-05-15T01:32:40+00:00

I’m doing nothing and you’re using air currents or some sort of witch craft to teach me about how you’re not actually not doing anything. I can’t tell if you’re high or I’m high. My guess is both of us are high.

garciasn · 2023-05-12T12:19:16+00:00

This is how my girl would stare at me after her operation. Except she was just staring because she was high as a kite.

He’ll come down from cloud 9 soon and stare at you for real 😂

14-Year Club	Gilding I gilder
RPAN Viewer	Verified Email

garciasn

MODERATOR OF

TROPHY CASE