Data storage and retrieval for geospatial data in SQL Server 2008

I have a need to use geospatial data which will assist plotting the trainees available by region and compare wtih the sales staff region in our company. Here is a link from myssqltips that I found as part of that project.