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.
If you store JSON data in SQL Server 2025, and you index it (you will have to index it!!!), plan your CPU consumption accordingly...
December 1, 2025 at 3:51 PM
If you store JSON data in SQL Server 2025, and you index it (you will have to index it!!!), plan your CPU consumption accordingly...
If you create a Clustered Primary Key with more than 32 columns, you have other more serious problems... #sqlserver
December 1, 2025 at 3:41 PM
If you create a Clustered Primary Key with more than 32 columns, you have other more serious problems... #sqlserver
[Blog] New on YouTube: PostgreSQL Introduction for the SQL Server Professional: www.sqlpassion.at/archive/2025... #sqlpassion #PostgreSQL #postgres
New on YouTube: PostgreSQL Introduction for the SQL Server Professional – SQLpassion
www.sqlpassion.at
December 1, 2025 at 2:13 PM
[Blog] New on YouTube: PostgreSQL Introduction for the SQL Server Professional: www.sqlpassion.at/archive/2025... #sqlpassion #PostgreSQL #postgres
Reposted by Klaus Aschenbrenner
"All of this falls apart if humans don't adopt the tech. This is why you've seen Meta cram its lame chatbots into WhatsApp and Instagram. This is why Notepad and Paint now have useless Copilot buttons on Windows. This is why Google Gemini wants to "help you" read and reply to your emails."
Analysis: OpenAI is a loss-making machine, how can it survive?
Don't call it a bubble! Loss-making monster OpenAI is on the hook for $1.4 trillion (with a T) in compute commitments. How can this go on?
www.windowscentral.com
November 29, 2025 at 11:30 PM
"All of this falls apart if humans don't adopt the tech. This is why you've seen Meta cram its lame chatbots into WhatsApp and Instagram. This is why Notepad and Paint now have useless Copilot buttons on Windows. This is why Google Gemini wants to "help you" read and reply to your emails."
Any ideas why I can't see in SSMS 22 (RTM) the Query Store on a Secondary Replica that runs on SQL Server 2025 RTM? #sqlserver
November 29, 2025 at 8:48 PM
Any ideas why I can't see in SSMS 22 (RTM) the Query Store on a Secondary Replica that runs on SQL Server 2025 RTM? #sqlserver
In preparation of my upcoming 10 GBit Home Network migration, I have rewired all existing 1 GBit connections directly to the Unifi Dream Machine Internet Router.
The existing 1 GBit switch will be replaced by a new Unifi Pro XG 24 switch, which provides me 8x 2.5GbE ports, and 16 (!) 10GbE ports.
The existing 1 GBit switch will be replaced by a new Unifi Pro XG 24 switch, which provides me 8x 2.5GbE ports, and 16 (!) 10GbE ports.
November 29, 2025 at 3:55 PM
In preparation of my upcoming 10 GBit Home Network migration, I have rewired all existing 1 GBit connections directly to the Unifi Dream Machine Internet Router.
The existing 1 GBit switch will be replaced by a new Unifi Pro XG 24 switch, which provides me 8x 2.5GbE ports, and 16 (!) 10GbE ports.
The existing 1 GBit switch will be replaced by a new Unifi Pro XG 24 switch, which provides me 8x 2.5GbE ports, and 16 (!) 10GbE ports.
What's Our Vector, Victor? Building AI Apps with #Postgres: www.pgedge.com/blog/what-s-...
What's Our Vector, Victor? Building AI Apps with Postgres
Something I’ve presented about recently (a couple times, now!) is how we can make AI actually useful with Postgres. Not the mystical robot overlord kind of AI that people worry about, but the practica...
www.pgedge.com
November 27, 2025 at 2:20 PM
What's Our Vector, Victor? Building AI Apps with #Postgres: www.pgedge.com/blog/what-s-...
Linux FTW!
the Microsoft Windows 2025 experience, expressed in a single picture
November 26, 2025 at 9:08 PM
Linux FTW!
I will also demo PITR in #PostgreSQL in my online training on Wednesday & Thursday :-)
Postgres supports point-in-time recovery: the ability to "travel back in time" to a previous database state.
This works via a combination of backup-restores and WAL replay.
This works via a combination of backup-restores and WAL replay.
November 24, 2025 at 4:50 PM
I will also demo PITR in #PostgreSQL in my online training on Wednesday & Thursday :-)
[Blog] SQL Server 2025 RTM – A Technical Deep Dive into Microsoft’s Most Capable Release Yet: www.sqlpassion.at/archive/2025... #sqlserver #performance #sqlpassion
SQL Server 2025 RTM – A Technical Deep Dive into Microsoft’s Most Capable Release Yet – SQLpassion
www.sqlpassion.at
November 24, 2025 at 12:28 PM
[Blog] SQL Server 2025 RTM – A Technical Deep Dive into Microsoft’s Most Capable Release Yet: www.sqlpassion.at/archive/2025... #sqlserver #performance #sqlpassion
Reposted by Klaus Aschenbrenner
Bf-trees are a high-performance alternative to the classic B-tree.
The key contribution: Decoupling the size of on-disk pages from the size of memory cache entries.
I'm curious if/when MySQL and Postgres will adopt modern versions of classic indexes.
The key contribution: Decoupling the size of on-disk pages from the size of memory cache entries.
I'm curious if/when MySQL and Postgres will adopt modern versions of classic indexes.
November 23, 2025 at 2:25 PM
Bf-trees are a high-performance alternative to the classic B-tree.
The key contribution: Decoupling the size of on-disk pages from the size of memory cache entries.
I'm curious if/when MySQL and Postgres will adopt modern versions of classic indexes.
The key contribution: Decoupling the size of on-disk pages from the size of memory cache entries.
I'm curious if/when MySQL and Postgres will adopt modern versions of classic indexes.
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…
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
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…
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…
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...
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
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...
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...
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
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
[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
[Blog] Master SQL Server Performance Tuning – Black Friday Sale: 50% Off All Online Trainings: www.sqlpassion.at/archive/2025... #sqlpassion #performance #blackfriday
ProTip: if you have spare CPU cycles available, just use RegEx in SQL Server 2025...
November 15, 2025 at 4:11 PM
ProTip: if you have spare CPU cycles available, just use RegEx in SQL Server 2025...
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
When you create a 230 GB database in SQL Server 2025, just to be able to demonstrate ZSTD backup compression more seriously... #sqlserver
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...
And I'm getting even worser execution plans with my test data...
November 14, 2025 at 9:16 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...
And I'm getting even worser execution plans with my test data...
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
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
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
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!
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
* 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
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
* 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
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
SQL Server Management Studio (SSMS) 22 is now Generally Available (GA)!!! 🥳 techcommunity.microsoft.com/blog/sqlserv...
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
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