John Deardurff Archives

Understand the operational cost of maintaining indexes and how it impacts database performance during write operations.

Explore Business Continuity and Disaster Recovery in Azure SQL to enhance your data resiliency and availability strategies.

Achieve the SQL Skills Blackbelt by completing seven technical courses on Microsoft SQL Server and Azure SQL Databases.

Explore the insights from the SQL Server 2022 Performance Tuning book, featuring expert reviews and detailed analysis.

The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.

Understand SQL Query Processing and how SQL Server parses and binds queries, ensuring syntax accuracy and resolving object names.

Explore Row-Level Security in SQL Server to control data access without altering application logic effectively.

Discover how Dynamic Data Masking in SQL Server protects sensitive data without complex changes and rewriting code.

During the summer of 2020, I earned four new Microsoft certifications. This brings me to over sixty in total with 86 Microsoft exams passed.

Explore the SQL Server Database Engine and its key components: SQLOS, Relational Engine, and Storage Engine.