Query performanceOften the first step you take to improve your SQL Server query performance is to add indexes to tables. This is also usually true for...
Data change recordingSQL Server 2019 (15.x) provides two features that track changes to data in a database: change data capture and change tracking. These...
The backstage architectureMany recent sessions emphasize the role of Query Store. Today, I attended another session regarding Query Store. The topic of the session...