I love your quote: "it’s a lot like getting paid to go to school to learn things you want to learn." It's a great way to view work because...

If you sell a product that doesn’t deliver what you promise, you won’t have many customers because, with software - people talk. In my experience, research of a product...

use master

alter database [db_name] set offline with rollback immediate

I will try this next time I replace a test DB with a copy of production. Makes sense.

Does a restore automatically...

This script will save me a lot of time when restoring test databases. It's simply and replaces a process I was doing manually.

Thanks.