Lena smiled. “Same as big SQL. Try it.”
There was only one ghost in the machine. Lena discovered it on a late-night debugging session. The error appeared randomly: “LocalDB instance pipe name too long.”
Priya wrote a test that spawned 50 concurrent threads, each running a UPDATE ... OUTPUT deleted.* statement inside a SERIALIZABLE transaction. On SQLite, it would have deadlocked instantly. On LocalDB, it ran perfectly—because it was SQL Server. mssqllocaldb
She closed the terminal. The instance stopped itself after the last connection closed. No services. No leftovers. No ghosts.
She opened a PowerShell window and typed: SqlLocalDB.exe info "CodeCraftBuild" Lena smiled
Lena nodded. “It’s mssqllocaldb . Microsoft’s best-kept secret. It doesn’t try to be a production database. It tries to be a developer’s shadow—always there, perfectly identical, and gone without a trace when you look away.”
“Then we wait ten minutes per build,” Marcus shrugged. Lena discovered it on a late-night debugging session
Her lead, Marcus, had a tired solution: “Just use SQLite for tests.”