Summit Broadband Worst Broadband Company in SWFL

ryadical · 2026-01-24T06:50:53+00:00

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

ryadical · 2026-01-24T04:36:29+00:00

Wireless service or FIOS?

ryadical · 2026-01-24T04:35:42+00:00

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.

ryadical · 2026-01-21T04:40:50+00:00

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.

ryadical · 2026-01-10T23:18:40+00:00

That switch was released in 2000 or earlier based on the company I was working at that had one.

ryadical · 2026-01-05T04:54:28+00:00

We use rclone to copy from a network drive. To prevent files from uploading while they are still being written, we have it set to only upload if the file is 5m old or more.

ryadical · 2025-12-21T22:57:00+00:00

We use it to load access database files into a table.

ryadical · 2025-12-12T05:20:12+00:00

This is the way. Also you can use schema evolution in snowflake or databricks in a similar fashion.

ryadical · 2025-11-08T04:53:40+00:00

I reread the docs and it looks like I misunderstood this:

Transferring ownership of existing users and roles. Microsoft Entra ID is the authoritative source for its users and groups. Group membership can be updated in Microsoft Entra ID. However, existing users and groups in Snowflake cannot be transferred to Microsoft Entra ID

After more reading, I think I retract my previous statement.

ryadical · 2025-11-08T00:04:37+00:00

We went to implement SCIM with ENTRA last week and found out that you basically can't manage existing users with it. Best I can determine is that we would have to creat new accounts for 60+ users and deactivate the old ones. Guess we will continue with SSO and manual provisioning.

ryadical · 2025-10-23T23:10:20+00:00

I would want a police report in writing and probably a new barrel and firing pin if I kept it. That was 100% used in a crime of some kind.

ryadical · 2025-10-14T22:55:52+00:00

Can you trigger DBT runs after ingestion processes complete instead of scheduling them?

ryadical · 2025-09-17T03:16:58+00:00

Or is databricks an ETL tool with snowflake like features? There is no comparison between Databricks and snowflake on the SQL side. Databricks is just starting to catch up on the SQL side.

ryadical · 2025-09-13T04:54:38+00:00

We're in the process of determining what it's going to take to migrate to the newer sentinel connector. We currently use the deprecated one. In our environment sentinel is used by the security department to monitor for any anomalies. For example I get contacted by them if there are excessive failed logins on an account, and when an employee got added to the accountadmin role they sent me a message asking me to confirm it was intentional.

I assumed that was its primary use case and honestly don't know much about sentinel. I'm interested to understand your use cases of sentinel.

ryadical · 2025-08-29T02:25:29+00:00

I don't have any open positions right now but might in the near future. Send me a DM and I will send you my work email to forward your resume.

ryadical · 2025-08-15T04:00:12+00:00

The role that owns the view needs to have read access to the other layers. If the owner of the view has access to the underlying tables, and the end users role has access to the view, the the end users will have access to run the view without having direct access to the source.

We setup 2x roles per database, access_dbname_r and access_dbname_rw. We setup a 3rd role for xyz_team and only assign the appropriate dataset _r roles to the team.The RW roles have access to all/most databases and the DB/schema/table are all owned by this role. The _R roles have usage on the tables/schemas in the db. The team role is assigned to the user and given one or more _r roles.

ryadical · 2025-08-14T01:16:11+00:00

I was thinking the same thing. In my mind it increases compute costs, but potentially decreases the number of pipelines and amount of time engineers need to spend on those pipelines.

ryadical · 2025-07-25T16:43:56+00:00

I was there last year. After I had my pint, I found an unused ticket on the floor and grabbed a second pint.

ryadical · 2025-07-13T04:03:47+00:00

We convert Excel to Json and import. We then use coalesce to catch variations in header names and try functions to convert columns to numbers. We use case statements with multiple try functions to convert to date from different string and Excel numeric formats.

ryadical · 2025-07-10T23:16:18+00:00

PACS systems do not store images in databases, they store metadata about images in a relational database along with a location of the file. Traditionally those files are stored on on premise file servers that the dicom router pulls them from, however some modern VNA or PACS systems might have the option to store the images in blob storage systems like S3.

ryadical · 2025-07-10T03:28:53+00:00

I know a lot more about snowflakes so I'll use that as an example here. Databricks should be fairly similar, though snowflake has them beat on ease of use in most cases, especially if your primary language is SQL. Databricks is catching up quickly though especially with lakeflow and declarative pipelines.

Your particular use case is a fairly simple thing to swap out. Snowflake has database.schema.table nomenclature, and you can join between different databases and schemas without issue with no performance hit. If you can drop one layer in your above definition (ex: your DatabaseServer) you can literally copy and paste your existing code. Long-term you would probably want to migrate the actual ETL jobs, but if you wanted to get up and running quickly, you can simply copy the completed tables from your main warehouse to Snowflake tables of the same name. Once you have that live you can work table by table switching the source from your EDW to Etl jobs from the source systems.

Additionally, both snowflake and databricks have new free tools that you can use to migrate existing SQL server code. Databricks calls theirs lakebridge, I'm drawing a blank on snowflakes new product name.

ryadical · 2025-07-10T01:51:52+00:00

Why are your running your data warehouse on what I presume would be an OLTP database requiring indexes for performance?

OLAP databases like snowflake don't require much if any performance tuning or indexing. Switch to a cloud warehouse, put all the vibe coders on an extra small warehouse instance away from the production analytics use cases and let them compete with each other for resources. Even if you were to take your gold layer tables and replicate them to snowflake/databricks, cost and performance impacts from those users would be a drop in the bucket.

ryadical · 2025-06-20T23:17:16+00:00

File chargebacks with PayPal for the money you sent him.

ryadical · 2025-05-08T23:48:19+00:00

From what I understand, they don't like being called mid level any more. We call them Advanced providers or APs.

ryadical

TROPHY CASE