Posts

How to bring on-premise SQL Server data into Azure Fabric Lakehouse

Image
On-premise data gateway - one of the important feature/service Azure Fabric platform is using to bring your on-premise data into Azure cloud. The data movement is secure and encrypted. You can review my my earlier post  https://splaha.blogspot.com/2025/03/use-on-premise-gateway-in-fabric-and.html   where I explain how to configure On-premise data gateway using Step 1 and Step 2. In this exaple, I'm going to use the same data conenction to pull my on-premise SQL tables using custom join SQL into Lakehouse. The entire post is self explanatory with step-by-step snapshot. I hope this will help you to understand each and individual steps as well as to execute the same at your end. Let's start with my on-premise SQL server details. As you can see the below picture, it talks about the database Employee where there are two tables EMP and DEPT. I'm going to use the same SQL into Fabric to pull the data. I assume you already created the on-premise data gateway using my earlier post...

SharePoint Framework (SPFx) - SharePoint Hackathon 2025

Image
 

Use On-Premise-Gateway In Fabric and copy data from On-prem to Azure Fabric

Image
On-Premise data gateway is an application which is required to be installed in your laptop/computer/server which connect to cloud and uses cloud services to send data back-and-forth from on-prem to cloud. This is secure data connection and data encryption is in place. Here is more about on-premise data gateway - https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem?toc=%2Ffabric%2Fdata-factory%2Ftoc.json https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem?toc=%2Ffabric%2Fdata-factory%2Ftoc.json Architecture of it - https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth?toc=%2Ffabric%2Fdata-factory%2Ftoc.json https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth?toc=%2Ffabric%2Fdata-factory%2Ftoc.json Step 1 First thing first - You need to install on-premise data gateway in your lcoal. Second thing is to open the on-premise data gateway and ensure th...

Transforming Employee Experiences - SharePoint Hackathon 2025

Image
 

SharePoint Agents - SharePoint Hackathon 2025

Image
 

SharePoint portals - SharePoint Hackathon 2025

Image
  SharePoint Portal 

Kickoff - SharePoint Hackathon - 2025

Image
  Kickoff to Innovation: SharePoint Hackathon Launch  https://www.youtube.com/live/XtpB1bEH5oo https://aka.ms/SharePoint/Agents/Trial http://aka.ms/SharePointLookBook http://aka.ms/SharePointEvent http://aka.ms/spfx

How to load CSV, or parquet data into Fabric

Image
How to load CSV or parquet  file in Microsoft Fabric and create the table to view and work the data. This post is self explanatory :) First login into Micrsoft Fabric. Go to your workspace => Create new item => upload from file => Load CSV file or file => Load to table (Either create new table or update your existing table) Once table created, click on the table to view the data. You can create your custom SQL to fine tune the data. Let's try with parquet format data. Same process: Go to your workspace => Create new item => upload from file => Load parquet file or file.   Once the file is uploaded, click on three dots (...) and click on  Load to table   Simple click on the newly create table and view the data. Again, you have option to create your own sql or notebook to work on this data.

Blazor and Razor - Notes and Tips

Image
 What is Blazor - New innovative framework for webapplication by Microsoft? Blazor is a .NET modern frontend web framework based on HTML, CSS, and C# that supports both server-side rendering and client interactivity in a single programming model: Create rich interactive UIs using C#. Share server-side and client-side app logic written in .NET. Render the UI as HTML and CSS for wide browser support, including mobile browsers. Build hybrid desktop and mobile apps with .NET and Blazor. Some of the benefits of using Blazor include: Build web UI fast with reusable components: Blazor's flexible component model makes it easy to build reusable components that you can use to assemble apps quickly. Add rich interactivity in C#: Handle arbitrary UI events from the browser and implement component logic all in C#, a modern type-safe language that is easy to learn and highly versatile. One development stack: Build your entire web app from the frontend to the backend using a single development s...

Shared Access Signature (SAS) in Azure

A shared access signature (SAS) is a signed URI that points to one or more storage resources and includes a token that contains a special set of query parameters.  Here, the token plays an important part, it indicates how the resources might be accessed by the client. Signature query parameters (sig) is constructed from the SAS parameters and signed with the key that was used to create the SAS. This signature is used by Azure Storage to authorize access to the storage resource. Azure Storage supports three types of SAS: User delegation SAS Secured with Microsoft Entra credentials and also by the permissions specified for the SAS. Applies to Blob storage only. Service SAS Secured with the storage account key. A service SAS delegates access to a resource in the following Azure Storage services: Blob storage, Queue storage, Table storage, or Azure Files. Account SAS Secured with the storage account key. An account SAS delegates access to resources in one or more of the storage service...

Intelligent Detections Configuration - Microsoft Purview

Image
To meet the compliance needs for your organization, we need to configure several insider risk management settings. These settings apply to all insider risk management policies, regardless of the template we are going to use when creating a policy.  Several areas we need to look and configure right settings there, starting from policy indicators, timeframes, detection groups, intelligent detections, data sharing, groups, assets etc. One interesting configuration area is intelligent detections. Why we need Intelligent Detections and how we can see the value Detecting unusual activities within a minimum number of daily events and place a score for unusual event. Events like increase/decrease access specific media/files/data, access request from specific range of IP or some unallowed domains, access volume data in unusual time - All these unusual events detecting by intelligent detections configuration are getting scored up, and lately this score will be transformed into low, med...