ticmasta

hold start & end time in normal DB columns, use business logic for your rule enforcement, have a query to identify rule violation. Maybe add constraints on your warehouse data but I probably wouldn't on the operational DB. I could be convinced to do so for the PoC because it might make sense, but what if you're managing thousands or millions of scheduled "resources" like a chain of libraries, or hotel rooms? What if you need to coordinate "leases"? DB-level is an OK place to start, but also one of the hardest to tease apart when you need to scale.

This is kind of the point of data modeling; you start with an idea, make it all pretty 3rd-normal form, define your projected indices and checks and constraints, then you mess it up a bit where it makes sense or you've had experience in the past.

YMMV

Not required, but knowing a little relational algebra helps queries make a lot more sense. A lot of the features like constraints and indices are very thin veneer over the underlying concepts.

At the other end of the spectrum, once you can write a few basic queries check out something like SQL Murder Mystery https://mystery.knightlab.com/

This one is super-fun and lets you practice some basic to low-intermediate skills.

I also don't understand the value in giving away more than you need to get someone to commit. If your product has any type of cost associated with converting you may be better to filter poor prospects early, i.e. those who won't even give out an email. This is likely better than carrying them farther down the process with more promising conversions.

I largely share your opinion and conclusions; good managers were always a combination of filters and selective connectors and I don't think this has changed. If anything it's far more important these days. What I fear (and hate) as a manager is that you're right - I need to be privy to every conversation, topic, initiative, etc and then pull in only the absolutely minimally required resources. This consumes all my time and is extremely tiring.

>> scheduled call after lunch, at the end of the day, or first thing tomorrow morning

This sounds great in theory, but one of the key issues with managing remote teams is there is no common time in the day that is "after lunch, end of day or first thing in the morning".

The reality is most remote scenarios require you adopt at least some async process; fighting this is a losing battle.

Some good news: your manager's job was always facilitate internally and protect externally; how this is accomplished has certainly changed but the core essence of management, if anything, is even more crystallized now.

I think what they mean is that (from my experience on both sides) small kids are noisy, messy and very active. This makes parenting in a shared environment (if you care about your neighbors) hard. When you go camping the kids have space, can get dirty, get tired and go to bed early. I'll take a crying baby camping over banging and yelling through a hotel room wall any day.

less environmental impact if they would just pee on the existing trail markers then...

That's pretty unfair, the parent explicitly differentiated between navigational and aesthetic purposes. The former is a critical part of any trail more remote than a boardwalk, while the latter for someone's FOMO insta post.

I grew up in Tsawwassen in the late 70's & early 80's and Pt. Roberts was nothing like today; you could buy property for next to nothing, but why would anyone want a swamp shack in the middle of nowhere? I remember a neighbour who used to ride his bike to the border, walk across the "no touch" zone and buy cheap pipe tobacco - try that today and see what happens!

I'm a Dev Manager but started as a mid-senior developer at my current company (now about 350 people). We grew a lot by acquisition and one thing I noticed was many "cultural silos" that made it hard to build a shared, unifying identity. Myself and another developer worked to try and address this with a lot of small things focused on cutting across teams & groups: a book club-style bi-weekly discussion, "Tech Talks" from across the teams to diverse audiences, some hackathons and making online conferences (MS, AWS, Google, Etc) into company events. Literally things that "make people spend time with people outside their direct team". It's been pretty successful and pushed lots of new initiatives in some unexpected areas.

So my advice would be to look for a broader area where you see a gap or failing, and then look for ways to address this that don't need a huge investment of people or resources; guerilla activities FTW! If you can show some success, you can then pursue as appropriate/desired...

one of the issues that does matter is how/where you are applying the language. Ada use is super niche so unless you're looking to stay in the same domain it does matter. As an educated, non-HR gatekeeper I do care about the context of your experience.

This implies you can't determine your value based on contribution, so just use coworkers as a relative measure. Doesn't seem to make passengers happy wrt airline tickets so not sure about salaries...

