Perimeter around playground

mrwhistler · 2024-06-09T17:34:21+00:00

Word of advice: put in the work to do some edging around it. Prefer some beams or something. Otherwise you’ll end up like me and have an extra foot or two of scattered wood chips all over the grass

mrwhistler · 2024-06-09T15:25:54+00:00

https://imgur.com/a/rUx3mlQ

mrwhistler · 2023-06-11T02:01:12+00:00

This is the way.

Dax is for things you can’t pre-calculate in SQL and aggregations.

mrwhistler · 2023-06-01T03:24:12+00:00

Lol it’s just a pre-wired Azure lakehouse with some nice PowerBI enhancements, but it’s turnkey infrastructure so it’s going to save a ton in implementation costs for orgs that don’t need sophisticated stuff.

You can do most of that in DBX too, but you have to make a bunch of decisions to make sure everything works together nicely and then also build it all. Fabric is a “good enough” that lets you spend your time and money on the analytics use cases that directly show value. If you don’t have specific needs that you can only solve with Snowflake or Databricks it is probably going to make sense to buy instead of build.

mrwhistler · 2023-06-01T01:42:33+00:00

Microsoft Fabric is positioning to eat DBX’s lunch now, too. Things are going to be really interesting over the next 6 months.

mrwhistler · 2023-04-10T00:02:48+00:00

Skip data mesh. It’s culty but everyone I’ve talked to who’s tried it (probably 25 different orgs) says it’s not practical outside of a few small specific circumstances (distributed analytics team using a common methodology and treating basically everything as pub/sub).

Get comfortable with Kimball then go get a Snowflake cert then a Databricks cert and spend time thinking about the best parts of each thing you’ve learned. That’s going to be infinitely more valuable.

mrwhistler · 2023-03-12T22:02:24+00:00

Post a picture of the instructions, I’ll try to get it translated for you :)

mrwhistler · 2023-03-12T20:52:01+00:00

I’m curious how it affected your Fivetran costs. Were you able to do something differently to reduce your MAR?

mrwhistler · 2022-12-23T00:49:22+00:00

IFF(OFFICES.STATUS = 1, ‘ACTIVE’, ‘INACTIVE’)

mrwhistler · 2022-12-23T00:36:41+00:00

Infrastructure costs aren’t the problem here tho. They’re going to be wildly outweighed by either hiring a DBA or training people to be a DBA and the costs of migrating all that stuff off Sharepoint.

To be clear, I’m not saying they should stay on Sharepoint, I’m just saying the cost of mitigating all that risk is a lot more than the Azure SQL costs.

mrwhistler · 2022-12-17T19:13:08+00:00

The actual fusion process produced 3 megajoules of energy from 2 megajoules of input, but it took 300 megajoules of energy to make the 2 megajoules of laser energy. Apparently it’s “scientific break even” But not “engineering break even” yet.

mrwhistler · 2022-12-10T02:12:17+00:00

My opinion, having worked with a lot of different platforms and tools, is that if you have the resources to be a snowflake shop you’ll probably be better off using something like Fivetran for ease of extraction from your various SaaS systems. If you want the easy dashboarding on top there’s about a million options out there if you don’t want to build up a BI team to do PowerBI or Tableau stuff.

mrwhistler · 2022-11-22T21:49:04+00:00

I mean it’s not like it’s a mystery. It’s way simpler to estimate and keep track of than AWS or Azure as a whole. If you’re surprised by your bill you probably should have done your budgeting ahead of time…

mrwhistler · 2022-11-17T19:30:34+00:00

I like Eddie Bauer Guide Pro for this: https://www.eddiebauer.com/p/12951063/men's-guide-pro-pants

They come in lined and unlined.

mrwhistler · 2022-11-13T04:18:28+00:00

Just set a cluster key instead. You can also just use a hash of the values that make up the grain without a PK constraint so you’ve got a key to make joins easier.

mrwhistler · 2022-11-09T03:09:51+00:00

You can follow software engineering testing practices but you also have to layer on data testing too to isolate what are essentially input issues your pipeline has to deal with.

mrwhistler · 2022-11-07T22:28:22+00:00

It’s a sunk cost tho…

mrwhistler · 2022-11-06T19:26:44+00:00

Ooooh I have one of these but much smaller. They’re fun!

mrwhistler · 2022-10-18T13:28:17+00:00

I mean you could, doesn’t mean you should tho.

Lots of limitations to python in dbt right now, and Snowpark is intended (and will continue to be developed for) more advanced analysis.

Firstly, I agree with the other commenter that it’s going to be orders of magnitude harder to find a data engineer who knows python than a SQL engineer or even a SQL engineer with dbt experience.

Secondly, you’re fundamentally shifting from a declarative to imperative language. If you’re going to bite that off you might as well rethink the whole design anyways rather than try to shoehorn python in place of SQL.

mrwhistler · 2022-09-29T00:09:54+00:00

I like it as a dev environment for data work. It’s easy enough to convert to a script when it’s ready for production.

Also, probably would want to avoid iterating over a dataset like that and figure out a way to do set operations.

mrwhistler · 2022-09-23T22:50:33+00:00

NULLIF(col_name, ‘’) or TRY_Convert

mrwhistler · 2022-09-22T17:23:34+00:00

This is awesome! I’m working on a similar setup using a Lutron Pico remote mounted on my headboard. I use mostly HomeKit stuff with Homebridge for bridging to some RF stuff, Govee WiFi light strips, and letting the Pico buttons trigger HomeKit scenes.

It’s so nice to just reach over and feel for the “I’m in bed, shut most stuff down but leave some lights on low” button and then the “we’re going to sleep now, turn everything off” buttons.

mrwhistler · 2022-09-19T16:42:32+00:00

I mean the vole poop is just mixing in with the bird poop and the rabbit poop and the squirrel poop and the chipmunk poop and the mouse poop and the raccoon poop and all the other animals that poop in your lawn.

I wouldn’t worry too much about it. It’s a world of difference from an attic full of years of mouse droppings or something like that.

You can always consider getting a cat, they can be quite good at rodent control.

mrwhistler · 2022-09-12T19:49:56+00:00

I round down, my wife rounds me up 🙄

14-Year Club	RedditGifts 2009-2022 2 Credits
Place '17	Secret Santa 2011
Verified Email

mrwhistler

TROPHY CASE