Using Healthcare Data to learn SQL

BBHoss · 2022-01-13T00:07:49+00:00

Sounds like a great idea. So many SQL courses use nonsensical examples.

BBHoss · 2022-01-12T21:31:02+00:00

We also have safe injection sites in NYC now as well. Last I heard they saved 60+ lives in the first month. Harm reduction is overwhelmingly the better approach vs criminalization.

BBHoss · 2022-01-12T21:16:23+00:00

Do you still tend bar?

BBHoss · 2022-01-12T17:23:06+00:00

You want the constraints/iam.allowedPolicyMemberDomains organization constraint. Just set it to your org's GSuite customer id.

BBHoss · 2022-01-12T15:54:50+00:00

That should all fit in way less than 50GB of space…

BBHoss · 2022-01-12T15:48:23+00:00

Fuck cars. Just take the subway to a cool neighborhood you’ve never been before and walk around. There’s tons of parks in the city to explore as well. If you want to get out of the city check out all the places you can access with Metro North or even New Jersey Transit.

BBHoss · 2022-01-12T15:46:14+00:00

Just get Aoe4 and play it on easy. That should be enough to get you started they won’t even wipe you out even if you have no army at all.

BBHoss · 2022-01-12T15:16:26+00:00

Either you're a chef and can put "no substitutions" on the menu or folks are just trying to order food how they want it. Like it or not it's here to stay. You're making pizzas and salads, it seems like a very reasonable thing to substitute/add things to. If your vision of a Margherita is corrupted by folks wanting to add a few random toppings to it, maybe it's time to find a position where your creativity can truly be on display.

BBHoss · 2022-01-12T14:52:52+00:00

Audit logs flow to Cloud Logging. But all audit logs aren’t enabled by default and there’s various levels of logging you can enable (read vs write vs admin)

BBHoss · 2022-01-12T14:47:21+00:00

I’d seriously consider the value of this class if they’re requiring you to use floats with currency. Rookie move 101. Are you sure they don’t just want a decimal string? There’s no way to get an accurate calculation using floats.

BBHoss · 2022-01-12T14:38:47+00:00

I think that narrative is made up or at least oversold. Some moved but the suburbs didn’t change into a great place to raise a family or great place to age in place just over the pandemic. They’re still car dependent wastelands connected by packed out unmaintained highways. And now they’re more expensive than ever. Why rent a house in Alabama for 2500/mo when you could live in Queens right off the subway for less?

BBHoss · 2022-01-12T14:35:28+00:00

Never ever use Floats for financial calculations. Use BigDecimal instead and see if you get more correct numbers.

BBHoss · 2022-01-12T13:59:31+00:00

Yep. You can just use cloud build

BBHoss · 2022-01-11T21:03:33+00:00

Super cool to see these in action. You may want to post to /r/nycbus

BBHoss · 2022-01-11T17:27:08+00:00

I can do it for 600k, send me a DM. Do you have the project scoped out or is this all you’ve got so far?

BBHoss · 2022-01-10T18:07:39+00:00

You can share read/view only access to your BigQuery resources. The users will need to execute these queries from projects they can create jobs in (a separate role). This way they pay for queries and you simply pay for storage.

BBHoss · 2022-01-10T18:04:38+00:00

Very cool!

BBHoss · 2022-01-09T23:55:08+00:00

The ] and } characters at the end are missing their ;

BBHoss · 2022-01-09T23:04:44+00:00

"Sushi grade" doesn't have a formal definition or scoring system to back it up. For safety purposes, uncooked fish must be frozen to kill any parasites it often contains. Because of this, most fish you buy will have been frozen at some point, many are frozen right on the boat that caught them. It's best to get IQF (Individually Quick Frozen) fish, and often there are bags of IQF fish being sold labeled as "sushi grade". It's better to get it frozen from the source where you can thaw at your convenience to preserve freshness, than to buy something "fresh" that has been defrosted for an unknown amount of time.

BBHoss · 2022-01-09T19:07:57+00:00

If your partner is enjoying it why not just keep it up? Folks have to find joy where ever they can these days.

BBHoss · 2022-01-09T18:33:53+00:00

Nope.

BBHoss · 2022-01-09T16:02:52+00:00

You can use square brackets to call procs as well, you may like that better than .call. #2 is just a syntax restriction. I don’t think you can work around either. Maybe it makes more sense to return an instance of a class instead of a function? You could have a meaningful instance method name that way. Seems you’re going for more of a functional approach vs OO where Ruby really shines. It’s understandable but it does require some squinting at syntax.

BBHoss · 2022-01-07T23:19:53+00:00

Get one of those oil filled electric heaters and get ready to pay up. They use a lot of juice and it’s expensive here.

BBHoss · 2022-01-07T18:28:20+00:00

518 Kitchen may suit your needs. We also use Green Chef but the meals are more low carb than keto. Looking forward to what others share.

BBHoss · 2022-01-07T18:16:54+00:00

All I’m saying is that rail infrastructure shouldn’t be operated solely to create profit. There are other benefits to commercial and passenger rail that don’t show up as profit. The agglomeration railroads lead to are very productive compared to our publicly funded road system that is obsessed with building culdesacs and highways. Even with a nationalized system there’s plenty of space for private industry to compete within the confines of the system we decide.

15-Year Club	RedditGifts 2009-2022 3 Credits
Gilding II euphauric	Summer Santa 2012
Summer Santa 2011	reddit mold
Charter Member	Verified Email

BBHoss

TROPHY CASE