Just found this excellent post by Pinal Dave with great tips how to create spatial data and even better where to download them and how to convert it to SQL data. Great post and very nice for demo’s 🙂
Check it out here: http://blog.sqlauthority.com/2010/03/30/sql-server-world-shapefile-download-and-upload-to-database-spatial-database/