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

Recently, I was speaking at a SQL Saturday event (www.sqlsaturday.com), when I encountered a question that I've been getting more and more often. It went something like this: "I know that I can look ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.