Drop all SQL Database Connections

I must have run this a dozen times in the last few days. Dead useful, which is why I’m posting it. Mostly for my own reference

USE master

DECLARE @kill varchar(8000) = '';
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'
FROM master..sysprocesses 
WHERE dbid = db_id('MyDatabaseName')


Friday Reads – 27th November 2015 – #12

Code Coverage is a Useless Target Measure

You can have 100% code coverage and no asserts. Code coverage is still very useful for a measure of paths tested, just not very good for setting is as a target.


Test-Driven Development Is Stupid

Focusses on the lunacy of writing ALL your test cases first, rather than the Red-Green-Refactor pattern.


What Do Programmers Want?

Pretty much says it all.


3 Reasons Why Daily Scrums Take So Much Time

I remember working on a project with 45 minute scrums daily! Fortunately, these are banished to the distant past.


The Day Google Deleted Me

A small warning: some colourful language in this one. Pretty funny, though.



After a chance discussion with a colleague, I thought I’d share this. It’s an older article from 2013, but documents  why the creator of MySQL decided to fork it to create a MariaDB.


DB-Engines Ranking

Despite the sentiment of its original creator (see above article) the popularity of MySQL (now Oracle-owned) remains in rude health.



The New Framework: http://www.commitstrip.com/en/2015/11/24/the-new-framework/

Arbitrary Goals: http://dilbert.com/strip/2015-11-22