Skip to content
Image by Canva

Estimate Your Fabric Capacity Needs

Understanding the cost of Microsoft Fabric is crucial for using Fabric efficiently. Recently Microsoft published a new tool to help estimate how much Fabric capacity you really need. In this post, we’ll explore how to use the calculator effectively, what inputs matter most, and why estimating your Fabric usage is a critical part of managing budgets and avoiding surprises. Capacity First let’s talk a little bit about capacity in Fabric as it is one the most critical part of the… Read More »Estimate Your Fabric Capacity Needs

Photo by Pixabay: https://www.pexels.com/photo/wine-tank-room-434311/

Working with Fabric Warehouse Data in PySpark Notebooks

I noticed today that there are surprisingly few samples/blog posts/guides about how to write (and read) data into warehouse from Fabric notebook. You can find lot of information about doing it through T-SQL Notebook, but you can actually use it from Spark Notebook through the Spark connector. Let me show you how.

Spark Connector

The Spark connector for Fabric Data Warehouse allows Spark Notebooks to read data from warehouse and …

Generated with ChatGPT

Build and Connect Blazor Chat App with MCP C# SDK

In my previous blog post, I showed how you can create your own MCP server with C#. In this post we are going to build a Blazor Web Chat application that connects to that server and utilizes local LLAMA 3.1 model with Ollama. This means that our client, MCP server and LLM model will all be running in our local environment.

What is MCP C# SDK?

We are …

Photo by InstaWalli: https://www.pexels.com/photo/brown-cardboard-robot-artwork-176842/

Build Your Own MCP Server with MCP C# SDK

In early April Microsoft published C# SDK for MCP Server. If you aren’t familiar with MCP you can check great definition from Philipp Schmid blog. If you are too lazy to read it I can give you a short intro: MCP is a standardized way to give capabilities for LLM apps. That is like most simplified way to intro it. You can implement your own tools (servers in MCP …

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 …

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 …