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.

July 11, 2023

PascalCase Reading exercises for MicrosoftFabric

Camel C(h)asing? Last Friday I was finding out how to get the API builder installed. That was for a non programmer not that easy, but there is plenty of documentation on Microsoft Learn which is usefull. Today, I will try to build the connection to my SQL Instance which is running on premise in a VM. My NUC can do this.. It is awesome to get this done. Since I do not know what or where it should run, I just opened VSCode and start to write a Powershell like thing because I know I have to repeat some of this stuff sooner or later.

July 7, 2023

Continue my investigation journey on Data API Builder

After my install yesterday, I could easily read what to do. But, Microsoft Learn is telling you something else. Where MS Learn tells you to do > dab --version I found that returned an error message: dab : The term 'dab' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

July 6, 2023

Going to Microsoft Fabric Usergroup Denmark

One of my friends invited me to do something on his Data Fabric usergroup Denmark in August. He wanted me to do a thing else than the Defender stuff. So I opted in for something new. I have read and seen some nice videos about a Open Source tool from Microsoft called Data API Builder. But, since it is new for me and I am eager to learn it. It is fun to do.

June 24, 2023

Before going to Oslo, you need to ride the Toboggan first

Well, I was in the understanding that after DataYork, I would need to “travel” to Oslo in the beginning of September… But things will end up different I understand. Just after pressing the Closing button for the DataYork user group, Sessionize contacted me that I am invited to do Data Toboggan on June 24th. Yes that is during my holidays. But, no problem. I can do! Due to rain last Thursday we drove home from Collogne.

June 20, 2023

T-SQL tuesday 163: Best career advice?

This months invitation for T-SQL tuesday came from Gethyn Ellis (B | L | T) . Here original request is explained here. Gethyn made a flying start with this request. He was one week late. But, Steve Jones (@wayoutwest and Steve Jones | LinkedIn) has given him the opportunity to continue the Journey. The full request of what Gethyn wants to know from us is: What is the best piece of Career Advice you have ever received as a data professional?

June 2, 2023

Leaving DataYork, Thank you

Yesterday evening my first public speaking became a fact. Despite only a few people joined, I really enjoyed speaking. Presenting for a small number of people is really nice if it is your first time in public. I must admit, I have spoken and presented in a lot of meetings in the company, but not really in public. So it is time to go and to make some notes actionable.