Deardurff Archives

Learn how batching transactions can lead to better performance, reduce blocking, and potentially lower costs in Azure SQL and SQL Server.

Find out how to implement Vector Search SQL Server 2025 for effective, local semantic searches without relying on external services.

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.