Choosing the Right Performance Counters
Learn about choosing the right Performance Counters for SQL Server to identify performance issues effectively.
John Deardurff
CPU Pressure or Time to Tune a Query?
Explore the question of CPU pressure vs. tuning queries for optimal performance. Discover whether to scale or tune your SQL Server.
The Operational Cost of Maintaining Indexes
Understand the operational cost of maintaining indexes and how it impacts database performance during write operations.
Business Continuity and Disaster Recovery in Azure SQL
Explore Business Continuity and Disaster Recovery in Azure SQL to enhance your data resiliency and availability strategies.
SQL Skills Blackbelt on SQL Server 2019
Achieve the SQL Skills Blackbelt by completing seven technical courses on Microsoft SQL Server and Azure SQL Databases.
SQL Server 2022 Technical Reviewer
Explore the insights from the SQL Server 2022 Performance Tuning book, featuring expert reviews and detailed analysis.
Query Optimizer Phases
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.
SQL Query Processing
Understand SQL Query Processing and how SQL Server parses and binds queries, ensuring syntax accuracy and resolving object names.
Row-Level Security in SQL Server
Explore Row-Level Security in SQL Server to control data access without altering application logic effectively.
Dynamic Data Masking in SQL Server
Discover how Dynamic Data Masking in SQL Server protects sensitive data without complex changes and rewriting code.