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 […]
Introduced in SQL Server 2016 (13.x) SP1 and Azure SQL Database is the USE HINT option. At the time of writing this article, there are 23 of those. You can see an up to date list by running Dynamic Management View sys.dm_exec_valid_use_hints. With the introduction of this feature, we can replace some of the trace […]
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 […]
In this blog post, I discussed some facts about Azure SQL Database Serverless. If someone wants to avoid those limitations and disable ‘Auto-pause,’ how costly is it? Suppose a serverless database is not paused and configured with 4 max vCores and 0.5 min vCores corresponding to 2.1 GB min memory. Then the minimum compute bill […]
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview Few […]
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
