The session introduces the fundamental concepts of locking and transactional isolation in SQL Server. We will illustrate the main concurrency-control mechanisms, lock types, and the isolation levels defined by the SQL standard. Through practical examples, we will analyze phenomena such as dirty reads and blocking, with the goal of understanding the impact that isolation choices have on application consistency and performance.