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

Common SQL Server Wait Types to Improve Database Performance

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...
ZDNet

The Microsoft Intelligent Data Platform: Bringing together databases, analytics and governance

Microsoft execs have been extolling the benefits of integrating databases and analytics for the past several years, starting in earnest with Azure Synapse Analytics. Today during Day 1 of its virtual ...
dbta

SolarWinds Unites the Features of Database Performance Analyzer and SQL Sentry

SolarWinds has expanded its database performance management portfolio with the launch of SolarWinds Database Insights for SQL Server. Uniting the features and functionality of the SolarWinds 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 ...