×

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

Executive Summary – Always On Availability Group

December 20, 2020

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

How Are You Coping with Pandemic?

November 10, 2020

I thank Steve Jones (blog|Twitter) to allow me to host T-SQL Tuesday #123. The topic for this month is how each of us is coping with a global pandemic. I also want to acknowledge Adam Machanic’s (Blog |Twitter) vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. First, Let […]



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