Deardurff Archives

Starting a new role as Worldwide Solution Lead for Data and Apps for Global Delivery that is aimed at improving our delivery of technical workshops.

Join me as I celebrate my Summer Break, highlighting achievements earned during the first half of the year.

Learn about Writing SARGable Expressions in T‑SQL to maximize SQL Server performance and efficiency with your queries.

Explore the benefits of optimizing sp_executesql in SQL Server 2025. Improve query efficiency and reduce CPU usage effectively.

Explore Microsoft IQ for the SQL Server DBA and discover its three-layer intelligence framework for enhanced data management.

Explore why modern encryption for SQL is not optional and learn about the new requirements to secure your databases effectively.

Explore the question of CPU pressure vs. tuning queries for optimal performance. Discover whether to scale or tune your SQL Server.

Understand the operational cost of maintaining indexes and how it impacts database performance during write operations.

Explore the new SQL AI Developer Associate certification to enhance your skills in AI-driven SQL solutions.

Learn about using database instructions with GitHub Copilot to enhance your SQL experience and boost query accuracy.