It's also often supported by those at the most extreme top end for whom it has very little positive or negative impact beyond signaling. See philanthropic billionaires and top-level athletes for examples.

I don't know why people always jump to "collective action" as the answer to anything related to compensation. Software engineers and program managers are not powerless, uniform skilled, replaceable cogs. You have unique & distinctive value. That we've just gone through the most ridiculous compensation inflation period of my entire career yet people still act like they're forced to put in 70+ hours a week in a coal mine boggles the mind.

The province of New Brunswick announced their plans for choir after "some of the hardest planning and preparation of my career" (from the Minister of Education). The master plan: "sing quietly"

what about the "thin air" part? Does this imply they can only grow it at extreme altitude?

This isn't a bad take-away, but should probably be combined as "the flu is more dangerous then you think, and COVID is more dangerous than the flu"

if he played age of empires as religiously as I did, he should have realized nothing beats the long bows of the Britons...

So when I worked for the cable company straight out of uni and we would look up famous local people to see what packages they subscribed to, we should have all been fired? I guess technically, but that's pretty draconian. Are you also no mercy, hard on crime, 1-strike and you're out person, or more progressive in that area?

>> just prevent future crime by helping people.

OK "just" prevent future crime via... helping people.

What does that even mean? Have you costed out your helping program to show this is true. We have more social programs, care agencies and food banks than ever before, yet the problems and problem areas are as bad as ever. Let's see if you change your tune after being the victim of serious crime

I too am scared of trying to onboard a new-hire (especially a junior) in a completely remote fashion. Part of this is because we are not set up nor do we have the proper support; but this seems a little chicken v. egg. The other is how to create those opportunities for social & professional serendipity you get when colocated.

Calgary!

oh, you said poor AND sexy...

funny enough though, as oil and gas declines in importance (and loud, oxygen-sucking volume) some new and preexisting voices are getting an opportunity to emerge. We're young, educated and ambitious so despite poor economic fundamentals I'm bullish ...

Total was floating the idea of doing just this in Alberta a recently as the past decade. The science really seems to work but the idea of a small nuclear explosion in your backyard (on purpose is a hard sell (even for the relatively open-to-nuclear French!)

>> It is crazy how much well intentioned people do in the interests of sustainability

I just don't see this. Paying a few dollars more or (gasp!) going without a straw is low-effort virtue signaling.

In aggregate I don't see people voluntarily avoiding car or airplane travel, living in tiny, centrally-located shared apartments or skipping fruits and vegetables that are not grown locally (i.e. just potatoes and carrots 8 months per year). We are not going to shift the needle without fundamental change at the point of consumption. Regardless of where you stand this is where we should be deciding collective next steps.

I have and admire this graphic and I think it highlights a few top-level things you mention like the right representation for the right audience. It takes some time and concentration to understand the Napoleon graphic vs. a simpler presentation where a few key points jumping out at you with ease, but that it manages to encode so many dimensions into a 2-d format is where it is unique. Tufte generally pushes information density over other, equally as valid, goals.

how many hands do you have :)

The story could largely be reduced to: Giant Multinational sues Giant Multinational; both gain support of other Giant Multinationals while World's Most Powerful Government sides with plaintiff Giant Multinational.

The EFF needs to 100,000x larger to influence this level of game.

If they are successful in a particular segment an acquirer could look to just buy that part of the market rather than earn it organically

maybe? sometimes (often?) a debt-raise at this level comes with options to convert to equity if it turns out to be desirable. So unlike a bank loan (where the bank most certainly doesn't want to be your partner) a debt raise might end up with someone like Warren Buffet owning a sizeable part of your company.

>> I know that NBA players have a union, and top players definitely get rewarded well.

relative to what? the top players have always gotten big paydays, and the economics suggest without a union they would get paid even more. They are effectively subsidizing mid and lower tier players.

Fitting old onion post: https://www.theonion.com/americas-homeless-want-a-hand-up-no...

Replace the Good Samaritan with Reid Hoffman and the homeless with startups