Hit-highlighting is a feature that many people wish Full-Text Search would support natively. See possible solutions.

I talk about the default cursor options in SQL Server and why you may want to override them.

In this tip, I talk about the use of the REMOTE join hint.

Your data type choices can sometimes have more impact than you think.

Tip : Build a quota system for SQL Server user defined tables

I share my slide deck and some photos from SQL Saturday #162 in that Cambridge.

There are lots of ways to remove time from a date, but most of them are extremely inefficient.