So a thread I started a while back really got me questioning the basis from how we've configured our setup for disaster recovery, and I'm really starting to think it's flawed, or at least can be ...

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...

SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

Last month I attended a session on Failover Clustering at the SQL PASS Summit Conference and it was very enlightening. I have not done too much with SQL Server Failover Clustering except in test mode ...

DBAs have many options for how to ensure high availability (HA) for SQL Server. Some of these options are available in the different versions and editions of SQL Server itself. Some are available in ...

The public cloud offers a myriad of options for providing high availability and disaster recovery protections for SQL Server database applications. Conversely, some of the options available in a ...

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.