Redmond Magazine

Performance Tuning SQL Server Using Wait Statistics

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

Idera Announces General Availability of SQL Diagnostic Manager 14.0, Introducing AI-Powered Query and Workload Index Optimization for SQL Server

New AI capabilities help DBAs move from performance visibility to performance resolution--turning slow queries into actionable index recommendations in minutes HOUSTON, March 19, 2026 /PRNewswire/ -- ...
dbta

SQL Monitor by Redgate Remediates Intricacies of Query Tuning

Redgate, the Database DevOps solutions provider, is launching upgrades to its SQL Server performance monitoring tool, strengthening its query tuning and optimization functions to facilitate enhanced ...
dbta

Techniques for Optimizing Databases

Optimizing the performance of operational databases and the applications that access them is a constant battle for DBAs. Of course, writing efficient SQL is the most important aspect of ensuring ...
Redmond Magazine

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...