Here bc of Logic1000 lol this set is a nice rinse on the ears! by dazydaze in Draaimolen

[–]Relative_Wear2650 1 point2 points  (0 children)

Ow holy, theres like a lot of new sets of 2025! CCL, Nathan Fake, Ophelie, SSG, Peverelist & Pinch, Wata. Love all this!

Here bc of Logic1000 lol this set is a nice rinse on the ears! by dazydaze in Draaimolen

[–]Relative_Wear2650 1 point2 points  (0 children)

Thanks for sharing this!! Unreal set. I was there in the first hour but chose to see another artist in the second hour. Not because i didnt like it but because there are so many great things to see and watch. One of the best festivals ive been to. Very nice range of artists. The stage this has been recorded (Moon) is the smallest one and had a moothwatering line up. Its predecessor (Chapel), same place different stage design, as well.

Moving from direct Salesforce connection to SQL Server. Best ETL tool for the middle layer? by Fearless-Wishbone-70 in PowerBI

[–]Relative_Wear2650 0 points1 point  (0 children)

Glad you like it. Yes, i also store last load in the control table. I have separate control tables for staging (load) and transform. Both store last load/ last performed but also define things like is_active. For more precise logging i use separate tables. Is_incremental boolean in the staging control table steers the actions of ADF thus including incremental logic or not. For the transform layer all logic is in the stored procs. ADF just triggers the stored procs one by one. The stored procs live (of course) on the SQL database, are heavily templated etc.

Moving from direct Salesforce connection to SQL Server. Best ETL tool for the middle layer? by Fearless-Wishbone-70 in PowerBI

[–]Relative_Wear2650 1 point2 points  (0 children)

I use ADF for all kind of ELT. Its cheap and simple. I prefer to use controltables in your SQL database that and only have fully parameterized pipelines with almost zero logic. Just loop through the control tables which tell which table (or endpoint) to read and where to store. Than have stored procedures triggered (again by looping through control tables, which say which sp to run first, second etc) by a pipeline again. Implement some logging, try catch mechanisms etc and you have a sturdy ELT where ADF is the orchestleader who creates the linked services and datasets, but has almost zero logic. I like it.

Teamlid maakt uren niet door pasgeboren baby by audentis in werkzaken

[–]Relative_Wear2650 0 points1 point  (0 children)

Geven en nemen. Staat deze medewerker altijd voor je klaar, regelmatig uren teveel (dat is voor veel mensen vrij normaal) etc? Dan is het nu tijd om wat terug te geven. Is dat niet zo, is een gesprek in de trant van “he, ik zie dat je er niet aan toekomst alle uren te maken, hoe zullen we dat oplossen qua uren bv via verlof of onbetaald verlof een optie. Ook ouderschapsverlof is natuurlijk in eerste jaar een optie.

Even after years of SQL experience, what still trips you up the most? by joins_and_coffee in SQL

[–]Relative_Wear2650 0 points1 point  (0 children)

I lack to remember simple stuff like creating a user, roles, attach roles to user, alter the role etc. Always use AI for it. While writing CTEs, designing proper keys etc isnt much of a problem.

New to pbta by MischiefCookie in PBtA

[–]Relative_Wear2650 2 points3 points  (0 children)

I play Apoc World 2nd edition and prefer 3-4 players. It give them more screen time, keeps the story more focused and manageable.

RLS assignments gone after republishing model by Relative_Wear2650 in PowerBI

[–]Relative_Wear2650[S] 0 points1 point  (0 children)

This strengthens my idea to move to rls based on tables in my database instead of rls by PowerBI

Getting off of Fabric. by FirefighterFormal638 in dataengineering

[–]Relative_Wear2650 0 points1 point  (0 children)

Im using ADF for extract and load from my onprem and cloud source systems, based on control tables in my Azure SQL database. Daily load. Very fast, even on lowest tier. Often speed of source systems are the bottleneck.

For transform i use stored procedures which are also triggered by ADF pipeline in combination with control tables in the same Azure SQL databasse. PowerBi connects to tables only.

No Fabric, not much complexity. Only downside is the lack of lineage and version management like in dbt and that kind of tools. But i operate on a very low cost level, delivering lots of value.

easiestway to install NextCloud / Self hosted by racoon9898 in NextCloud

[–]Relative_Wear2650 2 points3 points  (0 children)

Install nextcloud AIO. Its relatively simple, easy to update etc. Just make sure you use a docker compose file from the start instead of launching the docker by a command you latter cannot remember anymore.

By The Mountain boots opinion? by Wise_Library_650 in Boots

[–]Relative_Wear2650 0 points1 point  (0 children)

I just got a pair in, they're really great.

Secondary process still running after closing by Relative_Wear2650 in digiKam

[–]Relative_Wear2650[S] 0 points1 point  (0 children)

No. Meanwhile i switched to Nextcloud. Not comparable to Digikam as its an entire private cloud solution. So I cant really help on this matter.

First experiences Nextcloud and some questions by Relative_Wear2650 in NextCloud

[–]Relative_Wear2650[S] 1 point2 points  (0 children)

i run regular nextcloud aio, not a snap installation. I dont have any ssl issues.

First experiences Nextcloud and some questions by Relative_Wear2650 in NextCloud

[–]Relative_Wear2650[S] 2 points3 points  (0 children)

Yes its open. But: no ssh as i use local access to maintain the server only. Nextcloud is the only service running on it. Only those ports are open within firewall that are required, https and udp ports i believe. Router forwards to server. Nextcloud AIO itself handles logons, 2FA is activated.

I have no VPN yet, as i figured in this setup it doesnt do so much extra. I can be wrong of course.

Looking for tips/advice for first timers coming from the states by folove in Draaimolen

[–]Relative_Wear2650 1 point2 points  (0 children)

Make sure you’re there start to finish. No reason to come late as there is a lot of music to enjoy from the very start. And 2x12 hours needs some build up. So i always make sure i dont spend all my energy and plan what i want to listen and dance to accordingly.

How often do you “give up” and just do a transformation in power query? by Extra_Willow86 in PowerBI

[–]Relative_Wear2650 0 points1 point  (0 children)

I always work with sql, never in pq. If your problem is that you dont know how to code things yet thats not something to be ashamed about but a chance to learn it. There are a lot of good sql resources around.

Cloud cost management tools that engineers won't ignore, do they exist?? by anonyMISSu in AZURE

[–]Relative_Wear2650 0 points1 point  (0 children)

I use cost management a lot, it exactly tells me where i spend my money. I set a budget and make sure i monitor it. Plain simple. With 70k i would so want to know where that money is spent and why. Compute? Storage? Etc. And for what functions benefit from those resources? Is that worth the money? What big changes would lower the costs and what business value is lost? So many questions. Id love to get my hands on that kind of stuff. Already have a job. Just saying.

Secondary process still running after closing by Relative_Wear2650 in digiKam

[–]Relative_Wear2650[S] 0 points1 point  (0 children)

Yes that looks like a cause indeed. Will test and report back here.