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”

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

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

SAP .net Connector 2.0 (NCo) RFC Server in “Running” State but not appearing in SAP

Recently I was involved in upgrading an old component from one SAP server to a different one. It uses SAP Connector 2.0 which is still supported but has it’s end of life in 2013. The PROGID, Gateway Server and Host were changed to point to the new server and the application log showed that the … More SAP .net Connector 2.0 (NCo) RFC Server in “Running” State but not appearing in SAP