SQL Server 2005

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

Create time dimension with 24 hour plus values and time buckets in your data warehouse

This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.

SQL Dynamic Pivots

User defined procedure for make an HTML table from T-SQL Select statment

Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code?  You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!

An Ideal Code Review Checklist that applies for most programming languages