Azure Data Engineer
John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.
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
The three parts of the SQL Server database engine with a focus on how the SQL Server Operating System (SQLOS) component manages resources.
Accessibility in Action
Earners of the Accessibility in Action digital badge have demonstrated their knowledge and skills in creating an inclusive culture.
Teaching in San Francisco
This isn’t my first time in California, but the first time outside the airport. I got to spend the first week of December 2019 in San Francisco teaching a SQL Server Performance Tuning and Optimization course. This is quickly becoming my favorite workshop to teach. What makes this class unusual…
MCT DAY and PASS Summit
What an amazing two weeks that started in Orlando for MCT Day the Saturday before Microsoft Ignite, then a quick trip to Seattle for the PASS Summit, and then finally to Kansas City to teach a dedicated SQL Performance Tuning and Optimization workshop. MCT Day: As you can see above,…
How I spent my Summer Vacation 2019
I just realized that I have not written a blog post since the beginning of May. Instead of backfilling let’s just start again here towards the end of September. First, the big news. After 17 years as a Senior Technical Instructor for New Horizons, I made the decision to make…
Troubleshooting Waiting Tasks
In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.
Task Execution Model
How the SQLOS manages worker threads in the SQL Server Execution Model and the different wait queues in SQL Server to manage threads used by the CPU.
Execution Plans – Table Operators
How to read Heap and Clustered Index table operators in a SQL Server Execution Plan. One way of determining if a table is structured as a Heap or a Clustered Index is to look at the table operators from the Execution Plan.