Find Text in Stored Procedures

Method to retrieve every text inside the stored procedures of a database

SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B
ON A.id = B.id
WHERE A.text like '%tblNames%'

Reference: http://geekswithblogs.net/whiletrue/archive/2009/02/02/find-text-in-sql-stored-procedures.aspx

Static Constructor in C#

In C#, static constructor is always private and it does not need explicit access modifier, it does not take parameters and only good for initialization of static members of class. Static constructor calls before first instance of class's object and user does not really have any control on it.

Singleton pattern also take the advantage of static constructor of C#.

Interface Implementations

Interesting post on the different implementations of Interface in C#.

AutoEventWireup

If autoeventwireup=true, ASP.NET page events will automatically subscribe to respective life cycle event. An special hash table behind the scene maintains the match. :)