Loading Geonames.org data into SQL Server and SQL Azure or “Why Integers just aren’t the right choice for population fields”

For a current project I’ve loaded country and city data from GeoNames and since most of the guides are outdated let me briefly summarize how to get a dump (available hereย – works for the “allCountries” file or single countries). Step 1 – the schema The file is tab-delimited and follows the schema described here. The … More Loading Geonames.org data into SQL Server and SQL Azure or “Why Integers just aren’t the right choice for population fields”

My Tarifa Experiment – A little braindump for digital nomads

Tarifa is the most southern town of mainland Europe. This quaint little village lies in the middle of a gigantic national park – the Parque Natural del Estrecho. Because it sits on the Strait of Gibraltar it gets a lot of wind. This has transformed Tarifa into a mekka for kite surfing enthusiasts from all … More My Tarifa Experiment – A little braindump for digital nomads

Excluding Resource Mailboxes (e.g. rooms) from Dynamic Distribution Groups in Office365

I hadn’t noticed until today that rooms are included in Office365 dynamic groups even if you selected “Users with Exchange mailboxes”. This creates an interesting effect if you send an appointment to that group, you will automatically book all your meetings rooms as well. Not necessarily what you want. The solution is fairly straight forward. … More Excluding Resource Mailboxes (e.g. rooms) from Dynamic Distribution Groups in Office365