Skip to content

Tag Archives: microsoft

Developers, Developers, Developers, Developers…

A rather amusing video with Steve Ballmer, President of Microsoft, showing a bit of emphasis on developers.


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

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