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 have a really cool new feature! Now the system can automatically send calendar appointments to all accepted speakers,... so everybody can be sure they don't miss their slots, especially in virtual events where speakers are scattered around the globe.
#runhappy
@erinstellato @SQLBalls @SQLRockstar @wstrasser @SQLFlipFlopsDBA @heymiky @Kjonge @CPorteous @Transmokopter ... @landrews5807 @WidowPage @NickyvV @Ko_Ver @SQLEspresso @SqlWorldWide @mwdarab @bweissman
T-2 hours
In person #HalfMarathon
Another reason to be thankful. We lost too many in this pandemic.
Do you use dbatools against Azure SQL Databases or Managed Instances? If so, what are some of the scenarios you're using... it for? ⛅️ What's missing that you'd like to see?
