Blog · 2 files
| Name | Tags | Date | Read |
|---|---|---|---|
| September 2026 · 2 posts | |||
| why-nolock-is-still-wrong.md Beyond NOLOCK: row versioning, RCSI and SQL Server 2025 optimized locking How NOLOCK really behaves (dirty reads, skipped and duplicated rows, error 601), how RCSI and SNAPSHOT isolation replace it, and what SQL Server 2025 optimized locking adds on top, including its limits. Databases | #sql-server #concurrency #performance | 7 min | |
| swift-6-2-main-thread-and-weak-self.md Main actor, @concurrent and [weak self]: concurrency habits for Swift 6.2 How Swift 6.2's default main-actor isolation, nonisolated(nonsending) and @concurrent change where your code runs, why async does not mean background, and when [weak self] in a Task still matters. iOS | #ios #swift #concurrency | 8 min | |