×

Availability Group

Auto-failover Groups – GracePeriodWithDataLossHours

March 31, 2021

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 […]

Executive Summary – Always On Availability Group

December 20, 2020

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 […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Happy Monday! Hope you had a great weekend.
@codegumbo will be talking about: "DevOps & Databases: Challenges &... Possibilities"
Registration details:
https://www.meetup.com/dbavug/events/281082077/
Wednesday, December 8, 2021
12:00 PM to 1:00 PM EST

#devops #database #DBA
#Developers

Happy Friday! Do not forget to sign up for a talk by @codegumbo "DevOps & Databases: Challenges & Possibilities"...
Registration details:
https://www.meetup.com/dbavug/events/281082077/
Wednesday, December 8, 2021
12:00 PM to 1:00 PM EST

#devops #database #DBA
#Developers

More than a great read from @nocentino It's a step by step guide to Configure SQL Server on Linux for Active Directory ... Authentication #SQLServer #SQLonLinux #AzureSQL
#MVPBuzz
https://www.nocentino.com/posts/2021-12-1-sql-server-linux-active-directory/.

#sqlhelp
I am member of 'SQL Active Directory Admin' group in synapse workspace.
Using SSMS I can connect to 'Dedicated... SQL endpoint' but getting log in failure while trying to connect to 'Serverless SQL endpoint'
Any suggestion?
#Azure #azuresynapse

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */