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.
SQL SERVER 2022 – Parameter Sensitive Plan Optimization (PSPO)
SQL Server 2022 introduces an exciting new feature called Parameter Sensitive Plan Optimization (PSPO), which aims to improve the performance.
Data Quality Asserts in T-SQL: Failing a Load When Rules Break
Write data quality asserts in T-SQL to reject invalid staging rows, preserve check results, and record each load attempt.
Chatty Applications: Finding Many Tiny Queries per Second
Diagnose chatty applications with batch rates, cached executions, bounded session event counts, and measured round trips per user action.
Column-Level Permissions: Hiding One Column From Some Users
Apply SQL Server column-level permissions, test DENY and SELECT behavior, inspect explicit grants, and compare views with data masking.
Cross-Database Ownership Chaining: Why It Is Off and What to Use
Understand cross-database ownership chaining, inspect its scope, and use signed procedures for narrow access between SQL Server databases.