Marcus leaned forward. “That’s… not possible. It’s a full SQL engine?”
“It’s SQL Server Express,” Lena said. “Same parser, same optimizer, same transaction semantics. It just runs in my process. No Windows service. No admin rights. No installers. Microsoft shipped it with Visual Studio 2012 and it’s been there ever since, hiding in plain sight.”
The new hire’s jaw dropped.
The build was failing. Again.
“That’s not a test database,” she whispered. “That’s a scalpel.” mssqllocaldb
# In the pipeline's "Initialize" step & "C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" create "CodeCraftBuild" -s & "SqlLocalDB.exe" info "CodeCraftBuild" The output was magical: Name: CodeCraftBuild Version: 13.0.4001.0 Shared name: Owner: DESKTOP-BUILD-42\jenkins Auto-create: Yes State: Running Last start time: 10:34:22 AM Instance pipe name: np:\.\pipe\LOCALDB#F365A2E6\tsql\query
The team adopted it overnight.
Except, of course, the ghost in the pipeline—but that one, they had tamed long ago.