SQL Server 2005

Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.

If you have an issue with a slow part of a site after a large dataload, that you can't replicate after a DB restore, it's likely you could be dealing with a similar issue.

How to count consecutive dates using SQL

This post will show you how to fix orphaned SQL users.

SQL Dynamic Pivots

An Ideal Code Review Checklist that applies for most programming languages

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!

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