Lightnews — Scholar-powered news

Klaus Aschenbrenner @sqlpassion.at · 49m

Deploying Cloud-Init VM's with Linux is just easy-going. Doing the same with Windows-based VMs is just PITA...

Klaus Aschenbrenner @sqlpassion.at · 18h

ARM64 support - finally!!! :-)

Erin Stellato @erinstellato.bsky.social · 21h

🚨 It's another two-for-Tuesday over in the SSMS team!

Announcing the release of SSMS 22 Preview 3 and SSMS 21.6!

SSMS 22 Preview 3 includes:

- GitHub Copilot in SSMS

- ARM64 support for core SSMS scenarios

Start with Makena's post: techcommunity.microsoft.com/blog/sqlserv...

Enjoy! 👯‍♀️

Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub

The SSMS team is delighted to announce the release of SQL Server Management Studio (SSMS) 22 Preview 3. This latest preview is chock full of exiting new...

techcommunity.microsoft.com

1

Reposted by Klaus Aschenbrenner

Erin Stellato @erinstellato.bsky.social · 21h

🚨 It's another two-for-Tuesday over in the SSMS team!

Announcing the release of SSMS 22 Preview 3 and SSMS 21.6!

SSMS 22 Preview 3 includes:

- GitHub Copilot in SSMS

- ARM64 support for core SSMS scenarios

Start with Makena's post: techcommunity.microsoft.com/blog/sqlserv...

Enjoy! 👯‍♀️

Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub

The SSMS team is delighted to announce the release of SQL Server Management Studio (SSMS) 22 Preview 3. This latest preview is chock full of exiting new...

techcommunity.microsoft.com

2 9 17

Reposted by Klaus Aschenbrenner

Alex Miller @alexmillerdb.bsky.social · 1d

This reminded me I've been sitting on draft blog posts about Copy-and-Patch JIT compilation for a while, and so I've finally published the first chunk of it: a minimal tutorial and explanation of how and why Copy-and-Patch actually works.

Start at transactional.blog/copy-and-pat...

3 9

Reposted by Klaus Aschenbrenner

Phil Eaton @eatonphil.bsky.social · 1d

JIT: so you want to be faster than [the PostgreSQL] interpreter on modern CPUs

www.pinaraf.info/2025/10/jit-...

JIT: so you want to be faster than an interpreter on modern CPUs… – Pinaraf's website

www.pinaraf.info

3 8

Klaus Aschenbrenner @sqlpassion.at · 2d

[Blog] Understanding Upstream vs. Downstream PostgreSQL: www.sqlpassion.at/archive/2025... #sqlpassion #postgres #PostgreSQL

Understanding Upstream vs. Downstream PostgreSQL – SQLpassion

www.sqlpassion.at

Reposted by Klaus Aschenbrenner

Tanel Poder @tanelpoder.com · 3d

pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL

tanelpoder.com/posts/genera...

2 4

Klaus Aschenbrenner @sqlpassion.at · 7d

My workspace for today was nice 😊

3

Klaus Aschenbrenner @sqlpassion.at · 12d

This was now a fully automatic VM deployment into my Proxmox Home Lab across 3 nodes :-) #Proxmox #Terraform #Ansible #Linux

2

Klaus Aschenbrenner @sqlpassion.at · 13d

Proxmox + Terraform + Ansible = ❤️❤️❤️

I can deploy now fully automated VMs on Proxmox across different Linux distributions (RHEL, Ubuntu) with Terraform and configure them with Ansible. #Proxmox #Terraform #Ansible #Linux

1 2

Klaus Aschenbrenner @sqlpassion.at · 15d

After a lot of work, I'm finally able to deploy through TerraForm template VMs and clones to my Proxmox Home Lab. Infrastructure as Code rocks! :-) #Proxmox #Terraform #IaC

Klaus Aschenbrenner @sqlpassion.at · 16d

I didn't knew that, but @proxmox.bsky.social allows you to "fake" NUMA nodes on SMP systems - *nice* - but only for testing purposes... :-)

Reposted by Klaus Aschenbrenner

Alex Miller @alexmillerdb.bsky.social · 16d

[ASPLOS'25] Fusion: An Analytics Object Store Optimized for Query
Pushdown
www.cs.princeton.edu...

Tightly integrating an Iceberg catalog with an object store means that one could make file-format aware erasure coding decisions, to permit pushing down filters and aggregations.

4 14

Reposted by Klaus Aschenbrenner

Franck Pachot @franckpachot.bsky.social · 16d

More WiredTiger internals: persisting MongoDB's committed MVCC versions through checkpoints and restarts dev.to/franckpachot...

WiredTigerHS.wt: MongoDB MVCC Durable History Store

MongoDB uses the WiredTiger storage engine, which implements Multi‑Version Concurrency Control (MVCC)...

dev.to

1 2

Klaus Aschenbrenner @sqlpassion.at · 16d

[Blog] What’s New in PostgreSQL 18: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres

What’s New in PostgreSQL 18 – SQLpassion

www.sqlpassion.at

1

Klaus Aschenbrenner @sqlpassion.at · 16d

Having some fun with Red Hat :-) #rhel #linux

Klaus Aschenbrenner @sqlpassion.at · 17d

It’s time for me to buy a Red Hat ⛑️ #rhel

Reposted by Klaus Aschenbrenner

Hugo Kornelis @hugokornelis.bsky.social · 18d

New blog post live! In part 3 of the deep dive into hash tables, I will show you how to use our knowledge of the structure of the hash table to identify hash collisions from looking at query results.
#SQLServer

sqlserverfast.com/blog/hugo/20...

A deep dive into hash tables, part 3 - SQLServerFast

Welcome back! In the previous parts, I first showed how a Hash Match (Left Outer Join) can give insight in the order of data in a hash table, and then used that trick to obtain and verify some interes...

sqlserverfast.com

2 4

Klaus Aschenbrenner @sqlpassion.at · 18d

My day so far: "rosetta error: Unimplemented syscall number 395"

Klaus Aschenbrenner @sqlpassion.at · 18d

Hello #PostgreSQL 18.0 :-)

2

Reposted by Klaus Aschenbrenner

DuckDB @duckdb.org · 19d

We published a new deep dive by Laurens Kuiper, who recently redesigned DuckDB's sort.

One data point: ordering the TPC-H SF100 lineitem table with the memory limit set to 30 GB is 3× faster in DuckDB v1.4 than in v1.3.

Read more at duckdb.org/2025/09/24/s...

Redesigning DuckDB's Sort, Again

After four years, we've decided to redesign DuckDB's sort implementation, again. In this post, we present and evaluate the new design.

duckdb.org

9 32

Klaus Aschenbrenner @sqlpassion.at · 19d

It's quite funny to see the differences when you run the TPC-H benchmark (with a scaling factor of 50) in DuckDB simultaneously on my MacBook Air with 24 GB RAM and on the Framework 13 Notebook with 64 GB RAM...

1 1

Klaus Aschenbrenner @sqlpassion.at · 20d

It took *hours* to install and update Windows 11. The installation and patching of Linux Ubuntu was done in less than 30 minutes on the @frame.work notebook! 👌

1 1 3

Klaus Aschenbrenner @sqlpassion.at · 20d

#PostgreSQL 18 Released! www.postgresql.org/about/news/p...

PostgreSQL 18 Released!

The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html), the latest version of the worl...

www.postgresql.org

1 1

Klaus Aschenbrenner @sqlpassion.at · 20d

Who on earth needs a CoPilot in Notepad on Windows 11??? Linux is getting more and more attractive these days...

2 6