“What are some common mistakes you see DBAs make when working with MySQL databases, and how can they be avoided?”
SQL Server 2022 Performance – Buffer Pool Scan
One aspect that can significantly impact performance is scanning the buffer pool in Microsoft SQL Server. This blog explores buffer pool scan.
Implicit Transactions in SQL Server: The Setting That Leaves Work Open
Implicit transactions make SQL Server open a transaction on the first data statement and keep it open until a COMMIT or ROLLBACK. This post shows what starts one, how @@TRANCOUNT counts it, why a second session waits, and how to find and clear the sessions that left work open.
How to Choose the Right Database Monitoring Tool
Choose the right database monitoring tool by comparing alerts, workload context, overhead, pricing and support using a practical checklist.
Adapting to the Evolving Role of the DBA with SQL DM
The evolving role of the DBA includes proactive monitoring. See how SQL DM can highlight risk, help prioritize issues and support the team.
Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.
PSPO Plan Variants: One Query, Several Plans in SQL Server
PSPO plan variants let SQL Server cache up to three plans for one parameterized query when the data is very skewed. This post builds a skewed table, shows two variants with different reads for three calls, compares the same calls with the feature off, and explains when PSPO does not apply.