Lightnews — Scholar-powered news

Klaus Aschenbrenner

@sqlpassion.at

630 followers 140 following 17K posts

CEO & Founder of https://SQLpassion.at. SQL Server & PostgreSQL specialist during the day. Astrophotographer during the night. Triathlete in between. Loves low-level system programming in Rust.

SQLpassion.at.

Posts Media Videos Starter Packs

Klaus Aschenbrenner @sqlpassion.at · 1h

Making VS Vode Themes with ChatGPT!

Chrissy LeMaire @funbucket.dev · 1h

You can always make your own too

Making VS Code Themes with ChatGPT

I've been blown away by ChatGPT's vision features and have already used it for a ton of stuff, including: Taking a picture of my food and asking for the recipe …

blog.netnerds.net

Klaus Aschenbrenner @sqlpassion.at · 1h

... with comment lines, when you *highlight* them.

Klaus Aschenbrenner @sqlpassion.at · 1h

That's a nice one, but it has some issues with comment lines in yml files ;-)

Klaus Aschenbrenner @sqlpassion.at · 1h

Has someone a suggestion for a really good dark theme for VScode? I have already tried a lot, but some themes are not really dark (the background is not really black), and a lot of dark themes have problems with code highlighting...

1 1

Reposted by Klaus Aschenbrenner

Ben @benjdd.com · 4h

Years of database operations compressed into a 5 minute read.

Required reading for everyone building applications in the cloud.

PlanetScale @planetscale.com · 5h

PlanetScale's fault tolerance relies on simple principles, processes, and architectures, but the real work is in the execution. These are the principles we follow to keep our systems reliable.
planetscale.com/blog/the-pri...

The principles of extreme fault tolerance — PlanetScale

The principles and processes we follow for fault tolerance.

planetscale.com

2 5

Klaus Aschenbrenner @sqlpassion.at · 23h

Everything is configured through an Ansible inventory file. All the VMs are deployed in the first through Terraform from templates - which I also create in a fully automatic way :-)

This took me a lot of work and time over the last few weeks... #Terraform #Ansible #Proxmox #Virtualiation #IaaC

Klaus Aschenbrenner @sqlpassion.at · 23h

Ansible rocks!!! I'm now deploying and configuring my *whole* VM infrastructure with a single Ansible playbook. It creates a Windows DC, joins Windows VMs into the domain, installs SQL Server 2025 RC1, and also installs SQL Server and PostgreSQL on Linux (Ubuntu 22.04/24.04, RHEL 9.6/10.0).

2 1

Klaus Aschenbrenner @sqlpassion.at · 1d

Already submitted! :-)

Klaus Aschenbrenner @sqlpassion.at · 1d

[Blog] Bringing 10 Gbit to my Client Devices in my Home Office: www.sqlpassion.at/archive/2025... #sqlpassion #performance #homelab #networking

Bringing 10 Gbit to my Client Devices in my Home Office – SQLpassion

www.sqlpassion.at

Klaus Aschenbrenner @sqlpassion.at · 2d

Having some 10Gbit fun between client devices - Windows 11 and a Mac Book Air 🙂

Klaus Aschenbrenner @sqlpassion.at · 2d

For my German speaking friends: Hoch - hocher - am hochersten. Ja genau… 🙈🙈🙈 #ChatGPT #LLM

1 1

Klaus Aschenbrenner @sqlpassion.at · 2d

From a NAS perspective, I've fallen today in love with the Minisforum N5 Pro Desktop NAS unit, because I could install Proxmox on it, and also use it as a NAS with a ZFS file system: minisforumpc.eu/products/min...

Minisforum N5 Pro Desktop NAS

Minisforum N5 Pro Redefines Consumer NAS Performance Standards: Powered by AMD Ryzen™ AI 9 HX PRO 370, Zen5+Zen 5C Architecture, 12 Cores and 24 Threads, Max. Boost Clock up to 5.1 GHz.

minisforumpc.eu

Klaus Aschenbrenner @sqlpassion.at · 2d

Some new 10Gbit networking hardware has arrived: a 10G edge switch for the office, and a Thunderbolt 10G netword adapter for the MacBook Air 🤗

Klaus Aschenbrenner @sqlpassion.at · 2d

WANTED! 🤩

William Lam @lamw.bsky.social · 3d

Minisforum just keeps dropping the goods! 🔥

Upcoming MS-02 Ultra (Intel-based w/Hybrid Cores) looks to be beast! 😮

Not SFF (4L) but impressive:
🔹Intel Core Ultra 9 285HX (24c)
🔸4 x SODIMM (256GB)
🔹4 x M.2
🔸2 x 25GbE SFP+
🔹1 x 10GbE & 2.5GbE
🔸3 x PCIe Slots

Klaus Aschenbrenner @sqlpassion.at · 3d

Planning some additional 10Gbit upgrades in my Home network - mostly for a new NAS. I have already 10Gbit in the server rack itself, but I also need it on my MacBook Air and my Windows/Linux workstation.

1 1

Klaus Aschenbrenner @sqlpassion.at · 3d

@paulbraren.bsky.social I have seen your video www.youtube.com/watch?v=CrnE... about the E200-8D. I have the same server since 2017, and I'm just wondering which power cable you have used to provide power to the SSD? Thanks!

Supermicro SYS-E300-8D and E200-8D SuperServers weighed, measured, 2.5" Micron M510DC SSD installed.

YouTube video by TinkerTry | Paul Braren

www.youtube.com

Reposted by Klaus Aschenbrenner

Alex Miller @alexmillerdb.bsky.social · 4d

[PVLDB] Enhancing Transaction Processing through Indirection Skipping
www.vldb.org/pvldb/v...

Whereas VMCache improve pointer swizzing's complexity by removing the swizzling, this work points out that page and frame hints are highly effective, and okay if they're wrong.

1 2

Klaus Aschenbrenner @sqlpassion.at · 5d

In the last few days, I've installed Windows Server 2025 at least 100 to 200 times... automatically...

Reposted by Klaus Aschenbrenner

T. from Data Rocks @datarocksnz.bsky.social · 5d

Linux is pretty good, actually.

Also, big opportunity for companies to start making their official Linux versions of popular software, if they don't have it already.

3 1 14

Klaus Aschenbrenner @sqlpassion.at · 5d

I have a dual-boot Linux/Windows system, but I‘m really satisfied with the Linux desktop experience. And everything just worked!

Klaus Aschenbrenner @sqlpassion.at · 5d

Today I have achieved a lifetime goal: playing a game on Linux 💪

1 6

Klaus Aschenbrenner @sqlpassion.at · 5d

"Some of that data is the billions of minutes that people spend talking in Microsoft Teams meetings."

Klaus Aschenbrenner @sqlpassion.at · 5d

Thinking about buying the Miniforum MS-A2 workstation for my Home Lab. This would be a very nice replacement for my Super Micro E200-8D machine - and also a very portable option...

The other option would be the brand-new MS-S1 MAX...

MINISFORUM MS-A2

Kompakte Form, Spitzenleistung. Duale 10G SFP+, duale 2,5G LAN. Eingebauter PCIe x16 Steckplatz.

www.minisforum.com

Klaus Aschenbrenner @sqlpassion.at · 5d

And now I can already run Ansible playbooks against deployed Windows VMs :-)

1 2

Klaus Aschenbrenner @sqlpassion.at · 5d

It's there.