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 […]
Lightning Talks! We had them the last time and they are back. We have 10 speakers lined up to cram as much content as ... possible into a 10-minute slot. Find out more at http://www.dataweekender.com and sign up.
Those ladders are not 'GREAT' ladder :(
That is the problem!
People are climbing over Trump’s $15 billion border wall with $5 ladders https://www.businessinsider.com/donald-trump-border-wall-people-climbing-with-5-dollar-ladders-2021-4?utmSource=twitter&utmContent=referral&utmTerm=topbar&referrer=twitter via @businessinsider
SSMS 18.9 had a bug. Fix is out with 18.9.1
... https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
SQLServerGeeks is conducting a Virtual Symposium on SQL Server and Azure SQL.
Learn from skilled data professionals and... gather critical knowledge on all things SQL.
http://bit.ly/ssg_vs_may_2021
#SQLServer #SQL #AzureSQL @feaselkl @EdwardPollack
@rob_rich @i619619 @dbafromthecold
Calling all SQL database administrators, this session is for you! SQL is everywhere you need it from the IoT Edge to ... your datacenter to public clouds. Learn about these options, which to choose, and why with @BobWardMS on April 28. Register: https://bit.ly/3dffR9z #AzureSQL
