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.
I have created my first VLAN on a Cisco Nexus switch!
December 17, 2025 at 8:13 PM
I have created my first VLAN on a Cisco Nexus switch!
I've just deployed my 1st virtual machine in the @exoscale.com cloud. The deployment was done within *seconds* instead of waiting minutes like with other cloud providers...
December 17, 2025 at 7:01 PM
I've just deployed my 1st virtual machine in the @exoscale.com cloud. The deployment was done within *seconds* instead of waiting minutes like with other cloud providers...
Reposted by Klaus Aschenbrenner
Mein Interview über X und seinen Umgang mit Hass-Postings ist im Berliner @tagesspiegel.de heute auch gedruckt erschienen - und nun auch ohne Paywall online:
www.tagesspiegel.de/kultur/ein-m...
www.tagesspiegel.de/kultur/ein-m...
December 17, 2025 at 7:58 AM
Mein Interview über X und seinen Umgang mit Hass-Postings ist im Berliner @tagesspiegel.de heute auch gedruckt erschienen - und nun auch ohne Paywall online:
www.tagesspiegel.de/kultur/ein-m...
www.tagesspiegel.de/kultur/ein-m...
Reposted by Klaus Aschenbrenner
Sounds about right.
December 15, 2025 at 12:38 PM
Sounds about right.
I have finally integrated the 10G switch into my Home Lab. The whole networking was rewired.
The largest challenge was to find a SFP+ to RJ45 module that is compatible with a Intel XL710 netword card…
You can find a (loud!) video of the boot process here: youtube.com/shorts/3y8wN...
#HomeLab
The largest challenge was to find a SFP+ to RJ45 module that is compatible with a Intel XL710 netword card…
You can find a (loud!) video of the boot process here: youtube.com/shorts/3y8wN...
#HomeLab
December 14, 2025 at 6:43 PM
I have finally integrated the 10G switch into my Home Lab. The whole networking was rewired.
The largest challenge was to find a SFP+ to RJ45 module that is compatible with a Intel XL710 netword card…
You can find a (loud!) video of the boot process here: youtube.com/shorts/3y8wN...
#HomeLab
The largest challenge was to find a SFP+ to RJ45 module that is compatible with a Intel XL710 netword card…
You can find a (loud!) video of the boot process here: youtube.com/shorts/3y8wN...
#HomeLab
How We Made 100M Vector Indexing in 20 Minutes Possible on #PostgreSQL: blog.vectorchord.ai/how-we-made-...
How We Made 100M Vector Indexing in 20 Minutes Possible on PostgreSQL
1. Introduction In the past few months, we’ve heard consistent feedback from users and partners: while our goal of providing a scalable, high-performance alternative to pgvector is well-received, index build time and memory usage remain major concern...
blog.vectorchord.ai
December 13, 2025 at 6:13 PM
How We Made 100M Vector Indexing in 20 Minutes Possible on #PostgreSQL: blog.vectorchord.ai/how-we-made-...
Just bought some DDR5 RAM, because I need it for my son in September 2026… 🙈
December 13, 2025 at 1:31 PM
Just bought some DDR5 RAM, because I need it for my son in September 2026… 🙈
I have a plan - somehow… 🫣
December 12, 2025 at 10:07 PM
I have a plan - somehow… 🫣
Working in my own cloud… #HomeNetworking
December 12, 2025 at 8:20 PM
Working in my own cloud… #HomeNetworking
Yesterday I had a lot of fun to speak about SQL Server 2025 😎
December 11, 2025 at 11:50 AM
Yesterday I had a lot of fun to speak about SQL Server 2025 😎
Wow, the US wants to have from each tourist, which comes under the Visa Waiver program, the social network activities from the last 5 (!) years. Good luck! 👍 #fail #FixYourGovernment
December 10, 2025 at 5:24 PM
Wow, the US wants to have from each tourist, which comes under the Visa Waiver program, the social network activities from the last 5 (!) years. Good luck! 👍 #fail #FixYourGovernment
I’m looking forward to speak tomorrow a whole day long about the improvements in SQL Server 2025 - and about things which are not working as expected 🫢 #sqlserver #sqlpassion
December 9, 2025 at 3:54 PM
I’m looking forward to speak tomorrow a whole day long about the improvements in SQL Server 2025 - and about things which are not working as expected 🫢 #sqlserver #sqlpassion
One of my next tasks is to look into @exoscale.com, a European cloud hosting alternative.
December 9, 2025 at 1:56 PM
One of my next tasks is to look into @exoscale.com, a European cloud hosting alternative.
Reposted by Klaus Aschenbrenner
BLOG ALERT!
arcticdba.se/posts/turbo-...
LLMs are pattern-matching engines, not thinking machines. But anthropomorphization plus dopamine-driven addiction pathways trick us into trusting them. Learn what they actually are and why understanding this matters.
#AI #Literacy #Learning
arcticdba.se/posts/turbo-...
LLMs are pattern-matching engines, not thinking machines. But anthropomorphization plus dopamine-driven addiction pathways trick us into trusting them. Learn what they actually are and why understanding this matters.
#AI #Literacy #Learning
December 9, 2025 at 8:15 AM
BLOG ALERT!
arcticdba.se/posts/turbo-...
LLMs are pattern-matching engines, not thinking machines. But anthropomorphization plus dopamine-driven addiction pathways trick us into trusting them. Learn what they actually are and why understanding this matters.
#AI #Literacy #Learning
arcticdba.se/posts/turbo-...
LLMs are pattern-matching engines, not thinking machines. But anthropomorphization plus dopamine-driven addiction pathways trick us into trusting them. Learn what they actually are and why understanding this matters.
#AI #Literacy #Learning
Reposted by Klaus Aschenbrenner
Day 8 of Advent of Compiler Optimisations! 🔄
Index-based for vs pointer while vs range-for vs std::accumulate—which is fastest? Three produce identical assembly, but one doesn't!
xania.org/202512/08-go...
youtu.be/FB8Hgj3TpJM
#AoCO2025
Index-based for vs pointer while vs range-for vs std::accumulate—which is fastest? Three produce identical assembly, but one doesn't!
xania.org/202512/08-go...
youtu.be/FB8Hgj3TpJM
#AoCO2025
Going loopy — Matt Godbolt’s blog
Exploring the ways optimisers deal with loop constructs
xania.org
December 8, 2025 at 1:10 PM
Day 8 of Advent of Compiler Optimisations! 🔄
Index-based for vs pointer while vs range-for vs std::accumulate—which is fastest? Three produce identical assembly, but one doesn't!
xania.org/202512/08-go...
youtu.be/FB8Hgj3TpJM
#AoCO2025
Index-based for vs pointer while vs range-for vs std::accumulate—which is fastest? Three produce identical assembly, but one doesn't!
xania.org/202512/08-go...
youtu.be/FB8Hgj3TpJM
#AoCO2025
Today I have reiceived the Ubiquity USW Pro XG switch. What a beast! 8x multi-speed ports (2.5GBit, 1GBit, 100MBit) and 16 (!) 10GBit ports!
A quick test between an old HP DL180 server that runs TrueNas (for ZFS experiments) and my MacBook Air (with a 10GBit Thunderbolt adapter) was successful 😎
A quick test between an old HP DL180 server that runs TrueNas (for ZFS experiments) and my MacBook Air (with a 10GBit Thunderbolt adapter) was successful 😎
December 4, 2025 at 6:58 PM
Today I have reiceived the Ubiquity USW Pro XG switch. What a beast! 8x multi-speed ports (2.5GBit, 1GBit, 100MBit) and 16 (!) 10GBit ports!
A quick test between an old HP DL180 server that runs TrueNas (for ZFS experiments) and my MacBook Air (with a 10GBit Thunderbolt adapter) was successful 😎
A quick test between an old HP DL180 server that runs TrueNas (for ZFS experiments) and my MacBook Air (with a 10GBit Thunderbolt adapter) was successful 😎
It seems that I can't get Optimized Locking working in SQL Server 2025: the UPDATE statement still triggers a Lock Escalation (still X-lock on OBJECT), which shouldn't be the case when OL is enabled. The example from learn.microsoft.com/en-us/sql/re... works without any problems.... Ideas?
December 4, 2025 at 2:56 PM
It seems that I can't get Optimized Locking working in SQL Server 2025: the UPDATE statement still triggers a Lock Escalation (still X-lock on OBJECT), which shouldn't be the case when OL is enabled. The example from learn.microsoft.com/en-us/sql/re... works without any problems.... Ideas?
ChatGPT just told me that I don't need fiber cabling in my home network, because I "don't run and operate a low-latency trading system" 😅
December 4, 2025 at 1:53 PM
ChatGPT just told me that I don't need fiber cabling in my home network, because I "don't run and operate a low-latency trading system" 😅
Can someone confirm that the Query Hint "ABORT_QUERY_EXECUTION" can't be used for a DDL statement, like "CREATE INDEX"? I have attached it through sys.sp_query_store_set_hints, but the DDL statement still works...?
December 4, 2025 at 1:42 PM
Can someone confirm that the Query Hint "ABORT_QUERY_EXECUTION" can't be used for a DDL statement, like "CREATE INDEX"? I have attached it through sys.sp_query_store_set_hints, but the DDL statement still works...?
You can't (currently) delete a JSON index in SQL Server 2025 through SSMS v22...
December 4, 2025 at 1:07 PM
You can't (currently) delete a JSON index in SQL Server 2025 through SSMS v22...
Today, I have (almost) crossed the 7000K mark for cycling for the current year. Already more than 2000K compared to previous 2024. 💪 #cycling
December 4, 2025 at 1:03 PM
Today, I have (almost) crossed the 7000K mark for cycling for the current year. Already more than 2000K compared to previous 2024. 💪 #cycling
Reposted by Klaus Aschenbrenner
Just wrote "Continuation from the previous 131 parts, the whole series can be found at www.nikoport.com/columnstore/...
Columnstore
I am deeply fascinated by the Columnstore Indexes, and I have open some Connect Items to suggest their important improvements: – Implement Batch Mode Support for Row Store – Multi-threaded rebuilds…
https://www.nikoport.com/columnstore/."
December 3, 2025 at 9:34 PM
Just wrote "Continuation from the previous 131 parts, the whole series can be found at www.nikoport.com/columnstore/...
I’m using JSON indexes to demonstrate the new query hint ABORT_QUERY_EXECUTION in SQL Server 2025… 😁
December 2, 2025 at 6:27 PM
I’m using JSON indexes to demonstrate the new query hint ABORT_QUERY_EXECUTION in SQL Server 2025… 😁