Deardurff Archives

The Customer Facing Skills Initiative (CFSI) is a series of four soft skills courses for Microsoft employees to help them excel in their role

Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.

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

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.

Discover the journey from MCT Day in Orlando to the PASS Summit, along with personal adventures and key certification updates.

Explore my journey through a summer of changes, moving from New Horizons to Microsoft and embracing new challenges.

In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.

Explore the Task Execution Model used in the Database Engine for efficient CPU thread scheduling and task management.

John Deardurff