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

It’s always the little things…

Posted by CobyR on July 13th, 2006

I’m getting over more hurdles in Ruby. The amount of material on the web regarding Ruby and RoR is great, but some of the simplest things seem to take me the longest to figure out. Using Ruby to import data from some Excel spreadsheets on Windows, things are going great the win32ole automation is straightforward, […]

New Server

Posted by CobyR on June 24th, 2006

I left Vehix.com in October of 2005, however due to my four years there, and the good relationships I have had with many people there, I have continued to host my site on one of the play servers used by the technology team. That has all ended, I now have my own server up and […]