Klaus Aschenbrenner
banner
sqlpassion.at
Klaus Aschenbrenner
@sqlpassion.at
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.
Reposted by Klaus Aschenbrenner
SQL Server 2025 Is Out, and Standard Goes Up to 256GB RAM, 32 Cores!

Today marks the official birthday of Microsoft SQL Server 2025. Here's where to download the evaluation version. Here are the top things you wanna consider as you talk to your managers, developers, and end users. The feature…
SQL Server 2025 Is Out, and Standard Goes Up to 256GB RAM, 32 Cores!
Today marks the official birthday of Microsoft SQL Server 2025. Here's where to download the evaluation version. Here are the top things you wanna consider as you talk to your managers, developers, and end users. The feature differences between 2025 Enterprise and Standard have been revealed, and the news for Standard Edition folks is spectacular: it now supports up to 32 CPU cores and 256GB RAM!
www.brentozar.com
November 18, 2025 at 4:24 PM
Reposted by Klaus Aschenbrenner
S3 is powered by millions of HDDs.

This Andy Warfield article is a fascinating look under the covers one of the largest storage systems on earth.

I particularly enjoyed the discussion of scaling both the technology and ones self as an engineer.

www.allthingsdistributed.com/2023/07/buil...
November 17, 2025 at 2:50 PM
When you create an ordered Non-Clustered Columnstore Index in SQL Server 2025, you need to do it single-threaded (MAXDOP = 1) to get a perfectly working Segment Elimination. The same also applies to Ordered Clustered Columnstore Indexes... #sqlserver #columnstore
November 17, 2025 at 11:53 AM
[Blog] Master SQL Server Performance Tuning – Black Friday Sale: 50% Off All Online Trainings: www.sqlpassion.at/archive/2025... #sqlpassion #performance #blackfriday
Master SQL Server Performance Tuning – Black Friday Sale: 50% Off All Online Trainings! – SQLpassion
www.sqlpassion.at
November 17, 2025 at 10:24 AM
ProTip: if you have spare CPU cycles available, just use RegEx in SQL Server 2025...
November 15, 2025 at 4:11 PM
When you create a 230 GB database in SQL Server 2025, just to be able to demonstrate ZSTD backup compression more seriously... #sqlserver
November 15, 2025 at 1:58 PM
The whole story about JSON indexes in SQL Server 2025 is just a big, late Aprils fool. @brento.bsky.social has summarized it quite well in his blog posting: www.brentozar.com/archive/2025....

And I'm getting even worser execution plans with my test data...
November 14, 2025 at 9:16 PM
PostgreSQL has support for the native JSONB data type since version 9.4 - which was released in the year *2014*. SQL Server 2025 will provide a native JSON data type 11 years later... #SQLServer #PostgreSQL #postgres
November 14, 2025 at 4:40 PM
Reposted by Klaus Aschenbrenner
Our website recently got an upgrade! It was initially built on WordPress in 2016 then after several hacks, was exported to HTML and put on @github.com's Pages in 2020. Now, it's been redesigned using Hugo and Claude Code. Let us know what you think!
dbatools | Command-line superpowers for SQL Server automation
A free, open-source PowerShell module with 600+ commands that make SQL Server administration simple, powerful, and fun.
dbatools.io
November 13, 2025 at 7:53 PM
The whole story about concurrency gets crazy in SQL Server:

* Pessimistic Concurrency since its beginnings
* Since SQL Server 2005 we have Optimistic Concurrency (RCSI, SI).
* Since SQL Server 2019 has Accelerated Database Recovery (ADR), which provides a Persistent Version Store (PVS) for RSCI/SI
November 13, 2025 at 4:38 PM
Reposted by Klaus Aschenbrenner
SQL Server Management Studio (SSMS) 22 is now Generally Available (GA)!!! 🥳 techcommunity.microsoft.com/blog/sqlserv...
November 11, 2025 at 8:49 PM
Reposted by Klaus Aschenbrenner
Nach wüsten Beleidigungen durch einen Hassposter führt der Journalist @arminwolf.at ein kafkaeskes Verfahren gegen Elon Musks Plattform – und demonstriert damit, was vom Recht im Netz geblieben ist
ORF-Anchorman Armin Wolf: „Warum ich die Plattform X anzeige“
Nach wüsten Beleidigungen durch einen Hassposter führt der Journalist ein kafkaeskes Verfahren gegen Elon Musks Plattform – und demonstriert damit, was vom Recht im Netz geblieben ist
www.falter.at
November 11, 2025 at 5:41 PM
And another (side) project begins… #TrueNAS
November 11, 2025 at 9:21 PM
Lock-After-Qualification (LAQ) leads to different query results in SQL Server 2025: learn.microsoft.com/en-us/sql/re... #sqlserver #sqlserver2025
Optimized Locking - SQL Server
Learn about the optimized locking enhancement to the database engine.
learn.microsoft.com
November 11, 2025 at 3:44 PM
Final preparations for my upcoming webcast about #PostgreSQL tomorrow morning. There is still time to sign-up: www.sqlpassion.at/archive/2025...
November 11, 2025 at 12:38 PM
Reposted by Klaus Aschenbrenner
Much of the the internet runs on Elastic Block Storage.

It's the default (and in most cases, required) storage layer for every EC2 instance running in AWS.

This article by Marc Olson was a delightful read on its history and engineering challenges.

www.allthingsdistributed.com/2024/08/cont...
November 6, 2025 at 2:55 PM
Understanding PostgreSQL WAL and optimizing it with a dedicated disk: stormatics.tech/blogs/unders... #PostgreSQL #postgres
PostgreSQL WAL: Boost Performance with a Dedicated Disk
Learn how to speed up PostgreSQL by moving WAL to its own disk. Cut I/O contention and improve write performance safely.
stormatics.tech
November 6, 2025 at 2:25 PM
When you combine triathlon and vector search in SQL Server 2025... 😁 #sqlserver #ai #vectorsearch
November 6, 2025 at 2:23 PM
It seems that EVE-NG would be a great addition to my Home Lab environment: www.eve-ng.net #VirtualNetworkEnvironment
Home -
EVE-NG Professional Edition Latest Now: Release 6.4.0-13, 1 October, 2025   EVE-NG PRO platform is ready for today’s IT-world requirements. It allows enterprises, e-learning providers/centers, individ...
www.eve-ng.net
November 6, 2025 at 12:41 PM
@glennalanberry.bsky.social Do you know if the AMD Ryzen 9 9950X3D CPU (in combination with the Asus ROG Crosshair X870E Hero ATX Motherboard) supports a maximum of 192 or 256 GB RAM? Thanks! :-)
November 5, 2025 at 2:08 PM
Calling the Azure OpenAI service directly from SQL Server 2025 to generate query embeddings, which will used afterwards for performing a vector search.

#SQLServer #Azure #OpenAI #LLM
November 5, 2025 at 2:04 PM
In comparison to the #PostgreSQL pgvector extension, the vector support in SQL Server 2025 is - let's say "rudimentary"... pgvector has much more querying and indexing functionality than SQL Server 2025... github.com/pgvector/pgv...
GitHub - pgvector/pgvector: Open-source vector similarity search for Postgres
Open-source vector similarity search for Postgres. Contribute to pgvector/pgvector development by creating an account on GitHub.
github.com
November 5, 2025 at 12:13 PM
Vector search in SQL Server 2025 is quite powerful. But the creation of the embeddings burns down *a lot* of energy. My RTX 3080Ti GPU was getting quite hot over the night. Thanks again to @sqlbek.bsky.social for his ready-to-use recipes database, which is available on github.com/SQLBek/Demo-....
November 5, 2025 at 10:54 AM