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…
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…
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.
John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.
During the summer of 2020, I earned four new Microsoft certifications. This brings me to over sixty in total with 86 Microsoft exams passed.
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.
SQL Transaction and Error Handling? What is the difference between Auto-Commit and Explicit Transactions and how transaction affect Errors and Exception Handling?
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.
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…