Problem debugging stored procedures / T-SQL on (local) databases

If you run into the following error while trying to debug T-SQL in SQL Server Management Studio, the problem is that the DNS name (local) cannot be resolved:

The solution is to connect to localhost rather than (local).