Availability Groups and Session Timeouts across WAN?What is a session timeout? This is a property that dictates how many seconds an availability replica waits for a (ping) response from...
No Backups, No Logs, No Dice...It's becoming less surprising, but no less scary when I find shops not taking regular database backups. This happens quite often in...
The importance of RPO and RTOIt is unbelievable how common it is to walk into a new organization only to find that they have no database backups. But when having a...
AlwaysOn Series: Monitoring with SQL Agent AlertsThere are several ways to monitor your Availability Groups using native SQL tools. In this particular article I'm going to cover a few...
Build an AlwaysON Availability Group Part 2: Setting up SQL Server and Adding a DatabaseBefore we begin: While the gui/wizard for setting up Availability groups is super easy, I'm going to go through utilizing T-SQL. This...
Build an AlwaysON Availability Group Part 1: Build the Windows Failover ClusterBuild the cluster right so you don't run around frantically like this guy does for a living. So most DBA's know that AlwaysOn...