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 live training about it that I run from April …
PostgreSQL Quickie #2: Installation in Virtual Machines + read more
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 …
Every SQL Server professional eventually reaches a point where storage internals stop being abstract. You learn that a table is not just a logical container but a physical structure, and that structure is defined by the clustered index. Rows live at the leaf level of a B-tree, the clustering key defines physical order, and every …
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 VECTOR_SEARCH, and …
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning Fundamentals will take place! This hands-on session is designed to help DBAs, developers, and consultants deeply understand how SQL Server executes queries and how you can systematically improve performance with smarter indexing and execution-plan analysis. If you’re still on the fence …
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday! + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
