# John Deardurff: The SQL Server Microsoft Certified Trainer

Generated by Yoast SEO v28.0, this is an llms.txt file, meant for consumption by LLMs.

## Pages
- [About John](https://sqlmct.com/about-john/): More information about John Deardurff \- The SQL Server Microsoft Certified Trainer \(@SQLMCT\)
- [SQL Server Community Resources](https://sqlmct.com/sql-resources/): SQL Server Community Resources curated by John Deardurff \(@SQLMCT\)
- [How to Subscribe](https://sqlmct.com/how-to-subscribe/)
- [Disclaimer](https://sqlmct.com/disclaimer/)
- [Privacy Policy](https://sqlmct.com/privacy-policy/)

## Posts
- [Ten Tips for Teaching Technical Topics ](https://sqlmct.com/ten-tips-for-teaching-technical-topics/): Explore ten tips for teaching technical topics effectively and creating engaging learning environments for your students\.
- [Query Performance Tuning – Book Review ](https://sqlmct.com/sql-server-2025-query-performance-tuning-technical-editor-review/): Explore the insights of Grant Fritchey’s Query Performance Tuning book, now updated for SQL Server 2025\. Learn the essentials\.
- [Query Optimizer Phases](https://sqlmct.com/query-optimizer-phases/): The SQL Server Query Optimizer uses cost\-based optimization to create an execution plan with the least cost\.
- [SQL Server 2022 Technical Reviewer](https://sqlmct.com/sql-server-technical-reviewer/): Explore the insights from the SQL Server 2022 Performance Tuning book, featuring expert reviews and detailed analysis\.
- [SQL Server 2016 ESU Pricing](https://sqlmct.com/sql-server-2016-esu-pricing/): Learn about the new ESU pricing for SQL Server 2016 and how it impacts organizations with consistent pricing across all platforms\.

## Categories
- [SQL Server](https://sqlmct.com/category/sql-server/)
- [Certification](https://sqlmct.com/category/certification/)
- [Azure SQL](https://sqlmct.com/category/azure-sql/)
- [Writing SQL](https://sqlmct.com/category/sql-code/)
- [WGU](https://sqlmct.com/category/wgu/)

## Tags
- [Deardurff](https://sqlmct.com/tag/deardurff/)
- [MCT](https://sqlmct.com/tag/mct/)
- [SQL Server](https://sqlmct.com/tag/sql-server/)
- [SQL](https://sqlmct.com/tag/sql/)
- [Certification](https://sqlmct.com/tag/certification/)

## Optional
- [Sitemap index](https://sqlmct.com/sitemap_index.xml)