SQL Server rows appear to not be deleting

The Stupid Problem You are working on a database that you are not very familiar with as a developer – meaning that you are not going to think of every little thing that a DBA would think of righ...

I have no words for how bad this is

I think this should win the “Most Horrible Sproc Parameters” contest if there were such a thing. And then people wonder why I get mad when I see stuff like this. Just wow… Like I thi...

Simple Class Creator and DTO Generator

What? A long time ago back around the middle and towards the end of 2012 I decided to create a console application that would help me get very mundane repetitive work out of the way. I dubbed it the &...

How to Kill all Processes for a Specific Database

Usually you would just use the Activity Monitor like shown below… The mundane repetition of right click each process and selecting Kill Process becomes annoying after the n_th process.  ...