Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access
In certain circumstances, we need to apply production changes or exclusive access to one or more resources by only one instance of our application, blocking other application-level accesses. With this example, using the sp_getapplock and sp_releaseapplock functions allows us to perform these functions. Additionally, we can also use the applock_test function that allows us to know whether it is possible to block the content or not depending on our needs.
