Blog

SQL Skills Blackbelt on SQL Server 2019

Extremely rewarding to be only the 46th person to earn this demanding badge from SQL Skills. It is only achieved after attending SEVEN deeply technical courses focused on Microsoft SQL Server. In total, these courses provide over 155 hours of content and demonstrations.


MPP Architecture in Synapse SQL Pools

The purpose of Massively Parallel Processing (MPP) is to scale out compute nodes and reduce workload per compute node to query large volumes of data. Control Node There will always be 1 Control Node that is used to connect to and manage the SQL Pool. The data in a table…


SQL Server Technical Reviewer

After several attempts, I finally got to see my name in an actual published book. Not as an author but a technical reviewer of the SQL Server 2022 Performance Tuning book written by Grant Fritchey. I have been reading every version of this book since at least the second edition…




Query Optimizer Phases

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


Summer Tour 2021

Before the pandemic I had planned and scheduled a summer tour to hit the last remaining State (Louisianna) on my list of continental states to visit and several landmarks I had yet to see. Well, after an 18-month delay to the plan, I finally set off on an adventure. Starting…


Azure Data Engineer

John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.



Accessibility in Action

Earners of the Accessibility in Action digital badge have demonstrated their knowledge and skills in creating an inclusive culture.