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 […]
Happy Friday! Anyone else feel like June is flying by? Just us? But that's OK because it means we're that much closer to... next week when @SQLvariant will be presenting "Why Jupyter Notebooks are Changing Everything". Remember to RSVP and join us! https://www.meetup.com/NESQLUG/events/277115798/
Happy Friday!
Do not forget to sign up for a talk by @AnalyticAnna
"Don't miss the bus: Functions, Azure SQL, ... Geospatial, JSON"
Registration details:
https://www.meetup.com/dbavug/events/276911440/
Wednesday, June 23rd, 2021
2:00 PM EDT
1800 GMT
#Azure #AzureSQL
New Job Postings at @TheGoodrCo coming next week.
#Partnerships and #CustomerSuccess
There’s still time to submit your last-minute PASS Data Community SUMMIT abstract – CFS closes in just over 12 ... hours! Grow your speaking experience, share your expertise & help your community learn more about the #Microsoft #data platform.
Submit now: http://ow.ly/rta750FcyNW
T - 7 days
@AnalyticAnna will be talking about:
"Don't miss the bus: Functions, Azure SQL, Geospatial, JSON"
... Registration details:
https://www.meetup.com/dbavug/events/276911440/
Wednesday, June 23rd, 2021
2:00 PM EDT
1800 GMT
#Azure #AzureSQL
