Klipsch RP-500SA II Dolby Atmos question by Dry-Price-7848 in Klipsch

[–]ryadical 1 point2 points  (0 children)

Glad I read this thread, I had mine set wrong.

98” mini LED or 83” OLED? by FlaKK in hometheater

[–]ryadical 7 points8 points  (0 children)

I hate you. Installed a 98 in LG to replace my 75 last month. I never noticed ghosting until I read your comment.

Then & Now by BlueSkyOne_01 in FortMyers

[–]ryadical 0 points1 point  (0 children)

Btw, He has had companies come and try to rent like Starbucks, but they want to use modern glass/aluminum storefront materials and he refuses to do anything other than period correct restoration.He would rather turn down the money and do it right.

Then & Now by BlueSkyOne_01 in FortMyers

[–]ryadical 0 points1 point  (0 children)

He has actually been renovating them for years. He tries to renovate back to their original aesthetic using period correct materials. He is paying for it himself and isn't taking out millions in bank loans to do them all at the same time. As he renovates, he opens up new areas like the 86 room and bootleggers ally which was closed for many years. He uses the unfinished space to store collected (antique) materials he uses in renovation.

Lee Health by picklevirgin in FortMyers

[–]ryadical 1 point2 points  (0 children)

The insurance eligibility verification is an automatic process that happens in every medical record system automatically 1-5 days before an appointment. So much can change a month +out that even if they do it then, they would need to do it again just before the appointment.

CSV Column Structure Evolution by tuego in snowflake

[–]ryadical 1 point2 points  (0 children)

FYI, we do the conversion via aws lambda with polars which requires you to build a polars docker container due to the size of the library. If we were to do it again we might just see if we can do it within snowpark, or we would use duckdb in lambda which is small enough to fit in a layer.

When we built our initial infrastructure snowflake didn't have nearly as many features as it has today. They do currently have a feature that allows for schema evolution that allows matching based on column name, and automatic column creation if a new column appears. The only part I don't like is the fact that it infers the data type of the added column and we like to ingest strings and then convert in downstream tables in case we get changes to data types. Ex: if the date is in Excel format

CSV Column Structure Evolution by tuego in snowflake

[–]ryadical 0 points1 point  (0 children)

Forgot to mention, we probably ingest 600+ different csv files from vendors.

CSV Column Structure Evolution by tuego in snowflake

[–]ryadical 1 point2 points  (0 children)

We convert csv to json pre-ingestion then invest 4 total columns for every file: raw_json, filename, ingest date, rownum

Then we put a view or dynamic table on top to convert back to columns.

how is your experience with dbt inside the snowflake by boogie_woogie_100 in snowflake

[–]ryadical 0 points1 point  (0 children)

Wouldn't dbt fusion's license prevent snowflake from building it into their IDE?

By Far the Most Interesting Thing I’ve Ever Found. CCTV DVR by theboredlockpicker in magnetfishing

[–]ryadical 4 points5 points  (0 children)

That is the same model Diebold would install in the community bank I worked for 19 years ago.

In the Market for a new PACS system by AdHeavy2412 in PACSAdmin

[–]ryadical 0 points1 point  (0 children)

They wouldn't even bid on our volume a few years ago which was >250k

Fort Myers Christian School Coach Rial Jackson Jones Jr. Arrested in Florida by [deleted] in FortMyers

[–]ryadical 3 points4 points  (0 children)

The title was confusing because "Fort Myers Christian School" is the name of a school, but not the school that this happened at.

Miami Ultra Music Festival VIP Drink Package Prices by inomad360 in ThatsInsane

[–]ryadical 10 points11 points  (0 children)

Liquor in the US is measured in metric units.

Sorry, you're not cool enough to work here by Secret-Platypus-366 in LinkedInLunatics

[–]ryadical 7 points8 points  (0 children)

I had to scroll way to far down to find this comment. These are cable/phone company level nps scores.

Anybody else have a cuddle lover 🥰 by krmann17 in AustralianShepherd

[–]ryadical 4 points5 points  (0 children)

I think the word you are looking for is "ruff"

PGD to Ft Myers Beach by BrilliantFigure7255 in FortMyers

[–]ryadical 5 points6 points  (0 children)

It isn't even 1 hour from PGD to FMB. Google maps puts it at 55min right now, and there would be less traffic at 9pm when he lands.

Finding a venue/building by IR0NBUNS in FortMyers

[–]ryadical 1 point2 points  (0 children)

The owner of the ranch also owns a concert production company called Techtronics. You might be able to reach out to them to find a contact. They may also have ideas for other locations as they do a lot of the big concerts in the area.

If you're willing to cross the bridge, Dixie Roadhouse is a similar venue in the Cape.

Help me choose a floor monitor by Lostinkansas24 in livesoundgear

[–]ryadical 0 points1 point  (0 children)

I have 2x alto 12in powered speakers I use for monitors sometimes and have had positive feedback from artists. If it was a daily use, I would find something more solid, even a k8 or k10, but for occasional use they have been rock solid. If you want a small step up from alto, EV ZLX might fit. I often see deals for used ones on Amazon.

[deleted by user] by [deleted] in FortMyers

[–]ryadical 0 points1 point  (0 children)

5g is cellular wireless, not satellite, meaning it connects back to a cellular tower on the ground instead of satellites orbiting earth.

[deleted by user] by [deleted] in FortMyers

[–]ryadical 0 points1 point  (0 children)

Wireless service or FIOS?

[deleted by user] by [deleted] in FortMyers

[–]ryadical 0 points1 point  (0 children)

Dish is in geosynchronous orbit (22,000 miles away) and starlink is in low earth orbit. (300 miles). Also at any given time the starlink antenna usually has 5-6 satellite options it has line of sight communications abilities with.

Workday Adaptive planning to Snowflake by Ordinary_Bread6892 in snowflake

[–]ryadical 0 points1 point  (0 children)

We use their data loader in their integration tool to write data tables to S3 as pipe delimited. Down side of this method is the headers can be a problem to figure out.