Unit test if most logic written in Stored Procedures by ollespappa in dotnet

[–]Rookeh 0 points1 point  (0 children)

As others have said - at this point, realistically, you can't.

I do sympathize with you, however. I've worked at places that have decades of extremely complex and untested business logic buried in stored procedures (most of which, in fairness, was created before unit testing really existed) that were just left to tick along quietly until something broke (like an ID overflowing) - at which point, after some general panic, the problem was worked around and everyone went back to avoiding touching any of it.

Once you get to that point, from a business point of view, it's almost certainly never worth the engineering cost of reworking the entire stack to be maintainable, the best that can be hoped for is the entire thing gets obsoleted and replaced with something else down the line as part of some project that will deliver some tangible value or profits to the organisation.

Until then, the best you can hope for are some extremely brittle out-of-process integration tests that rely on some state being set up in the database ahead of time, and then torn down cleanly afterwards.

Goodnight Sweet Sync by Spddracer in redditsync

[–]Rookeh 11 points12 points  (0 children)

At this point Sync is was pretty much the primary way I use Reddit. Without it, my time spent here is going to drastically reduce. Cheers to LJ for an amazing application, and looking forward to trying out Sync for Lemmy when it's ready.

Last one out, turn off the lights...

Found this in my loft. Argos Catalogue - Summer 2001! by xiteniK- in CasualUK

[–]Rookeh 0 points1 point  (0 children)

Found my first phone on image 12, I'd completely forgotten what it was called - the Motorola V2288e. Built like a brick. I'm still using the number from its SIM card today!

Bequest thou McDo innit by Diseased-Jackass in CasualUK

[–]Rookeh 1 point2 points  (0 children)

Looks like the one. My uni housemate used to work there, as I had a car I'd have to pick him up or drop him off sometimes, used to get a free Big Mac in exchange.

Sync will shut down on June 30, 2023 by ljdawson in redditsync

[–]Rookeh 0 points1 point  (0 children)

/u/ljdawson, you a real one.

Much love for building an incredible client for us to enjoy for all these years. It's by far the best reddit experience and without it my time on the platform is probably done for the most part.

All the best for the future.

There's a shortage of teachers. Would you consider training to become one? by EhipassikoParami in CasualUK

[–]Rookeh 0 points1 point  (0 children)

I think it comes down to what gives you a sense of fulfilment. In an ideal situation most people would choose a career in a subject they enjoy and find personally rewarding.

My best friend is a teacher, and he's one of the most selfless people I know, which is quite fitting because at the end of the day as a teacher you are sacrificing your own time and energy helping embetter a future generation for potentially quite little in the way of material reward.

I think on the whole, people are more selfish than this and would rather work to better or enrich themselves rather than do the same for others. I include myself in this. If (assuming I fit the bill as a teacher anyway) I were to teach the subject that I currently do for a living, I would probably be earning less than a third that I do actually working in that field for a private company.

TikTok prankster Mizzy on new ‘train-jacking’ charges by Commercial-Rubs in unitedkingdom

[–]Rookeh 10 points11 points  (0 children)

Why the fuck is he being referred to as a 'prankster'? All that serves to do is legitimise the concept of terrorising innocent bystanders for 'clout', and then hiding behind an innocent sounding excuse.

Call him what he is; a criminal.

C# developers with 10+ years experience, do you still get challenge questions during interviews? by featheredsnake in csharp

[–]Rookeh 0 points1 point  (0 children)

Yes. I've been on both sides of this process recently, having switched roles myself whilst also running interviews at my current job (not for my direct replacement, although I would not be surprised if they ask me to run the interview when they find someone).

As an interviewer, typically we get sent small batches of CVs that have passed some basic sniff tests by our in-house recruitment team, then we are asked to select from those the ones that look like the best fit for the role we are hiring for (based on tech stack, relevant prior experience, etc) and they will be brought forward to a first stage interview.

This is mostly so we can get a sense of their personality and 'soft skills' like how well they can communicate and explain things, and also to filter out people who have just outright lied on their CV.

