Home » Posts tagged 'Performance tuning'

Tag Archives: Performance tuning

Database Concurrency: MVCC in PostgreSQL vs Row Versioning in SQL Server

What is Concurrency in Databases? Concurrency control ensures that multiple transactions can occur simultaneously without leading to data inconsistency. Two popular concurrency control mechanisms are: MVCC in PostgreSQL PostgreSQL uses MVCC to handle concurrent transactions without locking rows for reads. Instead of overwriting data, it creates a new version of a row for every update. … Continue reading

SQL Server 2025 Is Here – AI Just Changed Everything!

🔟 Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch #MicrosoftFabric #DataEngineering #TechUpdates #decodeites #mssqlfun

Query Store – Useful Tool for DBAs

SQL Server is a robust and flexible database management system that offers a variety of features and capabilities to help organizations effectively manage their data. One of the key features of SQL Server is its ability to provide insights into query performance, enabling database administrators and developers to identify and resolve performance issues. The Query … Continue reading