How to geocode a table of address in SQL automatically?

Question

I know that ArcGIS online does this quite nicely when you add an excel table of the address to a web map, but I would like to find a way to just access my address table in SQL --> geocode it --> and (maybe) update a map service? The address table isn't updated daily, more like monthly, so it will be nice just to create a Python, JS, or some kind of script to just have this run automatically - so I don't have to worry about it. I would be using either a JS or Silverlight application to display the points.

Thanks for any advice in advance!

JoeBorgione · Answer

You need to make an odbc connection to your SQl db in order to "see" the address table.  As far as automation goes, I guess you could do it, I'm more of a hack than programmer.  You surely don't want to re-geocode existing points every month....