Azure Maps

So at the moment, I’m testing and reviewing some training material for internal use in Microsoft in February and as you may have guessed, the service is Azure Maps.

This is the service that used to be part of the Bing Api, but have now been moved into the Azure service catalog

Chris Pendleton just wrote me to let me know that Azure Maps is in fact a brand new service, written from scratch – only thing that moved from Bing is the imagery and a couple of former Bing team members – Just wanted to let you all know this, and correct the misunderstanding.

and I must say it’s been a really nice experience to work with and use during the last few days.

Using Azure Maps, you get a variety of options to integrate maps into your application, these includes in headlines:

  • Search : build applications that enable you and the users to search for adresses, Point of Interest, Businesses, contact information and much more. You even have the option to get detailed information on what the road is used for, speedlimit and more.
  • MAPS : use this to integrate the well-known quality maps from Bing into your website, application or mobile app to give the user a visual experience of the location.
  • Geocoding : Convert Lat and Lon into adresses and vise versa.
  • IP to location : Ever wanted to have an easy way to match a IP/number to the country where it is in use? Well, here is a service that gives you that, but please be aware that the service is in preview, and are subject to changes.
  • Traffic : Use this in your custom application to allow for instance your sales personel to avoid traffic jams, reduce travel time and let them choose between several available routes.
  • Routing : Use this to incorporate the shortest or fastest route to your users, allow multiple points along a route, and can be useful for development and help solve the ever occurring logistic problem, know as “the travelling salesman”
  • Timezone : Enables you ti implement time service in your application, and look up times around the globe.

The full documentation is available here, with a lot of examples and demo apps.

During the test and evaluation of the training material, I used the application Postman that allows you to build a url and header for use against a Rest API, such as Azure Maps.

The application will then get the result and present it for you in a format of your choosing, raw, json, pretty, etc. and you can then inspect the response you get from the service, even before you start a single line of code in your preferred IDE for development. But I suggest you use Visual Studio Code – that is an free and open sources code editor that runs on your selected operation system.


Start by downloading the application Postman, and install it, once installed and running, you should create a Collection for storage of the results you get.

Click on the Arrow Down besides New, and select Collection
Enter a name for the collection and click Create

Now we’re ready for testing our service, it’s a prerequisite that you have created a Azure Map Service on Azure and have your Subscription-key at hand.

  1. Start by entering the following into the URL just besides the GET function
  2. Now we’re ready to fill in some values for the keys, that we will send to the REST API.
  3. In the first key, you enter api-version and the value is 1
  4. In the next you enter query and your query for an address in value, I entered Birkedommervej 8, Vester Egede  but  i  suggest  you  use your own 😉
  5. In the next key you enter subscription-key and in value the key from your Azure Map Service
  6. Now you should have a screen looking a bit like the one below

Now once all the keys and values have been entered, you should click on the big blue SEND button, which initiates a call to the api, and then catches the result in the Postman app.

