The most recent failover of Stack Overflow – a busy, 8TB database – took 12 seconds. Find out how.

In this series on common SQL Server problems, I provide some guidance around the error message "An invalid length was passed to the LEFT or SUBSTRING function…" errors.

I detail issues we experienced (and maybe should have expected) while upgrading to SQL Server 2025.