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
Developers coming from SQL Server often approach PostgreSQL with the assumption that spatial functionality will look and behave more or less the same. After all, both systems expose geometry and geography types, both support distance calculations, and both offer spatial indexes. That assumption is only partially correct. While PostgreSQL with PostGIS covers everything SQL Server …
When SQL Server professionals start working seriously with PostgreSQL, most of the learning curve feels comfortable. Tables behave as expected, transactions are familiar, and B-tree indexes look reassuringly similar to what you have used for years in SQL Server. Then you encounter BRIN indexes. At first glance, they seem almost reckless: no row pointers, no …
If you come from SQL Server (like in my case), PostgreSQL indexing can feel familiar at first – B-tree indexes exist, composite indexes exist, covering indexes exist. And then you run into queries like this: or this: At that point, most SQL Server developers ask two questions: What are these operators? Why does PostgreSQL need …
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.