You have now called the Azure Maps api for the first time and the result you get is in this example being shown as JSON, but you could easily show it as XML instead. Here is the result in JSON that my query returned.

    "summary": {
        "query": "birkedommervej 8 vester egede",
        "queryType": "NON_NEAR",
        "queryTime": 104,
        "numResults": 1,
        "offset": 0,
        "totalResults": 1,
        "fuzzyLevel": 1
    "results": [
            "type": "Street",
            "id": "DK/STR/p0/20146",
            "score": 5.785,
            "address": {
                "streetName": "Birkedommervej",
                "municipalitySubdivision": "Vester Egede",
                "municipality": "Haslev",
                "countrySubdivision": "Sjælland",
                "postalCode": "4690",
                "countryCode": "DK",
                "country": "Denmark",
                "countryCodeISO3": "DNK",
                "freeformAddress": "Birkedommervej, 4690 Haslev (Vester Egede)"
            "position": {
                "lat": 55.26562,
                "lon": 11.96339
            "viewport": {
                "topLeftPoint": {
                    "lat": 55.26486,
                    "lon": 11.96664
                "btmRightPoint": {
                    "lat": 55.26602,
                    "lon": 11.96013

Now the next steps would be to add more keys to the query to get even more information from the API about the address at hand, as mentioned above we can get information about speedlimit, road usage etc. etc.

I hope that you got a little excited about this new service on Azure and if so, i would encourage you to go deep dive into the API and look at some of the more advanced features yourself.

I will post another post on some of the advanced features, in the upcoming weeks, so stay tuned or head over to the documentation and start yourself.

Blog reboot

New Year, New me – a sentence many of us have either used ourself or seen online for the last few weeks.

Well, here it is not a new me, as I will be the same as always 😉

But I will reboot this blog and try to have at least one weekly post on topics suchs as :

  • Data
  • Artificial Intelligence
  • Machine Learning
  • Azure Services
  • And everything in between

So if you’re into these topics, please feel free to drop in once in while and see if there’s something to your liking, also everything here will be cleaned for customer details, references and suchs, and will solely consist of reference architectures, my points on the topics and is solely my view and personal opinion.

Best regards


Bring your own SQL licenses to Azure

data_Illustration_cloudA few days ago, we announced that Microsoft Enterprise customers is now allowed to bring their own SQL Licenses to Azure VMs. This means that if a customer already have a SQL License, this license can be used on SQL Server VM images from Marketplace.

This means that they do no longer need to build their own VM, but instead can just provision a server from the marketplace and use the existing license.

Read a lot more on the official blog post

Docker Containers as Service on Microsoft Azure

safe_imageWant a deep dive into Docker Containers on Azure, then sign up for this free webinar here you will learn step by step how to deliver Containers as a Service using Docker i Microsoft Azure.

Event is held at:

Tuesday 23rd of February 10:00 AM – 11:00 AM

Speaking at SQL Konferenz next week

darmstadtTime flies, next week it is already time for the annual SQL Konferenz in Darmstadt, Germany. There I will be giving a speak on Azure Data Lake Store and Azure Data Lake Analytics, and how these can be used in different scenarios. It will be a session filled with technical information and lots of demos.

In conjunction with this, I have been asked to join Data Exposed Studio, a panel discussion together with
Oliver Engels (Panel Host) (L | T), Michael Rys (L | T) and Sascha Dittmann (L | T) – at this panel discussion we will debate The U in Big Data – Do we need a new language?

Data Exposed Studio is a panel discussion, which will be recorded on Video. The format is 45min
long and starts 15 minutes after the parallel sessions in a small TV studio we will setup at the conference.
There will be room for approx. 15 people as audience in the studio.

Panel Topic Time Panel
The U in Big Data – Do we need a new language? 24.02.2016

14:45 – 15:45

Oliver Engels (Panel Host) (L | T), Michael Rys (L | T), Kenneth M. Nielsen (L | T) and Sascha Dittmann (L | T)

Should you in any way be interested in having this session presented at your company or in any other way be interested in how to enable Azure Data Platform for you business, so not hesitate to email me or call me.

My first 30 days at Microsoft

microsoft-azure-bannerWhoa, time flies – I’ve already bee at Microsoft for a full 30 days. I feel like it was just yesterday i joined Azure Team in Denmark, but it has actually been 30 days. these 30 days have been filled with information, most of it under NDA, making it so much more interesting actually know whats going on, and not just being feed bits and pieces, when standing on the outside of the fence. The sheer amount of information is kinda overwhelming, and the ability to just ask a program group or program manager, and actually get an answer is just amazing.

Been assigned one customer to service as my primary, and as a Data Solution Architect, the future looks really bright, the client is on the move to go all in on Azure and it’ll be a game changer for both the client and Microsoft, so I am looking very much forward to doing business and advising them. Continue reading →

SQL NEXUS Call for speakers now live


Nexus noun – “That which unites or binds”


What’s alive, yes months in the planning and collaboration between very skilled people and top of the notch companies:

We are proud to open our call for speakers, for the next generation data platform conference in Copenhagen.

There will be a one day pre-conference followed by 2 full days of breakout sessions, and the venue for the event could not be more optimal, as it will be held at Cinemaxx in Copenhagen. It’s a cinema with the latest in Audio and Video, setting the most amazing stage for such an event.

We are in the process of finishing the pre-conference program, as I write this post, and the program will be released soon. The program for the 2 day of breakout sessions, is almost a blank sheet of papers, and we need YOU to submit your greatest abstract ever, and help us make this event even more spectacular than we hoped for.

So we urge all speakers local and from abroad to submit using our call for speakers page and we will wait at the mailbox for the abstracts.

If you feel like speaking at the event please go ahead and submit session(s) at our call for speakers page.

The website with more info and registration is on its way.

Useful links :
Call for speakers call for speakers page
Website : (not – completetly – live yet)
Twitter handle: @sqlnexus

Stay tuned for more info about the event…and see you soon in Copenhagen

%d bloggers like this: