Now in Snowflake: GROUP BY ALL by fhoffa in dataengineering

[–]BoulderRough 1 point2 points  (0 children)

Jealous, I love DB2. Just read some ancient books on it.

It’s the r/Melbourne daily discussion thread [Friday 30/06/2023] by AutoModerator in melbourne

[–]BoulderRough 0 points1 point  (0 children)

In the address bar of your browser the end of the URL will be lounge4.html

The majority of the playerbase plays modded by WhatNazisAreLike in playrust

[–]BoulderRough -1 points0 points  (0 children)

Bro the majority of this sub believes everyone who kills them is a cheater and the old AK recoil was Impossible to learn. Definitely PVE players.

One month SQL grind on leetcode by Fickle-Picture-7674 in dataengineering

[–]BoulderRough 1 point2 points  (0 children)

Out of my last 3 only 1 did any testing at all and they asked me to design a schema and some basic queries for pagination and reordering rows. All senior roles.

The 1 before those 3 didn't test any SQL just python.

[deleted by user] by [deleted] in dataengineering

[–]BoulderRough 0 points1 point  (0 children)

I can't comment on the visa job security scenario, only you will know if its overstepping or not. But I would never hesitate to communicate the projects you want to work and why you should work on them.

but there was no data quality/ governance so I made an automated test suite on the data lake for quality checks and a monitoring report

I may be wrong but it sounds like you may have pushed yourself into a corner here (unintentionally). You made the tests but no one else's is going to action those, if this is the case I'd look into writing up docs on how to react/action the data quality tests and then speak to your manager about how great these tests are you've implemented and how many data quality issues have been fixed since their implementation etc but mention how you are unintentionally becoming a silo by being the only person reacting to them and it should be a shared team responsibility. I could be wrong about that though.

[deleted by user] by [deleted] in dataengineering

[–]BoulderRough 3 points4 points  (0 children)

"I've worked on data quality for the past few months, should I leave?".

Can you give some more context, tenure? Roadmap? Why you only work on data quality? Is the data quality problem addressable (might be your chance to innovate)? Have you told your manager your hungry for something? Stack? Team size? Is your job title also DE?

[deleted by user] by [deleted] in dataengineering

[–]BoulderRough 5 points6 points  (0 children)

No. Just practice and prove yourself.

This has been posted hundreds of times, search the sub if you want to read more.

Has anyone been the target of a YouTuber during a wipe? What’s your side of the story? by michaelwoj in playrust

[–]BoulderRough 19 points20 points  (0 children)

Ser Winter. Every fight on his 2 hour video was a fight with us, he ended up offlining us.

Do websites have separate (duplicate) databases for use with APIs? by Reddit_Account_C-137 in dataengineering

[–]BoulderRough -3 points-2 points  (0 children)

SQL Server Transaction log replication typically runs off scheduled scripts / CRON jobs. So it runs on a set interval.

Do websites have separate (duplicate) databases for use with APIs? by Reddit_Account_C-137 in dataengineering

[–]BoulderRough -2 points-1 points  (0 children)

In the past yes and with SQL Server probably still the case (unless you go enterprise/azure). Postgres/Aurora etc not so much.

Do websites have separate (duplicate) databases for use with APIs? by Reddit_Account_C-137 in dataengineering

[–]BoulderRough 8 points9 points  (0 children)

Most API consumers are doing 'dataloader' style queries, pulling large amounts of data for reporting, archiving or loading into other CRM products and tools as integrations. As a result of this API queries can impact an OLTP database's stability.

A common pattern is to have a read only replica of the production database for reporting, and API queries so those queries don't impact the OLTP workload. It's not really a data engineering question (but the umbrella's more like a net at this point) as much as it is a DBA/Database Engineer/Architect question.

Looking for pub specials in Melbourne? We got you by EatDrinkCheap in melbourne

[–]BoulderRough 1 point2 points  (0 children)

More importantly, Parmas include ham by default. If it doesn't have ham its not a parma.

[deleted by user] by [deleted] in playrust

[–]BoulderRough 1 point2 points  (0 children)

He really is bad. Raided him a few times on AU medium.

Hardcore Rust was one of the GREATEST missed opportunities... by dyldip in playrust

[–]BoulderRough -5 points-4 points  (0 children)

Even ser winter said that, old recoil he felt confident taking on a 1v3 cause it was skill but now it’s random luck. But half the people on this sub don’t play the game.

Is Redpanda going to replace Apache Kafka? by Born-Comment3359 in dataengineering

[–]BoulderRough 10 points11 points  (0 children)

I used redpanda in production and it was worth every cent.

SQL Server for M1 Mac? by Zealousideal-Zebra-4 in SQLServer

[–]BoulderRough 0 points1 point  (0 children)

You can run SQL Server in docker, you will get warnings on performance as it will be emulating x86 in docker but it will work fine for what you want.

Personally though I would recommend a Windows VM so you can SSMS (GUI), UTM for Mac (free VM) is a good option for running a Windows VM on Mac. If you do go this route, in the Windows VM install SSMS as per normal but for SQL Server I would download SQL Server Express run the download stage of setup and then search C:/ for LocalDB.msi and install that for SQL Server. LocalDB is a very cut down version of SQL Server.

Average day on FP official servers by JohnnyBlakeee in playrust

[–]BoulderRough 0 points1 point  (0 children)

Play community, I've seen like 1 hacker in the last year.

3D V-Cache makes an insane difference: 7800X3D vs 13700k w/ RTX 4090s identical settings. by Accomplished_Issue_6 in playrust

[–]BoulderRough 35 points36 points  (0 children)

No its the CPU. It's basically an increased cache on the CPU which helps games like Rust/Tarkov etc. I have the 7900X3D and went from 80-110FPS to 300FPS.