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.

Red Gate has released SQL Test, a unit testing add-in for SQL Server Management Studio. It allows developers to create and run unit tests from within SSMS, and share them with other team members.

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