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
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
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
Lock-After-Qualification (LAQ) leads to different query results in SQL Server 2025: learn.microsoft.com/en-us/sql/re... #sqlserver #sqlserver2025
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
Final preparations for my upcoming webcast about #PostgreSQL tomorrow morning. There is still time to sign-up: www.sqlpassion.at/archive/2025...
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...
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
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...
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...
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
Understanding PostgreSQL WAL and optimizing it with a dedicated disk: stormatics.tech/blogs/unders... #PostgreSQL #postgres
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
It seems that EVE-NG would be a great addition to my Home Lab environment: www.eve-ng.net #VirtualNetworkEnvironment
@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
@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! :-)
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
#SQLServer #Azure #OpenAI #LLM
November 5, 2025 at 2:04 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
#SQLServer #Azure #OpenAI #LLM
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
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...
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
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-....
Reposted by Klaus Aschenbrenner
Mein Praxistipp, wenn sie sich die Prüfung, die extrem viel Praxisfachwissen erfordert und daher, finde ich, unzumutbar ist, nicht antun wollen, teilen Sie keine Artikel mehr, vor allem nicht vom Boulevard. Besser nur Liken, das löst in der Regel keine Haftung aus! www.falter.at/maily/202511...
Klagsfalle Social-Media-Posting: Fünf Tipps, damit HC Strache Sie nicht zur Kasse bitten kann
Wer Zeitungartikel auf Facebook teilt, kann böse Überraschungen erleben. Hier ein paar Tipps, wie Sie Geldstrafen und Anwaltskosten entgehen
www.falter.at
November 5, 2025 at 9:32 AM
Mein Praxistipp, wenn sie sich die Prüfung, die extrem viel Praxisfachwissen erfordert und daher, finde ich, unzumutbar ist, nicht antun wollen, teilen Sie keine Artikel mehr, vor allem nicht vom Boulevard. Besser nur Liken, das löst in der Regel keine Haftung aus! www.falter.at/maily/202511...
Reposted by Klaus Aschenbrenner
WANTED! NVIDIA RTX PRO 4000 Blackwell SFF Edition! 💪
November 4, 2025 at 7:57 PM
WANTED! NVIDIA RTX PRO 4000 Blackwell SFF Edition! 💪
Ooooh: "A table with a vector index becomes read only": learn.microsoft.com/en-us/sql/t-...
CREATE VECTOR INDEX (Transact-SQL) - SQL Server
CREATE VECTOR INDEX creates an index on vector data to allow approximate nearest neighbor search.
learn.microsoft.com
November 4, 2025 at 7:07 PM
Ooooh: "A table with a vector index becomes read only": learn.microsoft.com/en-us/sql/t-...
Generating Embeddings for SQL Server 2025 through Ollama on my Windows machine. #sqlserver #sqlserver2025 #llm #ollama
November 3, 2025 at 10:58 PM
Generating Embeddings for SQL Server 2025 through Ollama on my Windows machine. #sqlserver #sqlserver2025 #llm #ollama
Reposted by Klaus Aschenbrenner
New blog post: SQL Server Diagnostic Information Queries for November 2025
glennsqlperformance.com/2025/11/03/s...
#SQLServer #SQLServer2025
glennsqlperformance.com/2025/11/03/s...
#SQLServer #SQLServer2025
November 3, 2025 at 9:42 PM
New blog post: SQL Server Diagnostic Information Queries for November 2025
glennsqlperformance.com/2025/11/03/s...
#SQLServer #SQLServer2025
glennsqlperformance.com/2025/11/03/s...
#SQLServer #SQLServer2025
Reposted by Klaus Aschenbrenner
Minisforum has done a great job of stretching their MS-01 chassis design to MS-A2 & now their 1st Arm-based system with upcoming MS-R1
🔸Cortex-A720 (P-Core) & Cortex-A520 (E-Core)
🔹Up to 64GB LPDDR5 Memory
🔸Dual 10GbE Networking
wccftech.com/minisforum-p...
🔸Cortex-A720 (P-Core) & Cortex-A520 (E-Core)
🔹Up to 64GB LPDDR5 Memory
🔸Dual 10GbE Networking
wccftech.com/minisforum-p...
November 3, 2025 at 9:51 PM
Minisforum has done a great job of stretching their MS-01 chassis design to MS-A2 & now their 1st Arm-based system with upcoming MS-R1
🔸Cortex-A720 (P-Core) & Cortex-A520 (E-Core)
🔹Up to 64GB LPDDR5 Memory
🔸Dual 10GbE Networking
wccftech.com/minisforum-p...
🔸Cortex-A720 (P-Core) & Cortex-A520 (E-Core)
🔹Up to 64GB LPDDR5 Memory
🔸Dual 10GbE Networking
wccftech.com/minisforum-p...
I have just connected my Ollama REST endpoint that runs on Mac OS to SQL Server 2025. The tricky part was to use a reverse proxy on Mac OS (caddy) to forward the incoming https requests to the http only endpoint of Ollama.
#sqlserver #sqlserver2025 ##lm #ollama
#sqlserver #sqlserver2025 ##lm #ollama
November 3, 2025 at 5:31 PM
I have just connected my Ollama REST endpoint that runs on Mac OS to SQL Server 2025. The tricky part was to use a reverse proxy on Mac OS (caddy) to forward the incoming https requests to the http only endpoint of Ollama.
#sqlserver #sqlserver2025 ##lm #ollama
#sqlserver #sqlserver2025 ##lm #ollama
Join my free webinar about PostgreSQL on November 12!
[Blog] How SQL Server Professionals Can Master PostgreSQL - Without Wasting Months on Trial & Error: www.sqlpassion.at/archive/2025... #sqlserver #postgres #PostgreSQL #sqlpassion
[Blog] How SQL Server Professionals Can Master PostgreSQL - Without Wasting Months on Trial & Error: www.sqlpassion.at/archive/2025... #sqlserver #postgres #PostgreSQL #sqlpassion
How SQL Server Professionals Can Master PostgreSQL – Without Wasting Months on Trial & Error – SQLpassion
www.sqlpassion.at
November 3, 2025 at 12:56 PM
Join my free webinar about PostgreSQL on November 12!
[Blog] How SQL Server Professionals Can Master PostgreSQL - Without Wasting Months on Trial & Error: www.sqlpassion.at/archive/2025... #sqlserver #postgres #PostgreSQL #sqlpassion
[Blog] How SQL Server Professionals Can Master PostgreSQL - Without Wasting Months on Trial & Error: www.sqlpassion.at/archive/2025... #sqlserver #postgres #PostgreSQL #sqlpassion
It‘s been a long time… #2048
November 2, 2025 at 6:40 PM
It‘s been a long time… #2048
Based on a single sys-prepped Windows Server image (2022, 2025), I can create now in a fully automated way (with #Terraform & #Ansible) in about 15 - 20 minutes a complete Windows Active Directory infrastructure, with running SQL Server instances, and a fully working Availability Group deployment.
October 31, 2025 at 10:45 PM
Based on a single sys-prepped Windows Server image (2022, 2025), I can create now in a fully automated way (with #Terraform & #Ansible) in about 15 - 20 minutes a complete Windows Active Directory infrastructure, with running SQL Server instances, and a fully working Availability Group deployment.