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
GO

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

EXEC(@kill);

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.

http://blog.ploeh.dk/2015/11/16/code-coverage-is-a-useless-target-measure/

Test-Driven Development Is Stupid

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

http://geometrian.com/programming/tutorials/testing/test-first.php?utm_content=bufferb00bc&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

What Do Programmers Want?

Pretty much says it all.

http://henrikwarne.com/2013/03/26/what-do-programmers-want/

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.

https://dzone.com/articles/3-reasons-why-daily-scrum-takes-to-much-time

The Day Google Deleted Me

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

https://shkspr.mobi/blog/2015/11/the-day-google-deleted-me/

MariaDB

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.

http://www.computerworld.com.au/article/457551/dead_database_walking_mysql_creator_why_future_belongs_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.

http://db-engines.com/en/ranking

Comics

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

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