Monday, September 16, 2013

Tootsee Roll Likability Progression

Remember that awesome song Tootsee Roll by the 69 Boyz circa 1994. Well you may remember the song but not the awesomeness of it. That song has an amazing intro, and then proceeds to get terrible at about the 84.35 second mark. The song craters at this point in such a manner you are asking yourself what just happened.

Here is a non-scientific chart showing the likability progression of the song.

Click Image for larger version.

Wednesday, September 11, 2013

Multiple ALTER Trigger Statements SQL Server

I was trying to update multiple triggers in a single job step. The solution took me a while to come up with so I thought I would throw it in here. When running mulitple dynamic ALTER TRIGGER statements you quickly discover that you lose context. By using the sp_executesql stored procedure and specifying the database name you can preserv context during each execution.