January 9, 2024

T-SQL Tuesday 170 – Learn Fast, fix over time

This months invitation for T-SQL tuesday came from Reitse Eskens (B | L | T). The original invite can be found here. I know Reitse quite well. He lives in the same in country, I visited one of his user groups, congratulated him on getting an MVP award, volunteerd together with him on two activities this year. I hope to continue this also this (2024) year. His invite Reitse’s question to the SQL Family is to share what we have learned from failed projects.

December 12, 2023

T-SQL Tuesday 169 – Thank you all!

This months invitation for T-SQL tuesday came from Kay Sauter (B | L | T) . The original invite can be found here. Kay knows a lot of all data related stuff. So he wondered to whom I would be gratefull about last year. Despite the knowledge on Data, his invitation is about who we should thank… Wow.. That is a lot, only looking back one year… Last year My year is a turbulent year.

December 2, 2023

The defender tales Part two: Granular deployment

For me, this year was an awesome year. I have done many new things. I found, that after all the Corana stuff I had to change a bit of the things I am doing. Just before Corona I tried getting into the world of the speaking. It is difficult to get involved. I have reached out to some people and together we made a first attempt to get into it. Few good fellows have helped me with this.

November 24, 2023

You cannot install data API Builder on Raspberry or can you?

For a specific home project at my fathers place I needed to add data to a database which was in the cloud. The only thing was that that project could only do restfull requests. Because I played with data API Builder (DAB) quite intensive I thought about pulling up a dab server on a raspberry Pi. Of course my first attempts failed. I first wanted to run the package from the cloud straight by downloading binaries and see if that would work.

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.