In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.
Horizontal and Vertical Scaling for Databases
Horizontal and vertical scaling solve different SQL Server capacity problems; compare larger machines, additional nodes, and the costs each brings.
Log Shipping to a Readable Standby: Restores vs Report Users
Configure a readable standby for log shipping, balance restore jobs with report users, and measure copy and restore delay.
SQL SERVER – Get High Availability with SQL Server 2012
SQL Server 2012 offers several High Availability options, including up to four active secondaries. Here is what they give you and how a course can help.
Geo-Replication for Azure SQL
Geo-replication for Azure SQL protects against regional failure through readable replicas or failover groups; learn lag, routing, and drills.
Piecemeal Restore: Bringing the Primary Filegroup Online First
Rehearse a piecemeal restore that brings PRIMARY and current data online first, then restores archive filegroups with the right log chain.
Distributed Availability Groups: Linking Two Sites Without One Big Cluster
Understand distributed availability groups, connect two existing groups across sites, inspect health, and plan recovery without one cluster.