Developers, Developers, Developers, Developers…

Posted by CobyR on April 5th, 2007

A rather amusing video with Steve Ballmer, President of Microsoft, showing a bit of emphasis on developers. http://www.youtube.com/watch?v=KMU0tzLwhbE

sp_findtext

Posted by CobyR on January 17th, 2007

When in MS SQL server and you need to find some text in a stored proc, but you have 100’s of them, what do you do? Came accross sp_findtext when searching for an issue today. I was doing maintenance on an app I hadn’t looked at in over 18 months. sp_findtext

sp_who, sp_who2, and sp_who_3

Posted by CobyR on September 17th, 2006

I have used sp_who and sp_who2 frequently as a DBA on Microsoft SQL servers. I came across sp_who3 a year or so ago, and have used it since. It’s a handy sproc to have when working on MS SQL 2000. sp_who_3 : an enhanced and efficient version of sp_who