John Deardurff Archives

Learn about the new ESU pricing for SQL Server 2016 and how it impacts organizations with consistent pricing across all platforms.

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

Stay informed about SQL Server Security Updates: May 2026 for versions from 2016 to 2025. Protect your database today.

Explore similarity matching in SQL Server 2025 to manage data inconsistencies, such as spelling variations, effectively.

Explore optimized locking in SQL Server 2025 to enhance concurrency and improve performance in your database applications.

Prepare for the end of SQL Server 2016 support by modernizing with Azure Arc and Power BI to enhance your compliance and security efforts.

Explore A New Migration Experience in SSMS 22.5, simplifying SQL Server migrations with a unified guided approach.

Explore SQL Server Security Updates: April 2026, ensuring protection for versions 2016 to 2025 with critical enhancements.

Learn about choosing the right Performance Counters for SQL Server to identify performance issues effectively.

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