The auto-failover groups feature for the Azure SQL database can be configured with an automatic failover policy. Azure triggers failover after the failure is detected and the grace period has expired. Grace period is determined by a setting called ‘GracePeriodWithDataLossHours’ that cannot be set under one hour. Why is it not allowed to set a […]
The ‘Always On Availability Group’ feature is a high-availability and disaster-recovery solution. Since the launch with SQL Server 2012, data professionals have adopted this solution widely. Before implementing ‘Always On Availability Group’, data professionals need to make decisions about availability and failover mode. These decisions will involve discussion with business owners of the applications that […]
Thank you @solarwinds for sponsoring #sqlsatBoston at Platinum level.
We appreciate your commitment towards the ...community.
#sqlsaturday
@sqlsatofficial
Did you know? We have a #SQLServer builds site with nearly 1000 builds: indexed, searchable and powered by a regularly ...updated JSON file that is included in dbatools! http://dbatools.io/builds
I've started a little thing to provide a list of mental health resources for people. Started by having many ...conversations with folks. It's in on GitHub so people can help me add to it. It's in its baby stages. https://buff.ly/3Ar09Vw #mentalhealth #sqlfamily