MCT

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…



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.


Table Structures in SQL Server

Heaps vs Clustered Indexes and how tables are structured and data is stored in SQL Server. Data rows from a table are stored in the data pages in either an unsorted order (Heap) or a sort order (Clustered Index).




SQL Query Processing

How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.


Concurrency: Phantom Reads

A closer look at the Serializable Transaction Isolation Level and how it could prevent Phantom Reads concurrency issues in SQL Server.