Skip to content
Photo by Vlad Alexandru Popa: https://www.pexels.com/photo/photo-of-audi-parked-near-trees-1402787/

Part II: Microsoft Fabric GraphQL Performance

This blog post is second part of my Fabric GraphQL testing posts. You can find the first part HERE. I have been using Fabric SQL Analytics Endpoint to build solutions in where Fabric data is used outside of Fabric. You can quite easily integrate into endpoint and fetch data with .NET app by using the MSAL authentication library (Only Service Principal access is supported at the moment). However the SQL Endpoint performance hasn’t been really consistent and that can cause… Read More »Part II: Microsoft Fabric GraphQL Performance

Part I: Use Microsoft Fabric GraphQL API with .NET App

Microsoft Fabric’s GraphQL API allows querying data stores in a flexible and efficient way. In this post I will walk through how you can integrate the Fabric GraphQL API into a .NET application, covering authentication, making queries, and handling responses. We are going to implement the solution by using service principal, but you can also use the interactive auth also if you want to.

Authentication

As shown in my …

Scientific azure private endpoint image that is generated with DALL-E

Fabric Security: How to Access Private Network Azure Resources

In Azure it is good practice (well I would say mandatory practice) to restrict database and Key Vault access by setting network restrictions for the Azure resource. Typically enterprises has their own virtual networks set and database/Key Vault access is restricted to those networks only. I recommend to disable the “Allow Azure services and resources to access this server” for SQL databases as it allows all Azure users …

Image of fantasy library with vibrant color. Generated with Canva AI

What is Microsoft.Extensions.AI Library and Will It Replace Semantic Kernel?

Microsoft has published new AI library (well, technically it is just LLM library, but nowadays AI = LLM) in preview. This library is called Microsoft.Extensions.AI. With this library, developers can abstract away what LLM service (like OpenAI) they are using and easily leverage basic chat functionality from LLM. Sounds a lot like Semantic Kernel, doesn’t it? So what is the difference and when you should use this library …

Reflections on 2024: A Year of Growth and Success?

Year 2024 has come to an end. In general 2024 was a hard year for lots of people. Macro economy wasn’t that good here in Finland, lots of my friends were having troubles or disturbs in their personal life and in general the mood wasn’t that good. The on-going war in Ukraine and uncertainty in the geopolitical atmosphere is taking the toll on many of us. It is just one …

DP-600: Microsoft Certified Fabric Analytics Engineer Associate

During early December, Microsoft held a Fabric certification challenge, which required participants to:

  1. Join the Fabric Community.
  2. Complete all modules in the Microsoft Learn Challenge | Ignite Edition: Fabric Challenge.
  3. Not already hold the Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) certification.
  4. Be confident that they could take and pass the DP-600 exam by December 31, 2024.

By completing these requirements, Microsoft would provide a free voucher for the DP-600 …

Improve Pull Requests with Pull Request Templates

Memory. The mortal enemy of all software developers. We don’t like things that require remembering or using our memory. We prefer to automate, eliminate duplication, and avoid functions that require us to trust other people.

Creating a new pull request is a showcase of our own work. In a pull request, we expose our hidden work to the rest of the team, and they will spend their time judging it. …

How to Securely Handle Secrets with Azure Key Vault in Microsoft Fabric Notebooks

Proper secret management is one of the security fundamentals in software development. You should never hardcode credentials, secrets or tokens into your Spark Notebooks, because it creates a security vulnerability and adds extra complexity. Hardcoding secrets into Notebooks means that if you need to update any of the secrets you have to go through all the notebooks.

Azure Key Vault is a centralized secret management system, which helps you to …

Access Real-Time Data from LLM using Semantic Kernel

LLMs have been around for years now, and we have been using them for data that doesn’t change frequently. We don’t ask them for current data, like today’s weather or the balance in our bank account. Instead, we ask evergreen questions, such as who the members of the band ABBA are or whether we can eat ice cream in space (the answer is yes!).

However, since GPT-4, we have gained …

AI Toolkit for Visual Studio Code

AI Toolkit for Visual Studio Code is a “relatively” new toolset, that was previously known as Windows AI Studio. Toolkit is an extension, that allows developers to run SLMs (Small Language Models) on their local machine, or use Azure AI Studio LLM models from cloud. As you can easily use the Azure AI Studio models without any extensions like this, I find the local models more interesting …