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.

tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected ...

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.

PowerShell helps us to turn the time-intensive process of creating new users into a quick and easy task.

SQL Server will automatically escalate transactions from normal transactions to distributed transactions as needed. This escalation can be expensive, however.