In development and testing environments we quite often have to drop databases and re-create them from scratch. It’s a little bit annoying when you need to right on click the database in SQL Management Studio, select Delete, and even put a tick on “Close existing connections” to be able to delete the database when it’s in use.Continue reading Force drop database when in use
A quick reminder on how to select all tables from a MSSQL database. These two queries below can select all tables from any database including master database.Continue reading Select all tables from database
This is my the very first blog post :)
I’ve decided to create a blog like a single storage for all my code snippets, samples, notes and ideas. This will help me to have everything easily searchable and in one location, and avoid syncing text/sql/cs files via DropBox on different machines at work/home.Continue reading Hello world!