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 ...

HOUSTON--(BUSINESS WIRE)--IDERA (a division of Idera, Inc.), a provider of powerful database productivity tools, today announced a major release of SQL Diagnostic Manager. This release introduces the ...

Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

A popular performance tuning book gets updated for SQL Server 2022, how does it fare? This well-liked SQL Server book examines performance from various angles, but concentrates on improvements related ...

Although there was significant fanfare surrounding SQL Server Query Store's initial release in SQL Server 2016, many companies have been hesitant about adopting the performance monitoring and ...

A popular performance tuning book gets updated for SQL Server 2017, how does it fare? This well-liked SQL Server book examines performance from various angles, but concentrates on improvements related ...

With so much hype around AI, generative AI and cybersecurity, it can be tough to generate excitement around something as ubiquitous as databases. But without that foundation, none of today’s tech – ...

In a modern enterprise data environment, the increasing volume of data, distributed architecture, and complex application dependencies challenge traditional query-tuning methods. Observability ...

When you interview for a SQL database administrator job, the interviewer will likely ask a number of questions related to optimizing SQL databases. Be prepared to discuss the different factors that ...