I ran into this strange situation where I wanted to get Trigger Definition(the SQL content) of a specific trigger from a database. The following SQL query can used to retrieve the trigger definition programitically.SELECT DB_NAME() AS DataBaseName, dbo.SysObjects.Name AS...
WPF Extensibility Hacks or WEX - Includes EventTrigger, ReactiveTrigger, InvokeMethodAction, InvokeCommandAction etc.
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)