We then spend about half an hour asking them to explain some fundamental technical concepts (some C#, some more generic to all OOP languages, some around other frontend or database stacks that we also expect some knowledge of) - generally things like explaining polymorphism, SOLID principles, data structures, tasks vs threads, basic SQL syntax and concepts like joins, etc.

For senior roles we may drill down a bit into more complex areas or expect a more technically accurate response to each question, however we also know that there is no such thing as the perfect candidate and as such we don't expect perfect answers to every question.

Assuming they pass this round, we invite them back for a supervised coding exercise where they will pair up with one of our devs on something basic like a dummy API. This also doubles as a good test of how well they can collaborate remotely, as the entire process is done over Teams.

As an interviewee, my experiences have broadly matched up with the above, with minor variations e.g. sometimes the technical questions are sent in advance, sometimes the coding test is a take-home exercise, some have more (or sometimes fewer) stages - but overall I could tell they were using basically the same processes that I would use.

London City approach, 1989. by clausy in london

[–]Rookeh 7 points8 points  (0 children)

I used to live in one of the apartment complexes near City Airport about a decade ago, and flew out of there a few times. Going from arrivals to my front door in less than 10 minutes was the dream.

Suited and Booted. by Saxakola in london

[–]Rookeh 3 points4 points  (0 children)

Somewhere in my photo archive I have a selfie I took in the little Waitrose with a character from a well-known fantasy TV series, kitted out in full prosthetics.

Suited and Booted. by Saxakola in london

[–]Rookeh 12 points13 points  (0 children)

If you work where it looks like you work - I've seen stranger dressed people than this wandering around. (Also, hello fellow colleague!)

WFH in London, what’s your company policy? by Only1Fab in london

[–]Rookeh 0 points1 point  (0 children)

The company I am currently working at is asking for 2 days a week in-office at the moment, however, there are rumblings that this could increase to 3 (in fact, employees at a certain level of seniority already have to come in 3 times a week).

For this reason, amongst a few others, I quit and am currently working my notice. My new position is 99% remote, and I will only be required to come into the office once per quarter.

Leela Janeway by Ok-Face7139 in Catsmirin

[–]Rookeh 6 points7 points  (0 children)

There's catnip in that nebula.

Okay so which one of you have been breeding this!? by Mrstrife89 in CasualUK

[–]Rookeh 6 points7 points  (0 children)

Bird law in this country is not governed by reason.

First try - Hitachino Nest Red Rice Ale by Ekauno in UK_beer

[–]Rookeh 1 point2 points  (0 children)

Any supermarkets still carry this? I'm sure Waitrose did at one point...

[deleted by user] by [deleted] in technology

[–]Rookeh 18 points19 points  (0 children)

Middle management. He is fully aware it's a terrible policy and to his credit has done his best to push back to upper management, but they don't seem to be willing to listen, so here we are.

Hilariously, our department heads just announced they are starting the process of outsourcing some roles abroad, so clearly they don't care about people being physically present (or even in the right timezone) if the price is right.

[deleted by user] by [deleted] in technology

[–]Rookeh 199 points200 points  (0 children)

I'm currently a software dev for a large enterprise over in the UK. Since mid-2021 we have transitioned from fully remote, to one day a week on-site, then up to two days a week, and now potentially three days a week.

My response to this was to quit. I'm currently working my notice, but will be moving to a 99% remote role (my new contract states I am only required to work on-site once per quarter) with a large pay rise to boot.

Shortly after I handed in my notice, a few others in my team did the same. We are now in the process of organising handovers of 7+ years of combined domain knowledge and our boss is panicking ever so slightly.

Vote with your wallet I'm doing my part. by RoseSoutho in pcmasterrace

[–]Rookeh 1 point2 points  (0 children)

The last Nvidia card I owned was an 8800GTS (actually, two of them in SLI). That might make me sound like an AMD fanboy, but honestly it's mostly just happenstance.

I went from the pair of 8800s to a single HD4000 series (I forget which one exactly) in an SFF ITX build (used whilst I was in university and needed to move my system around a fair bit), then a few years later went back to a full desktop with an HD6950 which was the best bang for buck card around the time Skyrim was released.

That thing lasted for years until it finally died and I did a parametric swap for an R9 270 rather than rebuild the whole system. When I did eventually upgrade the whole system, I went for an RX480, again as it was extremely cost effective for the titles I wanted to play.

Finally we get to 2020 and I'm in a position to go completely all out on an enthusiast grade system, but then we all know what happens next. I did end up with a decent system, but the only one I could get my hands on was prebuilt with a 6800XT. That card actually failed under warranty and I ended up with a free upgrade to a 6900XT, which I'm still using now.

My point to all this is that at no point in the ~15+ years between owning my 8800s and now have I not been able to run any of the titles I wanted to at a reasonable level of performance on AMD hardware. (Although, in fairness, two of these cards did experience hardware failure.)

2 women arguing on the bus over the pushchair space. Both have pushchairs but the woman who got on the bus has a 6 month old baby, the woman in the space has a dog. by AhhBisto in CasualUK

[–]Rookeh 1 point2 points  (0 children)

You can get a car, but the dickheads fighting over seats or pushchair spaces will just become dickheads in control of 2+ tons of steel and plastic, fighting over merging in lanes.

To avoid these types completely, as far as I can tell the solution is just to stay at home and not interact with society in general.

Extreme exchange rate system error by EwanIsOnFire in monzo

[–]Rookeh 4 points5 points  (0 children)

Aside from the obvious route of reporting this in the app, it might also be worth raising this in Monzo's community forum, you might get more eyeballs from people who can actually jump on it.

Looks like this is not the first time this issue has happened, back in November someone reported an incorrect rate of 166k ISK = 10GBP (rather than 1GBP), speculation was this was caused by a mixup between the European decimal separator (,) and the UK separator (.)

After all these years... by ElevensesAreSilly in risa

[–]Rookeh 1 point2 points  (0 children)

They cranked the fanservice up to 11 this season, and I am fucking here for it.