Tag: AlwaysOn

More and more companies are adopting the Always On Availability Groups as their HA/DR architecture for the SQL Server databases. While this comes with a lot of advantages—less downtime, use of the secondary replica to offload your read-only queries (depending…

Architecture diagram Register the application with the name terraform. Leave all options as default. Add a secret that will be used as a password to authenticate terraform. Provide a description and expiry period for the secret. Copy the Secret ID…

Method – Job Category This blog post will show how to setup SQL Jobs in multiple availability groups. This method will allow you to dynamically detect the role of the SQL Server replica and avoid job execution errors in the…

Most of my blog posts are an outcome of the work that I do over the weekend while holding the pager for my team. This blog post is no different. In this blog post, I will talk about the importance…

Hemantgiri S. Goswami, Pythian database expert and SQL Server MVP, discusses a new feature, Basic Availability Groups for AlwaysOn, found in SQL Server 2016