November 9, 2023

DataWeekender 6.5 and Sessions for RaboEngineering, UG-Groningen and Southampton

In a recent post on Linked In I announced that I have a bit a busy week. In this post I will sum up what I have done and how it worked out. DataWeekender 6.5 DataWeekender has a special place. I am volunteering there for a quite a few times. It is always a pleasure to work with the team. Somehow this year was more special for me. I was helping other speakers, but also have a session.

October 31, 2023

Enabling Entra Authentication

Now that we have DataAPIBuilder, a SQLServer in the Cloud and a web application that should be able to use Restfull API’s it is time to setup some authentication. I am not a fan of SQL Logins. Never bin and will never be. I want Azure Authentication uhh.. Entra Authentication as it is called nowadays. Making an app usefull for EntraID there are some requirements: You need to have a tenant.

October 27, 2023

Create the connections

In the last post we have created some more settings we need, like a Free Azure SQL Database, configured our Static Web Application to use DAB and configured User Managed Identities for as well the Database as well the Static web app. In this post we will continue. First step should be to enable the SWA to connect to the database, but it might come in handy if we also can talk from our development server to the database.

October 26, 2023

Dataweekender 6.5

I am happy to announce that I have been selected to speak at Data Weekender 6.5. Saturday, November 4 2023 at 11:30 in track 1 I will be presenting the session named Opening up your database by API. I hope to pack in a few new items I learned recentlty about this exiting product. Next to presenting, I will be present in Track 1 the whole day to assist the other speakers.

October 4, 2023

Create Free Azure DB

Just a few days ago I read in an that he announced that there was a free azure database available. I am a Dutch guy. I like free. And it does fit perfectly in my dataAPI Builder stuff I am doing. Next ot the fact that I am writing this article using Github and Hugo running on Azure Static Webapp. I think this all fits in/together some how. In fact, that LinkedIn post referers now to https://learn.

September 5, 2023

SQL Saturday Oslo

Last weekend it was The-day or D-Day for me. It was the first in person event where I am presenting. My wife and I flew to Oslo from Dusseldorf. That was a breeze, sure if you know that we had the intention to take the boat from Emden to Kristiansand. See this link why… For me and my wife it looked like it had to be. When investigating traveling options end of May, we should pay only 535 for a single boat trip.

August 11, 2023

A bad dress is a good rehearsal

ok. I have to admit. I was not in the understanding that my preview session of last week should mean that I would not have a good presentation. As you might have read in my previous post on my sort of bad hairday, I have survived and taken action. Yesterday evening the Final of my investigation on #DataAPIBuilder was going to finalize. Or not? At least, when Brian Bonk Ruelokke contacted me to do a presentation for Microsoft Fabric – DK: Overview | LinkedIn on something new, I accepted that challenge.

August 1, 2023

Doing a preview presentation going wrong

Last weekend I did not post any new content to my blog nor to my linkedin profile. Reason was that I was preparing myself for a preview presentation I had today. Also, it is silly season as they call it, and there were some work requirements I needed to look at. Next to that, I am also following classes on Microsoft Fabric. I want to be prepared in Oslo, where I am speaking at September 2nd.

July 22, 2023

Knitting Data API builder together and how I tested it

In my previous posts about #DataAPIbuilder I showed you how I created an environment for it. I used the Bikestores sample code which you can download from SQLServerTutorials. The source and explanation is here. I have installed that database in a VM on my desktop. That is running SQL2019 and the full stuff is downloaded from the Microsoft site. After that I configured my Visual Studio and tried to install the Nuget Package for DataApiBuilder.

July 16, 2023

Exploring APIs and using Views or Stored Procedures

API’s are usefull if you can read documentation over them, or if you can explore them. All decent API solutions deliver you something like a Swagger interface. Such an interface is helpfull if you want to find out which API is delivering you the data you want. Swagger is included in DataAPI Builder. You will find it under: HTTP http://localhost:5000/swagger/index.html HTTPS https://localhost:5001/swagger/index.html OPENAPI https://localhost:5001/api/openapi SWAGGER https://localhost:5001/swagger I encourage you NOT to use the HTTP one.