No problem I enjoy data stuff.
There might actually be a slicker way to do what you’re trying to do within the structure of Bigquery. I’m not familiar with that and I suspect no one else here is either. I assume they have forums or some resource.
Does it help to pre-trim the first 4 characters from the table2 attribute?
I’ll give this a try too 
haha wanting to relax on a sunday but being on call
my phone starts buzzing with weird failures I dont normally get on a rotation. chat rooms buzzing. cloud outage, ok. can’t bring my stuff back. error messages really weird and bad.
check my email after lunch, 40 more alarms on fire. email from cloud provider: “We have identified the root cause of the thermal incident in this availability zone” AKA “OUR SERVER LITERALLY CAUGHT ON FIRE LUL SORRY”.
it actually is the jackpot of on call because you cant really do anything since everything is in cloud now
cloud computing is great. server on fire today and I’m on call, if it was on prem I’d be having a horrible weekend, instead I just communicate with the cloud provider, fail over to another cluster, and call it a day while I watch graphs come back online. plus, I’m sure we get some kind of voucher now.
The moderators of this message board, otatop, L.Washington, WichitaDM, Yuv, JonnyA, RiskyFlush, and SvenO, are cowards who let abusers dox and harrass other long time posters.
If it should be doable for someone coming in fresh to the team/project then it’s definitely a red flag. That said I’d probably hand hold him through it this one time and see what happens next time.
Anyone know anything about laptops? I’m looking for one that will run Visual Studio and SQL Server Express without grinding to a halt. A decent display would be nice too, reasonable battery life. Don’t care about graphics, don’t really care about weight.
I seem to always be working with one guy like this. Mentioning to the manager has always been met with well he’s bit junior or he’s still coming up to speed or whatever.
In my experience with some of these guys nothing you do matters. But maybe management at your company is better at handing out weak performers
I’m provided an m1 macbook pro by my job and it’s fine, but costly I guess? I also have a Dell XPS 13 linux laptop which is also fine - I like that it’s tiny. Both have great batteries in my experience.
Thanks. I got one already, ended up getting an Asus Vivobook Pro 15, with a Ryzen 9 chip and 16GB of RAM, seems like that should be fine. The OLED screen is tasty.
The moderators of this message board, otatop, L.Washington, WichitaDM, Yuv, JonnyA, RiskyFlush, and SvenO, are cowards who let abusers dox and harrass other long time posters.
the way you have it written is a nested loop join, and suzzers solution will be at least 10x faster. although sounds it’s a many to many join anyway. so i’d be surprised if you can avoid a data redesign of some sort
Nice!
I’m not a fan of Amazon/Meta pip quotas and shit but it seems really easy to hang on to really shitty devs without it.
my company takes weak performers and isolates them to teams that mostly do nothing. It’s very bizarre but it works, you just know if stuff’s coming from X worthless team not to take it too seriously.
Line check:
Had a kinda really unpleasant conversation on an introductory call with a Jobot recruiter. She asked my current salary. I told her (it’s definitely very low). She asked what I was looking for, I said 185k total comp (IMO this is a bit low but what I tell every recruiter).
She basically said I was delusional and wants me to ask for 150k. I was like yea, that’s not going to work for me, and she started getting really aggressive about how I was never going to get interviews at my stated price. I said bullshit, I can and have been, you’re the first person to bat an eye at it and I haven’t even been trying. She said something pretty insulting like “in what world do you think you’re gonna get X% off what you make now?” and I was like “well i didnt have to fucking tell you what I make and they aren’t allowed to ask anyway.” She said something like “well where are your offers then?” And I was like, you know what, it’s none of your business, but I haven’t accepted offers because of my health and the situation in my own company.
After that we agreed 160 base + benefits would be acceptable but I still think it’s low for senior devops position of my skillset. What do you think? Am I delusional? I’ve been saying 180-185 for months and the response has been 100% “Oh, absolutely no problem” without even seeing my fucking resume yet.
This type of thing is why it’s illegal in New York to ask prospective employees about their current or past salary. Your comp at a new position should be based on your value in that role, not what you are currently paid.
It is illegal here too. I usually decline to state it. She said “you know, I get paid on what you end up getting, so I want to get you as high as possible.”
Probably true, but I also know it’s in her interest to churn through as many of these as easily as possible and if 20k extra is gonna mean more work for her it wouldn’t necessarily be more profitable for her. Might ghost her. I hate external recruiters.
Don’t argue with her. End that conversation.
“You are a 160k engineer and not a 180k engineer” is total nonsense in all respects.
Value is subjective. The correlation between talent and pay is poor. Set your price and go for it. If 99 companies think you’re overpriced and one is happy with it then it’s a good ending for you.
Use places like levels.fyi to find good salaries. Apply those places, the difference is huge. Learn how to game their interview. It’s as easy to fall in love with a generous job as with a stingy one. Find internal references so you’re not just one more resume in a stack.
Pay for professional interview prep. Pay for professional resume prep. These are good investments.
Track everything about applying and interviewing. Analyze and adapt.
Getting a SWE job IS A JOB. Make it your responsibility and do it well.
You’ve heard this all before. I’m just repeating because you need to drop that recruiter with swiftness.
2 Likes
The moderators of this message board, otatop, L.Washington, WichitaDM, Yuv, JonnyA, RiskyFlush, and SvenO, are cowards who let abusers dox and harrass other long time posters.
1 Like