How can I GeoCode a table of addresses in SQL Server automatically?

Question

Hi,

Is there a way to geocode a table of addresses so that latitude and longitude columns can be updated with the correct details.

Ideally I would like a system that will operate every so often, geocoding any address that did not have a lat / long. Currently there are areound 30,000 addresses in said table.

Thanks in advance

Edit

These are indeed postal addresses for the UK area.