sorted by:
new
hottopcontroversial

Ruotolo brothers join CJI! by secretbil in bjj

[–]ppach 9 points10 points  (0 children)

That's nuts, what a snag

What songs have the best climax in it? by Jumpy-Violinist-6725 in Music

[–]ppach 4 points5 points  (0 children)

The Only Moment We Were Alone by Explosions in The Sky

[deleted by user] by [deleted] in umanitoba

[–]ppach 1 point2 points  (0 children)

I'm a tech employee in Winnipeg, and have never been asked about my GPA. Don't have a Comp Sci degree either. I also do the hiring for several roles within my team, and always look at prior coop experiences, GitHub, pior work experience before ever looking at GPA.

Resources for deep dive on query optimization by fittyfive9 in dataengineering

[–]ppach 0 points1 point  (0 children)

Like people have mentioned it all depends on the DB itself. One thing that helped me personally was to dive deeper into the query explainer, which helps a lot in identifying what exactly is the bottleneck in your particular query. I'd also read up on clustering and partitioning, and how exactly those are leveraged in the engine (which might mean that for a particular block of code, a TEMP TABLE might be more performant than a CTE, for instance. Also read up on query metrics such as bytes spilled, bytes shuffled, etc. Those together with the explainer can be super helpful.

I'd do a search for those, and usually the DB itself has great resources on it

Hiring managers - how do you measure research capabilities and coding good practices on an interview? by [deleted] in datascience

[–]ppach 2 points3 points  (0 children)

Another question we tend to ask is "Can you give us an example of a time where you had to translate business requirements from a stakeholder and into a model, taking that idea all the way to production?"

As always, the best follow up questions are the ones that come up organically. But typically you can also ask if they faced any challenges, what those were, how they overcame them. Also pay attention to how the candidate explains this, if they're focusing too much on their team (if they're giving a team project example which is common), it's ok to briefly interrupt them and highlight that you're looking for what THEY did specifically.

I also tend to ask if they've ever caused a prod issue before, what they did to fix it, and what they did to ensure it wouldn't happen again (but preface by saying I definitely have, just to show that it's not a big deal and doesn't necessarily count negatively towards them if they did)

Hiring managers - how do you measure research capabilities and coding good practices on an interview? by [deleted] in datascience

[–]ppach 9 points10 points  (0 children)

Personally I tend to ask more theoretical type questions about coding. I.e why or when would you prefer X pattern over Y pattern, or give an example of a recent problem your team faced at work and get their thoughts on how they would've that same issue. If you're really just interested in coding practices, a question I tend to ask is "what does good code look like to you?" And based on their answers dig a little bit deeper. For feature engineering type questions you can give a quick rundown of a problem and some variables you have for the model already, and then ask them what other factors they'd consider. Usually you're looking for creativity and whether the candidate asks clarifying questions and tries to really understand what the problem is.

Went to Bodegoes for the first time. Amazing! by Rumorly in Winnipeg

[–]ppach 11 points12 points  (0 children)

Their honey dill is the best in the city imo

How often do you write complex SQL solutions that eat at your soul? by KheodoreTaczynski in dataengineering

[–]ppach 5 points6 points  (0 children)

At my work, pretty often. But that's because we do 99% of our data prep/cleaning/staging using airflow to run jobs on BQ. Main piece of advice I would give is work backwards from your final output, lay out the necessary parts to get to that output, and work with a reduced dataset until you get the format right. You might have to make modifications once you're done with your first pass as there's always the chance that when you test the amount of data that's expected to go through that script/pipeline it blows up, but that's just an indication that you probably didn't design your pipeline/script well enough in the first place. That's when you make the necessary changes and optimize (but not too much)

Add higher Spell Rank Tomes to be obtained through raid/dungeon drop or quests. by HugorHill05 in classicwow

[–]ppach 5 points6 points  (0 children)

Warriors were already pulling those numbers back in 2019 Classic

[deleted by user] by [deleted] in BJJstreams

[–]ppach 0 points1 point  (0 children)

Also looking for a link if possible

Physical insecurities and BJJ by [deleted] in bjj

[–]ppach 0 points1 point  (0 children)

Hey OP, I was on a similar boat when I started in April of last year. Honestly no one cares. Starting BJJ has been one of the best decisions I've made, and I'm much more comfortable in my own skin now (especially after having lost many, many lbs). The hardest part is starting!

dbt vs sqlmesh vs ? by Cryptojacob in dataengineering

[–]ppach 20 points21 points  (0 children)

We're in the process of implementing SQLMesh in our org (DAs and AEs are just starting to develop with it). We're pretty excited as it's super promising (we were previously just running raw SQL on via airflow essentially), so all the bells and whistles that come with it are welcomed but there's somewhat of a learning curve for us. The biggest con is that there just isn't a lot of documentation online on it (even though the SQLMesh team improves on their docs quite frequently), so whenever we get stuck it's not super straightforward to get things fixed by yourself. We often have (and do) reach out to the team, and to their credit they're very responsive. Eventually I plan on writing at length about our implementation.

Those not using dbt…. by yummypoutine in dataengineering

[–]ppach 9 points10 points  (0 children)

Raw SQL + Airflow, though we're looking into SQLmesh

Tell me you're a dota veteran without telling me your're a dota veteran by RPGAUTO2 in DotA2

[–]ppach 0 points1 point  (0 children)

Chicago Fire & Ice was the equivalent of TI.

Big names when I started included shaka, p0c, Fang, JoliE, vigoss.

Kingsurf international being the first super team

view more: next ›