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

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

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

[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.

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

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

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

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

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...

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

Hello #PostgreSQL 18.0 :-)

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...

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

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

I implemented a CPU and RAM. In Javascript. For a blog.

Today I have received a @frame.work 13 notebook. I really love the modular design, amd that you can swap *each* component individually.

Myth: “SQL Server is slow? Let’s buy bigger hardware.” ❌ Wrong. Bad indexes remain bad indexes. Like in triathlon: you can’t replace training with a new bike. 🚴 👉 Free SQL Server Health Check: www.sqlpassion.at/free-sql-ser... #sqlserver #sqlpassion #healthcheck #performance

PlanetScale for Postgres is now GA. planetscale.com/blog/planets...

[Blog] From Couch-Potato to Triathlete – and What This Means for Your SQL Server: www.sqlpassion.at/archive/2025... #sqlserver #sqlpassion #healthcheck #triathlon

What a race! I'm terrible at swimming, so I exited the swim part as 215th of 236 participants. I had the 20th fastest bike split out of all participants (and the 3rd fastest one of my age group) I finished the whole triathlon as 95th, and as 10th within my age group (16 participants). #triathlon

3 warning signs your SQL Server needs help: ⚡ CPU constantly >80% ⚡ Reports take minutes or hours ⚡ Users keep saying: “It’s slow again!” 👉 Get your free 30-min Health Check: www.sqlpassion.at/free-sql-ser... #SQLServer #DBA #PerformanceTuning

Rust 1.90.0 has been released! ✨🦀 This release makes LLD the default linker on x86-64 linux-gnu and adds `cargo publish --workspace` to publish an entire workspace all at once! Check out the blog post and release notes for more: blog.rust-lang.org/2025/09/18/R...

Postgres is Too Good (And Why That's Actually a Problem): dev.to/shayy/postgr... #PostgreSQL

10 years ago: 85kg couch potato 🛋️ Today: 65kg triathlete 🏊🚴🏃 Discipline, focus & strategy → exactly what SQL Server performance needs. 👉 My Free 30-min SQL Server Health Check: www.sqlpassion.at/free-sql-ser... #SQLServer #Triathlon #HighPerformance

SQL Server 2025 has dropped its first Release Candidate… and the new performance features are no ghost story. This release isn’t just about AI—it’s packed with real improvements for DBAs and developers. In my latest blog, I put on my Scooby-Doo hat and follow the clues through execution plans and…

📈 DuckDB 1.4.0 is out! This is our first LTS release which comes with *one year of community support*. It also supports database encryption, the MERGE SQL statement and Iceberg writes. For more details, read the announcement blog post at duckdb.org/2025/09/16/a...

Get Excited About #Postgres 18: www.crunchydata.com/blog/get-exc... #PostgreSQL

ICYMI…

LAST CHANCE! Early bird expires today! Learn about ordering, grouping, and segmenting in #SQLServer execution plans, in the latest part of the SQLServerFast Execution Plan Video Training. Over 2 hours and 40 minutes of content, with $10 off! sqlserverfast.com/blog/hugo/20...

🚀 Big news! After years of creating SQL Server Quickies, I’ve launched my new #PostgreSQL Quickies series on YouTube. Episode 1: Running PostgreSQL with Docker 🐳. Short, practical, hands-on! 👉 www.sqlpassion.at/archive/2025...

🚀 After years of SQL Server Quickies, I’m now launching PostgreSQL Quickies! Short, no-fluff videos with practical tips you can use right away. Episode #1 is live - check it out & tell me what you’d like to see next! www.youtube.com/watch?v=12b_... #PostgreSQL #Postgres

VMware, now worse than Oracle www.reddit.com/r/AZURE/s/DS...

Interesting. QEMU 10.1 supports WASM and can run inside a browser. 🤔 wiki.qemu.org/ChangeLog/10.1

Streaming Replication in #PostgreSQL is very powerful. The setting "recovery_min_apply_delay" (configured through postgresql.conf on a secondary replica) gives you a restore delay for that replica - the same as when you configure Log Shipping in #SQLServer with a restore delay.

Are you a SQL Server Professional? 🚀 This November I’m running my live online training “PostgreSQL for the SQL Server Professional.” Learn key differences, avoid pitfalls & bridge your SQL Server expertise to PostgreSQL. More Information: 👉 www.sqlpassion.at/live-trainin... #PostgreSQL #SQLServer

Is someone using the Framework Laptop 13?

@nocentino.com I've just tested github.com/nocentino/ha... from you, and this is *AWESOME*!!!! 2 questions: 1. For the TPC-H workload, I'm not getting back any query execution results (see screenshot). TPC-C works as expected. 2. How hard is it to do the same for PostgreSQL? :-) Thanks!!!!!

Here is now a simple repository that shows how you can run the TPC-H benchmark with @duckdb.org : github.com/SQLpassion/D... It uses tpchgen-cli for the creation of the necessary .parquet files. Everything was inspired from their blog posting that was published yesterday: duckdb.org/2025/09/08/d...

The xCapture and xtop eBPF tools are now in beta, with a demo dataset! With a pre-recorded xcapture dataset from my dev server, now you can play with xtop "thread activity sampling" drilldown even on your laptop, without having to run xcapture yourself! (link in replies :-)

“SSMS 22 Preview isn't currently supported on Arm64.” - Workaround: “Run SSMS on a device that isn't Arm64.” learn.microsoft.com/en-us/ssms/k... 🙈🙈🙈

Working with #PostgreSQL and #DuckDB simultaneously… 😅

Experimenting with #DuckDB and the TPC-H workload...

🚀 New GitHub repo: #PostgreSQL streaming replication in Docker Compose. ✅ Works on macOS, Linux, Windows 11 - even on a Raspberry Pi 5. Next up: Patroni + HAProxy, PgBouncer integration. 💬 Feedback & ideas welcome! 👉 github.com/SQLpassion/p...

Thanks for the DDoS attack on my website! :-)

Faster storage throughput than a typical SAN... 😅

[Blog] Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL: www.sqlpassion.at/archive/2025... #Postgres #PostgreSQL #SQLServer #Migrations #Overhead

The quality of the output of #ChatGPT is getting more and more worse. It just told me that #SQLServer stores columns in the order in which you have created them. If you guide it in the right direction, you will (hopefully) get the correct answer. ProTip: never ever trust a LLM blindly!!!

I have now a fully working 3-node #PostgreSQL HA/DR setup, running with Docker Compose :-)

A Navajo weaving of an integrated circuit: the 555 timer: www.righto.com/2025/09/mari...

With Streaming Replication (and HaProxy, and Patroni) #PostgreSQL offers you the same features as #SQLServer Availability Groups, and you can even implement a read-scaleout - without any costs! :-)