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

The Fundamental Guide to SQL Query Optimization

If you're seeking to optimize your SQL queries and make the most of your database, this fundamental guide is an excellent resource. You'll learn the essential techniques to enhance database ...
Redmond Magazine

Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...
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 ...
EDN

SQL Parser with Query Optimization

• The project is to develop an SQL query processor with JAVA and JAVACC. • The application can parse the SQL string, execute the query with data files and return the query result. • Developed query ...
Visual Studio Magazine

Generating .NET POCO Classes for SQL Query Results

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...
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 ...