Ensure Uniqueness of Nullable Columns

How do you ensure that duplicate keys are prevented on a column that allows NULL values?

An error has occurred. This application may no longer respond until reloaded. Reload x