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

WhatsApp conversations increase your medical bills? When ads are not just ads.

Europeans on the web have typically been much more privacy aware than their US counterparts. So the WhatsApp exodus post Facebook purchase (as seen in the iOS AppStore charts led by alternative clients in a number of European countries) didn’t surprise me that much. But what was unusual is my personal decision to join the… More WhatsApp conversations increase your medical bills? When ads are not just ads.

Visual Studio 2013 Preview and Apps for SharePoint

In case you installed Visual Studio 2013 Preview onto a fresh machine (in my case Windows 8.1 Preview) and ran into one of the following problems when creating an App for SharePoint install the prerequisites mentioned below… Problems on compiling the empty ASP.NET MVC (App for SharePoint template solution): The type or namespace name ‘SharePointContextFilter’… More Visual Studio 2013 Preview and Apps for SharePoint