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.

Peter steals another tip from a reader: Entity Framework isn't just for tables and stored procedures. Leveraging SQL Server views can simplify your code.

Why are there INFOMATION_SCHEMA and catalog views in SQL Server that do very similar things? For example, to retrieve a list of tables in a database, I can do it via sys.tables or INFORMATION ...

In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. At some point in 2022, we will see SQL Server 2022 released as a general availability ...