Drop MSSQL Database – Currently in Use

By | Engineering

When using MSSQL server in development, you may need to drop your database to have a migration/init script re-create the whole thing. If you fire off a quick ‘drop database DatabaseNameHere’, you’ll probably encounter an error “Cannot drop database ‘DatabaseNameHere’ because it is currently in use.” Here’s a command you can execute to stop any active connections and drop the…

Read More

MSSQL on Linux through Docker with Persistent Storage

By | Engineering

Microsoft continues its effort to release open source software and frameworks, with their recent release of Microsoft SQL Server that runs on Windows, Mac and Linux. This is easy to deploy and get up and running quickly with Docker containers. There are three main containers that you may want to reference as you get started. https://hub.docker.com/r/microsoft/mssql-server-linux/ https://hub.docker.com/r/microsoft/mssql-server-windows-developer/ https://hub.docker.com/r/microsoft/mssql-server-windows-express/ The first…

Read More