Please turn JavaScript on
Homepage
TrendingMy newsFind FeedsDelivery settingsPlansMy earnings
HelpBlog
Log in
Find more feeds
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

Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!

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
PostgreSQL Quickie #2: Installation in Virtual Machines

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
The Linux Page Cache and PostgreSQL

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
Where is My Clustered Index in PostgreSQL?
Read full story
Vector Capabilities with pgvector in PostgreSQL

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