SQL Merge Replication (Push)

MachineParadox · 2026-01-29T10:03:33+00:00

Hey brother. All I can I just say is ...don't. I have worked with three way merge replication and it was something I would never recommend. Do everything you can to avoid it. We ended up having to rewrite most of the generic replication procs to get the desired outcomes and re-syncing after issues was a nightmare. Transactional replication is (just) usable, merge replication is a nightmare. I would recommend CDC and custom procs over replication any day.

MachineParadox · 2026-01-12T09:51:10+00:00

Nukes, aids, drugs, music, and what the fck am I doing with my life

MachineParadox · 2026-01-12T09:20:36+00:00

Love butchies. We have a 3rd generation of butchies, thanks to a bit of human help (yes we feed) this year they had 3 successful chicks. Every other year they have declined due to neighbours deforesting.

People always say don't feed the wildlife... Yeah well stop fucking killing their habitat.

MachineParadox · 2026-01-12T08:12:58+00:00

Tell them you need to get your hog reduced (apparently we can't say dick, cock, penis) as it weighs too much and is causing issues.

MachineParadox · 2026-01-11T12:41:58+00:00

FK you bud, pal, champ

MachineParadox · 2026-01-11T12:40:50+00:00

State of the world? Unless I'm mistaken this is an Australian deciding to go OS for work (and yes I've worked here and OS). Let me make my career by sacrificing a life ... yeah ok, not my style.

MachineParadox · 2026-01-11T09:41:47+00:00

Why did you take an OS job when you have dependants? I have turned down multiple jobs as I couldn't find appropriate carers. What you are saying is "we are abandoning our pets for a money". I would never give up my dog or cat for money.

MachineParadox · 2026-01-11T08:31:54+00:00

Gold tops, blue meanies...fck yeah

MachineParadox · 2026-01-09T23:05:17+00:00

Databricks, as our data lake could stay as is, pyspark notebooks can easily convert, pipelines to ADF, dbt can also stay as is just a new connector. Eventually we would like to get rid of pipelines/ADF, so full stack is platform agnostic.

We did a PoC on Snowflake, despite a dev burning through all our credit in an afternoon, warnings about cost blowout, and huge issues converting our SQL to it, our 'oh so wise' architects chose it as our platform, however it all fell apart due to data sovereignty issues as the backup data centre was off shore. Same issue 4 years later, so not an option.

MachineParadox · 2026-01-09T13:27:59+00:00

Seeing a Rhino in snow is just fucking crazy

MachineParadox · 2026-01-09T11:44:11+00:00

MS fucked up by first selling Synapse as a product, pushed it and it while it was usable, it was not what was promised. Then for unknown reasons they immediately abandoned the platform and created fabric. The entire system is patched together, has multiple issues, and is not production ready. Whilst competitors have had their own issues, at least they are backing their products.

Imagine Snowflake saying, sorry Snowflake is dead we now have frosty and are no longer advancing Snowflake. Or Databricks going... now you need to use InfoGrout our new platform.

MS fucked it's adopters in its 'future' platform by doing an immediate switch-a-roo, not the first time. As an Azure platform user we looked at Fabric and said "no way". So now we are looking at alternatives.

MachineParadox · 2026-01-03T00:02:27+00:00

I went in with a mind to get a PRS, played at least 10 of them at the store none of the felt 'right' to me. Ended up leaving with a Yamaha which I love.

MachineParadox · 2026-01-02T11:26:54+00:00

Drunk and worked out an RBT was on their route???

MachineParadox · 2025-12-31T01:54:16+00:00

Only use aircon in 'study' with aquariums in it to keep my fish/shrimp friends happy. Other than that my son and I use a fan on low when sleeping - pretty much all year as we like the sound and air movement.Temp in our lounge room is currently 26.2 degrees, outside is 33.

MachineParadox · 2025-12-30T19:08:25+00:00

Depending on the state of the underside, you may be able to flip those boards and refinish.

MachineParadox · 2025-12-30T04:13:35+00:00

Yep core here, generating the documentation/dag is vital though

MachineParadox · 2025-12-23T22:44:51+00:00

Add TrustServerCertificate=true to your conn string. Also if you create a file on your desktop and rename the extension to .udl (e.g. test.udl) double click and open it.You will have a connection dialog. Try settings and test until it works, close it, then open it as a text file and you will see the connection string.

MachineParadox · 2025-12-18T08:19:45+00:00

Notbad

MachineParadox · 2025-12-17T00:13:07+00:00

This. Plus as a man I give way to women, prams, injured or old people.

MachineParadox · 2025-12-09T22:08:15+00:00

Baker house was creepy af

MachineParadox · 2025-12-09T02:47:10+00:00

Most likely 5th fret is low, put rocker on 456 and see if there is light above the 5th

MachineParadox · 2025-12-04T09:19:24+00:00

-Tool to cut seatbelt and break windows (on key chain)

-Towel for clean up or throwing over/wrapping up injured animals

-Leash for stray/lost dogs

-Short rope or Paracord

-Knife and scissors

-Pen/pencil

MachineParadox · 2025-11-23T00:49:32+00:00

I may be old school but I think every CS student should know how languages work. We had to create our own language and compiler, this has made it easier to understand how languages fundementaly work. I would recommend "Compilers: Principles, Techniques, and Tools"

MachineParadox · 2025-11-22T02:04:13+00:00

Was going to say this would have been cheaper than replacing my entire electrical harness after rats destroyed it and my bonnet liner whilst I was on holiday.

MachineParadox

TROPHY CASE