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 […]
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 […]
It is a great honor and privilege that I will be speaking at PASS Summit 2020. This is the first time for me to speak at the PASS Summit. This year PASS Summit is happening virtually. You have the opportunity of learning the latest in Architecture, Data Management, Analytics, and Professional Development. There are over […]
I am honored and humbled to be hosting this month’s T-SQL Tuesday, which is #132. T-SQL Tuesday is the brainchild of Adam Machanic (Blog |Twitter). December 2009 was the first T-SQL Tuesday invitation that went out by Adam. It is a monthly blog party on the second Tuesday of each month. Currently, Steve Jones (Blog|Twitter) […]
