Your shopping cart is empty!
She closed the lid and went home at 4:59 PM.
For the first time in months, she closed her laptop at 5:00 PM and carried it home in her bag. The battery was still at 73%.
She ran integration tests. They ran in 800ms. She ran unit tests with a fresh database. sqllocaldb stop Contoso followed by sqllocaldb delete Contoso wiped everything clean in a millisecond. microsoft sql server express localdb
"Now connect to (localdb)\Contoso ," he said.
Sarah wrote on her blog that night: "SQL Server Express LocalDB is the unsung hero of .NET development. It’s the full power of SQL Server without the ceremony. No services. No permissions. No 'I forgot the sa password.' Just (localdb)\MSSQLLocalDB and a smile." She looked at her task manager. 0% CPU. 3.2GB RAM free. Her laptop fan was silent. She closed the lid and went home at 4:59 PM
Six months later, ContosoNotes shipped.
She deleted the connection string to the bloated shared server. She replaced it with: She ran integration tests
"There isn't one," Marcus said. "It spins up on-demand. When you close your app, it goes to sleep. It's a SQL Server engine that weighs less than a paperclip." That night, Sarah refactored everything.