ChrSt

@ChrSt@hachyderm.io

Software (F#/.NET), Data (SQL Server and Postgres) and general IT Infra for a German local bank.

This profile is from a federated server and may be incomplete. Browse more on the original instance.

foone, to random
@foone@digipres.club avatar

It has been ZERO days since I crashed windows 10 trying to hack on a DOS game

ChrSt,

@foone while I sympathize with you, I also assure you (as your are most certainly aware), there are people with issues of more concern ;)

gvwilson, to random
@gvwilson@mastodon.social avatar

Is this a correlated subquery? If so, would a join be more efficient? https://stackoverflow.com/questions/77879979/is-this-a-correlated-subquery-if-so-would-a-join-be-more-efficient

ChrSt,

@gvwilson an sufficiently advanced query optimizer might produce equal („optimal“) execution plans for either query.

ChrSt,

@gvwilson and I can confirm (as I just tested it); SQL Server does recognize this and produces the same plan for the join or the correlated sub query.

ChrSt,

@gvwilson The query, as you wrote it, contains a correlated subquery. BUT it will not be executed as such (depending on the software used…). The optimizer understands the nature of the query and rewrites it, before executing, resulting in the same performance, as if written like a join.

For example: I have tables Process and Structures – they have a 1:n relationship.
The following queries execute the same, under the hood, as the execution plans are the same.

ChrSt,

@gvwilson One more thing though;

When you make the join "wrong" (forgetting the DISTINCT) you get a different plan and wildly different results ;)

exa, to mastodon
@exa@mastodon.online avatar

implementation question: would it be possible to use the protocol for carrying issue tracking & discussion, e.g. to make version of or issue trackers?

I thought that technically these aren't that different from the usual discussion threads here, except maybe for some governance steps like deciding if the issue is closed etc... Perhaps someone already investigated?

ChrSt,

@exa isn’t a kind of federation already being implemented by Gitlab?

ChrSt,

@exa https://gitlab.com/groups/gitlab-org/-/epics/11247 is what I was thinking about

ChrSt,

@kik @exa awesome!
I’m so much looking forward to the future, where we have the flexibility and distributedness of mailing lists, combined mit modern amenities of tools like Gitlab/Forgejo. Fedi is already so much an improvement other the zentralized monoliths – despite its flaws…

ChrSt,

@kik Completely agree. It's nice seeing it coming together. I'm grateful for ppl like you, advancing those endeavors!

Rairii, to random

looks like some of my patches only work on the multiprocessor kernel for now lol

ChrSt,

@Rairii been following your journey with this for some time now, which I highly enjoy. But I am wondering – purely out of curiosity; why are you doing this? (I just like to understand ppls motivations)

ChrSt, to dotnet German

Ever had to work with "raw" byte arrays in ?
Then please take a look at https://github.com/ChrSteinert/ArrayPrinter

It's a byte array pretty printer, for which I would love feedback/suggestions/issues/PRs.

csoriano, to random

One thing I saw in comments about the removal of xorg server is that some might not see how much work is/was to maintain xorg server. I understand is hard to see from outside, but maintaining xorg server with the standards we have in RHEL is not a small beast. Let me share some:

ChrSt,

@csoriano @Zaney @thelinuxcast …
Some additional pieces for the next X vs Wayland discussion on stream! ;)

thelinuxcast, to random
@thelinuxcast@fosstodon.org avatar

A Check in for the less than 600 days left.

ChrSt,

@thelinuxcast what will you do afterwards? (Just a guess since it is long into the future)

itsfoss, to linux
@itsfoss@mastodon.social avatar

Take a look at these YouTube channels if you're a Linux user. 🐧🖥️

https://itsfoss.com/linux-youtube-channels/

ChrSt,

@itsfoss @thelinuxcast hey Matt, have you seen that your are featured?

itsfoss, to linux
@itsfoss@mastodon.social avatar

Recently, some vital info was disclosed about elementary OS 8!

https://news.itsfoss.com/elementary-os-8-dev/

ChrSt,

@itsfoss

mjg59, to random
@mjg59@nondeterministic.computer avatar

I've been spending about half my time this summer with a 500MBit symmetric link, and the other half at about 20MBit. It's genuinely kind of surprising how little difference this has ended up making.

ChrSt,

@mjg59 recently downgraded to 100/30MBit from 500/100MBit (because we moved).

So far we are not missing a thing.
3 PPL working full time remote jobs

Rairii, to random

wait wait wait people were running windows server frankenbuilds IN PRODUCTION?????

ChrSt,

@Rairii we migrated off of a Buch of 2012R2 just a few weeks ago …
(In place upgrades :/ )

ChrSt,

@jernej__s @Rairii I guess so.
Seems to be more consistent, than SQL Server in-Place upgrades, where I don’t have a lot of good memories of …

itanium, to random

4 "outlooks" represented here:
•Metro-mail (most resource efficient by over an order of magnitude).
•"Edge" only has one tab opened, in OWA.
•"New Outlook Preview" WebView2 based.
•Win32 Outlook
All 4 are opened in Inbox and previewing the same message.

ChrSt,

@itanium Metro/WPF is not that bad after all :)
I miss these days …

iangriffin, to Astronomy
@iangriffin@mastodon.nz avatar

]Have you ever wondered how much the sun moves in one day? Probably not. But those of us who care about these things and enjoy observing the motions of the sun in the sky do it. We're called observers. Here are two photographs taken one day apart at the same time from the deck of my home in Portobello New Zealand, where, every day, the sun is getting higher in the sky as we run up to summer. . You can also see the solar rotation as the sunspot has moved!

ChrSt,

@iangriffin this is awesome. Thanks for sharing!

foone, to random
@foone@digipres.club avatar

sometimes you have a good day and then other days you learn there's a language called Caché ObjectScript which brings classes to MUMPS

ChrSt,

@foone the What brings classes to What?

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • megavids
  • khanakhh
  • mdbf
  • ethstaker
  • magazineikmin
  • GTA5RPClips
  • rosin
  • thenastyranch
  • Youngstown
  • InstantRegret
  • slotface
  • osvaldo12
  • kavyap
  • DreamBathrooms
  • JUstTest
  • Durango
  • everett
  • cisconetworking
  • normalnudes
  • tester
  • ngwrru68w68
  • cubers
  • modclub
  • tacticalgear
  • provamag3
  • Leos
  • anitta
  • lostlight
  • All magazines
    •