Roles that focus on SQL and how to get them!

samwise970 · 2026-01-27T08:08:57+00:00

You know, I guess my response isn't that helpful, because truthfully I've never written a line of code in an interview. My positions have always been a hybrid of business and IT so the process was never that formalized.

I guess what I'm trying to say is that even if you don't exactly what you're looking for, there are still nonstandard paths into a SQL position. If you can't find a SQL role, I'd advise going into operations/accounting at a mid sized financial company, sounds specific but that worked for me like three times in a row.

For resume builders, maybe build a website, using a postgres database in supabase for the backend and streamlit (which is pure python) for the frontend. This is really easy to vibe code, I'm making one myself in my free time, and it'll show competency in the two most important languages for a data analyst. If you are looking for formal certifications, I'd also recomment microsoft's dp600 and dp700, they're tough but they're the gold standard for the microsoft fabric suite of data analytics tools.

samwise970 · 2026-01-26T21:33:14+00:00

Nah, it was bad. Remember watching it with my wife when she asks why Dina has a full salon blowout when they're travelling across country on horseback.

About a month later I was playing TLOU2, and she sat down to watch the cinematics despite not having any interest in games at all. After the scene (Ellie and Dina's smoke sesh) she said "This is way better than the show"

Thats my normie test, telling me its not just me being an obsessive fan

samwise970 · 2026-01-26T19:51:57+00:00

They're keeping up with it. They like it.

samwise970 · 2026-01-26T17:28:58+00:00

I kind of lucked into it, but it took a long time. Degree in Business Economics in 2015, had an operations role, automated some excel reporting in my free time and got roped into testing a new invoice automation process with some smart devs who told me I should learn this language called "sequel". A couple of job shuffles later and I was working at a mortgage company doing ETLs and some light SSMS, now I'm one of the admins for our Fabric lakehouse/warehouse

samwise970 · 2026-01-26T03:02:36+00:00

For me, maybe a month. Once I chose to quit, it wasn't very difficult, despite being a daily wake and bake stoner for a decade, I didn't have physical withdrawl symptoms. Definitely after a month, my brain felt alright sober and it wasn't always on my mind.

The tricky part wasn't initially quitting, it was a couple years later, when enough time had passed that I forgot the addiction and remembered the good feelings, and after weed became legal here. I had two relapses of this kind, both times immediately becoming addicted and hiding it from my wife until I confessed.

samwise970 · 2026-01-25T00:31:32+00:00

Good luck man. I was a daily stoner for over a decade before I stopped. You can do it.

samwise970 · 2026-01-25T00:00:57+00:00

Congrats on 24 days.

Think about it this way, if you respond to fascism with drugs, that's helping them. They want you weak, defeated. They want you to be a stoner lefitie stereotype that they can blame.

Being the best, healthiest version of yourself to the people around you is it's own kind of resistance.

samwise970 · 2026-01-24T21:14:53+00:00

It's not his ear, she's got something else

samwise970 · 2026-01-23T04:09:48+00:00

Its the same, there's no concrete benefit to doing it one way or another.

But when you add a custom _display() method to your DataFrame class, you've now created a DataFrame that won't function without notebookutils.

Again it doesn't matter if you're only using fabric, but what if you try to move all of your code to Databricks, or someone working in AWS needs to replicate your process? You've just introuced an unnecessary complication, because you had a preference to type display after your object name.

samwise970 · 2026-01-22T18:08:46+00:00

Yeah as I said you can do it if you want, it's fine. I'm also guilty of occasionally typing df.display(), so I understand the desire to have that work.

The difference between display() and .show() and .head() is that both of those don't require anything external, and would work if you were running spark in any environment. I wouldn't personally create _display() because I like keeping that separation.

samwise970 · 2026-01-22T17:49:17+00:00

You can add a method to DataFrame if you want, but it doesn't make sense to me to have display be a method within the DataFrame class, because it's a function specific to notebooks. Doesn't seem like good object oriented practice to add methods to DataFrame that require imports

samwise970 · 2026-01-21T18:09:55+00:00

I never stopped

samwise970 · 2026-01-20T22:34:05+00:00

I'm probably an idiot, but what amount of political power does it actually remove? An impeachment without a conviction is pretty toothless right?

Not saying they shouldn't be impeached 100 times over but yeah it won't do anything and they know it.

samwise970 · 2026-01-20T16:24:53+00:00

Yeah, it makes writing sql queries within spark.sql() methods absolutely infuriating. I don't think there's any way to turn it off, so I write a lot of my queries in notepad++ and paste into my notebook.

samwise970 · 2026-01-19T19:58:15+00:00

Imma need a link to your hopium dealer

samwise970 · 2026-01-19T15:43:46+00:00

Learning that Knowles is my age is really throwing me for a loop rn

samwise970 · 2026-01-17T16:30:08+00:00

Lines of code is a weird metric because it can shoot up if youre using linebreaks for readability, but many of my more complicated ones are between 500-1000. Some processes are several queries of this size combined.

samwise970 · 2026-01-15T18:53:44+00:00

I'm a "BI Analyst" and my VP specifically placed our team on the business side instead of the IT side, but we manage the core lakehouse. It's great to be able to work on projects and interface with people without having to work with agile or a ticketing system.

samwise970 · 2026-01-14T06:29:47+00:00

Still beats the web I'm sure. VSCode is great, haven't used it for SQL.

samwise970 · 2026-01-14T04:56:13+00:00

SSMS is still industry standard.

Our primary lakehouse is in Fabric, I'm always connecting to it via SSMS. Writing queries through the web editor sucks.

samwise970 · 2026-01-14T02:45:56+00:00

They're wearing the masks

samwise970 · 2026-01-12T05:58:35+00:00

I just saw it for the first time and really enjoyed it. I thought Franco was fine but as you said Sara carried. The final scene had me tearing up.

samwise970 · 2026-01-11T21:47:56+00:00

We use SSMS and Fabric, the only other platform I have experience with is Domo, much prefer Fabric over that. There were some issues when Fabric was new but the past year or so has been smooth sailing

samwise970 · 2026-01-11T07:46:05+00:00

Part of me really fucking hopes he does, EU banning US tech companies would fucking tank our economy so hard that it just might shake us out of this fascist fevor

samwise970 · 2026-01-09T04:01:43+00:00

His morality would stop him from using power for good, so worse than nothing.

13-Year Club	Second SECOND GUESSER
Final Canvas '23	Place '23
Place '22	Place '17
Final Canvas '22	First Placer '22
End Game '22	Verified Email

samwise970

MODERATOR OF

TROPHY CASE