SQL Server 2022 Technical Reviewer
Explore the insights from the SQL Server 2022 Performance Tuning book, featuring expert reviews and detailed analysis.
Deardurff
Accelerated Database Recovery in SQL Server
Accelerated Database Recovery (ADR) is one of the most impactful engine changes introduced with SQL Server 2019. The goal of ADR is to dramatically reduce database recovery and rollback time, even in the presence of long‑running transactions. What Is Database Recovery? In a previous post, I discussed the SQL Server Restore and Recovery…
Customer Facing Skills Initiative
The Customer Facing Skills Initiative (CFSI) is a series of four soft skills courses for Microsoft employees to help them excel in their role
Opportunities for Query Optimization
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
SQL Query Processing
Understand SQL Query Processing and how SQL Server parses and binds queries, ensuring syntax accuracy and resolving object names.
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
Explore the SQL Server Database Engine and its key components: SQLOS, Relational Engine, and Storage Engine.
MCT DAY and PASS Summit
Discover the journey from MCT Day in Orlando to the PASS Summit, along with personal adventures and key certification updates.
How I spent my Summer Vacation 2019
Explore my journey through a summer of changes, moving from New Horizons to Microsoft and embracing new challenges.
Troubleshooting Waiting Tasks
In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.