Please turn JavaScript on
header-image

SQLpassion

Receive updates from SQLpassion for free, starting right now.

We can deliver them by email, via your phone or you can read them from a personalised news page on follow.it.

This way you won't miss any new article from SQLpassion. Unsubscribe at any time.

Site title: SQLpassion – SQLpassion provides high-quality SQL Server Consulting services for clients around Europe & the US

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.17 / day

Message History

Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed: AI, Performance & Beyond will take place! This hands-on training is designed to help DBAs, developers, ...


Read full story

A few weeks I have uploaded my 2nd PostgreSQL Quickie to YouTube. This time I’m talking about PostgreSQL installation in Virtual Machines. If you are interested in learning more about how to transition your SQL Server knowledge seamless to PostgreSQL, I highly recommend to check-out my


Read full story

PostgreSQL performance on Linux is often discussed in terms of SQL tuning, indexes, and query plans. Yet many real-world performance problems originate much lower in the stack: inside the Linux page cache and its writeback policy. PostgreSQL deliberately relies on the kernel for file caching and writeback, which means that kernel misconfiguration can silently undermine otherw...


Read full story

With SQL Server 2025, Microsoft introduces vector support as a native engine feature: a built-in VECTOR(dim) data type, dedicated vector functions, and an approximate vector index tightly integrated into the optimizer. From a SQL Server point of view, this feels natural—vectors become another first-class datatype, queried via explicit functions such as VECTOR_DISTANCE or VECT...


Read full story