×

Auto-failover Groups – GracePeriodWithDataLossHours

March 31, 2021

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 […]

Vocabulary Matters In Technical Writing

March 19, 2021

A list of items that people often get wrong. If you have a suggestion, let me know, and I will add them to this page.

Azure SQL Database – dedicated administrator connection (DAC)

March 10, 2021

As per Microsoft documentation, Diagnostic Connection for Database Administrators is available for the Azure SQL database. If you are not familiar with DAC, read this official documentation from Microsoft. By default, the connection is only allowed from a client running on the server. Network connections are not permitted unless they are configured by using the […]

T-SQL Tuesday #135: Tools Not Touching Data

February 9, 2021

I thank Mikey Bronowski (blog|Twitter) for hosting T-SQL Tuesday #135. The topic for this month is The outstanding tools of the trade that make your job awesome. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve […]

Replace Trace Flag with ‘USE HINT’

January 23, 2021

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 […]



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook