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.
John Deardurff
SQL Server 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.
Microsoft Azure Certification Summer
During the summer of 2020, I earned four new Microsoft certifications. This brings me to over sixty in total with 86 Microsoft exams passed.
The SQL Server Database Engine
Explore the SQL Server Database Engine and its key components: SQLOS, Relational Engine, and Storage Engine.
How I spent my Summer Vacation 2019
Explore my journey through a summer of changes, moving from New Horizons to Microsoft and embracing new challenges.
SQL Query Processing
Understand SQL Query Processing and how SQL Server parses and binds queries, ensuring syntax accuracy and resolving object names.
Writing T-SQL Queries
In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…