Monthly Archives: December 2008

The Von Slatt deconstructed workshop telephone

Posted by on December 29, 2008 Comments Off on The Von Slatt deconstructed workshop telephone
steampunkworkshop.com - Phone Project

steampunkworkshop.com - Phone Project

Jake made this funky-cool workshop phone by uncasing a classic Bell System wallphone and refinishing and remounting the parts. As he points out, if you do a phone like this, you’d likely want to cover the terminal block for…

read more | digg story

T-SQL – Change SQL Job Owners to SA

Posted by on December 24, 2008 Comments Off on T-SQL – Change SQL Job Owners to SA

I’m a sucker for the Maint Wizards and everytime I touch a SQL Job.. It reverts the ownership to my domain account. ( Not a Good Practice to use my domain account … I know). I manually change the ownership back to sa (actually, dbo as sa is disabled…ssssh) . OR I CAN USE THE BELOW HANDY-DANDY SCRIPT . As always .. Buyer-Beware! Written for  SQL Server 2005..

Here is a script I wrote to do the heavy lifting:

Read more »

FIX – Sql Server 2005 Performance Dashboard Reports

Posted by on December 4, 2008 Comments Off on FIX – Sql Server 2005 Performance Dashboard Reports

I Love the Sql Server 2005 Performance Dashboard Reports, but there is a slight bug that gets me from time to on systems with long uptimes.  Below Essa Mughal has the fix!

PERMALINK: http://www.tsql.ca/Default.aspx?tabid=633&EntryID=24

Posted by: Essa Mughal 7/19/2007 10:05 AM
 

Those who are using Performance Dashboard Custom Reports, they might get that error if they have not updated there script.

Difference of two datetime columns caused overflow at runtime.

Reason:
There is a function used in the script.sql, since DATEDIFF returns and int once you have connection that is more than 24 days or so old it will overflow the dattype if you modify the procedure so caluclates the differnce in minutes first converts this to milliseconds then add the number of minutes diffrence onto the start time and then calculate the remianing number of milli seconds
Read more »