APPLY

Part1 - https://www.navicat.com/en/company/aboutus/blog/1783-understanding-sql-server-cross-apply-and-outer-apply-queries-part

Part2 - https://www.navicat.com/en/company/aboutus/blog/1795-understanding-sql-server-cross-apply-and-outer-apply-queries-part-2

Factory

https://www.codeproject.com/Articles/1131770/Factory-Patterns-Simple-Factory-Pattern

DeadLock

deadlock in sql - https://www.sqlshack.com/understanding-the-deadlock-definition-in-sql-server/

Event Sourcing

https://docs.microsoft.com/en-us/azure/architecture/patterns/event-sourcing

CQRS

https://docs.microsoft.com/en-us/dotnet/architecture/microservices/microservice-ddd-cqrs-patterns/apply-simplified-microservice-cqrs-ddd-patterns