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 […]
HA/DR Open Q&A Extravaganza is on December 10th, 2019, at 1 PM EST. This event is one of the most extensive lineups of SQL Server HA/DR experts in history, and any question goes! ! Organized by High Availability and Disaster Recovery PASS virtual group. I am honored, humbled, and super excited to be part of this panel. […]
I will explain how you can use sp_MSforeachdb stored procedure against READ_WRITE database only. There are numerous articles on the web about excluding databases using database id or name. Recently I needed a script to run against databases that are part of Always On Availability Groups and in READ_WRITE status. I used the ‘Updateability’ properties […]
I observed this behavior only in the following version of SQL Server while using Always On Availability Group feature. Version: Microsoft SQL Server 2012 (SP3) (KB3072779) – 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 9600: ) In this article by David Barbarin […]
We're on Twitter now with an official account. Please follow @sqlsatofficial to get SQL Saturday news.
Listening to @MsSQLGirl and Barbara Valdez talking about 'Notebooks 101 for SQL People' .
Organized by @DBAVUG .
Did you attend my @AzureDataStudio session for @DBAFun yesterday but wanted a deeper dive on ADS itself? Check this out ... today with an awesome group of presenters... https://twitter.com/AzureSQL/status/1420368451407806464
TODAY on Data Exposed Live, join @AnalyticAnna, @MsSQLGirl,
@SysAdminDrew, @AlanYuSQL, and @VasuBhog for an Azure Data Studio Power Hour 🕘
Tune into #LearnTV:
⏰ 9:00 AM PT
🔗 http://aka.ms/LearnTV
The @AzureDataStudio takeover! #AzureSQL #SQLServer https://twitter.com/azuresql/status/1420368451407806464
TODAY on Data Exposed Live, join @AnalyticAnna, @MsSQLGirl,
@SysAdminDrew, @AlanYuSQL, and @VasuBhog for an Azure Data Studio Power Hour 🕘
Tune into #LearnTV:
⏰ 9:00 AM PT
🔗 http://aka.ms/LearnTV
Do you have correct mindset and knowledge to secure #AzureSQL Database?
Join @Surbhi_Pokharna to hear about 'Applying a... Security Mindset to Lock Down Azure SQL DB'
Thursday, August 5, 2021
6:00 PM to 8:00 PM EDT
https://www.meetup.com/North-Boston-Azure-Cloud-User-Group/events/279719873/?refund_policy=true&rv=ea1_v2&_xtd=gatlbWFpbF9jbGlja9oAJGNlNTY0MmUyLWQyM2MtNGFmMi1iNzZlLTY0NTdlMmI1MTc1Yg&utm_campaign=event-announce&_af=event&_af_eid=279719873&utm_medium=email&response=3&action=rsvp&utm_source=promo
