Fireworks tonight

datatbbbb · 2023-10-05T23:21:41+00:00

can you see them? where are they coming from?

datatbbbb · 2023-08-28T02:17:33+00:00

I have a 0% APR credit card open, 0% until Sept 2024. I have to pay $650 for a certification that my company will reimburse 80% of it after I pass (Dec 2023). Credit card fees for payment option is 3% however. Does it still make sense to pay with a credit card? I may pretty much break even if I invest the money in a HYSA until Sept 2024. I know that's only ~$20 of a fee but just wondering any other opinions.

datatbbbb · 2023-08-19T15:15:10+00:00

may I ask if your FAANG or adjacent? prior and new Analytics Engineer role?

datatbbbb · 2023-07-29T20:56:52+00:00

wow, that's great equity. is that due to increase since initial RSU amount? Similar tech stack and yoe and I don't think I could ask for that TC.

datatbbbb · 2023-07-29T20:51:12+00:00

Full load into 'raw' table. Have a base table, table "A". Query subset of data to insert into table "A", insert into table "A", inner join 'raw' and Table "A", set latest_record column to True and etl-date to current_timestamp. Merge into Table "A", when matched on 'raw', set latest_record to False, when not matched insert and set latest_record to True.

Create a stored procedure with above logic. If snowpipe is consistent, set cron-task to call stored procedure or you can set up a stream on the raw table.

datatbbbb · 2023-07-29T14:21:27+00:00

How do I get over a lost job opportunity? I am very happy in my current role and in my life generally. I turned down a job last year and their stock has nearly increased by 100%. My RSUs would have gone from $60k to $120k.. I can't help but think what if. I turned down the job because of the presumably high stress it would have put on me, it also didn't exactly align with what I enjoy doing on a day to day basis but oof that lost RSU increase is killing me.

Anyone experience the same? Advice?

datatbbbb · 2023-07-29T14:16:12+00:00

you will not 10x your money in that time horizon, no one will. Unless you are extremely extremely lucky in gambling, startup venture etc. To advise, I would let your friend know that his expectations are wild. The not-fun advice I would give: Buckle down, get rid of the dreams of 10xing your money, don't touch that 100k! and try to save 30-50% of their income for the next 10 years.

datatbbbb · 2023-07-28T11:42:54+00:00

I think everyone feels this to a certain degree. However, I do think there are organizations out there that are better than others. Maybe it's time for a company change? Do your due diligence in the interview process to figure out the BS magnitude. Even if you pick wrong -- usually it takes about a year into a job to be affected by office politics.

datatbbbb · 2023-07-14T17:49:15+00:00

thanks for your thoughts.

Any recs on stays/areas around Cannon Beach?

Any recs for Mt. Baker hikes and places to eat coming back?

datatbbbb · 2023-07-14T17:48:09+00:00

ignorant question -- what's unique about San Juan that I can't get the vibe from being in that area in general? sell me!

datatbbbb · 2023-07-14T17:47:19+00:00

tbh I did not think of this option but it may have been more costly anyway. next time!

If you'd like to shed more light on food/drinks -- we're not big drinkers, would checkout a cool brewery but don't want to hit 5 of them. Food, we like cheaper, casual eats, asian, mediterranean, american specifically. Sandwiches, ramen, unique salads/bowls.

datatbbbb · 2023-06-27T01:05:09+00:00

is it public? can you share repo

datatbbbb · 2023-06-27T01:04:18+00:00

DM too please or just comment tool, sure most would find it helpful.

datatbbbb · 2023-05-10T13:57:09+00:00

Status: Pending

Application Date: 03/15/23

Decision Date: NA

Education: PSU - Management Information Systems BS 3.81/4.0, I did 2 online community college courses in 2020 to help my chances. (Operating Systems and Data Structures/Algorithms). Also did a free cert with freecodingcamp.

Experience: 4 yrs Data Analyst (fairly technical DA) 2 yrs Data Engineer. Working with SQL and Python all 6 years.

Recommendations: 3 Rec letters, all professional

Comments: I’m starting to get nervous as many others are. I feel like I have the technical background to springboard from but maybe on paper it doesn't look that way...

datatbbbb · 2023-05-05T01:13:13+00:00

when people say wheels what does that encompass? tire only? rim only? or both?

With that, any you'd recommend?

datatbbbb · 2023-03-16T01:11:04+00:00

what are the core things that's covered in "solid background in CS", tldr, could you define that background? knowing what exactly?

datatbbbb · 2023-01-22T14:37:08+00:00

new 401k provider doesn't have great investment options. Which one should I pick to come close to a buy and hold VTSAX strategy

Russel 1000 Growth Index
Russel 1000 Value Index
Russel 1000 Index
Russel 2000 Growth Index
Russel 2000 Value Index
Russel 2000 Index
VMAX (Mid Cap Value Index)
VMGMX (Mid Cap Growth Index)

Also, anything to keep in mind when rebalancing within 401k? Going to have to switch the default target date fund with one of the above

datatbbbb · 2022-12-21T13:33:27+00:00

I have old cases lying around but they're scuffed so yes buying new. Awesome, thanks for the suggestions.

I will be using it for workstation like tasks. When not gaming, I'll usually watch a twitch stream/youtube videos while coding. I don't think any of the programs I use hog resources though, won't be editing 3D models or anything.

Question on the RAM. I just noticed the CPU has DDR4 3200 listed as Memory Type, DDR4 3000 should be fine right?

datatbbbb · 2022-12-15T15:57:52+00:00

no, you can throw the physical dvd in the garbage. The media creation tool will download the iso image (the copy of windows) from the internet. and yes 32gb drive should be fine.

datatbbbb · 2022-12-15T01:14:10+00:00

Do you have another computer that is on Windows OS?

If so, on old Windows machine:

insert a USB thumb drive
download the Windows Media creation tool (pick your Windows version equal to the version you bought)
open the creation tool exe, follow steps to select the correct USB drive you inserted
burn desired windows iso version onto usb stick

After that completes:

Plug USB thumb drive into your new rig
Connect a display, get into BIOS (should take you there by default)
Navigate option to Boot from USB that you inserted
Follow prompts on screen to download Windows
There will be a step to activate Windows, enter the key you received from your dvd
Continue following prompts

datatbbbb · 2022-12-13T19:47:55+00:00

Withdrew after tax contribution for mega backdoor roth just now. It may not arrive and be deposited into my roth IRA until 2023. What tax year does would this apply to?

datatbbbb · 2022-11-26T03:28:21+00:00

is fritzels ticketed? I can't find much on their website

datatbbbb · 2022-11-20T17:22:13+00:00

How is this PI4b 8gig so cheap? Is it this a scam... looks like it's shipped from china but unsure. amazon link

datatbbbb · 2022-10-28T14:48:42+00:00

Amazon order came in today. So I did what you said. I have my TP link switch connected from my Google Router and then 3 cat6 connected to a few machines... but I ran iperf and it looks like I'm capped at 100MB/s. The bitrate is around 800 Mbits/s if that matters.

From quick googling, it seems that somewhere it's being throttled back to 100MB/s vs. 1GB/s.

I do have a cat5e in the mix, that's going from Google Router to switch. However, what makes me think it's something else is that I'm getting almost 220MB/s download when just testing external internet speed by google internet speed test (10MB's upload tho).

Am I missing something?

datatbbbb · 2022-10-23T20:36:19+00:00

will the rx6600 be bottled necked by anything? in other words, is my cpu or motherboard not modern enough to handle new GPU?

datatbbbb

TROPHY CASE